--- a/OBSystem/Debug/OBSystem.msi
+++ b/OBSystem/Debug/OBSystem.msi
--- a/OBSystem/Debug/setup.exe
+++ b/OBSystem/Debug/setup.exe
--- a/OBSystem/OBSystem.vdproj
+++ b/OBSystem/OBSystem.vdproj
--- a/OBSystemInstaller/Debug/OBSystemInstaller.msi
+++ b/OBSystemInstaller/Debug/OBSystemInstaller.msi
--- a/OBSystemInstaller/Debug/setup.exe
+++ b/OBSystemInstaller/Debug/setup.exe
--- a/OBSystemInstaller/OBSystemInstaller.vdproj
+++ b/OBSystemInstaller/OBSystemInstaller.vdproj
--- a/UpgradeLog.htm
+++ b/UpgradeLog.htm
--- a/UpgradeLog2.htm
+++ b/UpgradeLog2.htm
--- a/WpfApplication19/About.xaml
+++ b/WpfApplication19/About.xaml
@@ -0,0 +1,12 @@
 
				+<Window

			
 
				+	xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

			
 
				+	xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

			
 
				+	x:Class="WpfApplication19.Window1"

			
 
				+	x:Name="AboutWindow"

			
 
				+	Title="About"

			
 
				+	Width="532" Height="522" WindowStartupLocation="CenterScreen">

			
 
				+

			
 
				+	<Grid x:Name="LayoutRoot" HorizontalAlignment="Left" Width="526">

			
 
				+		<Image Margin="8,0,11,1" Source="simplico_about.png"/>

			
 
				+	</Grid>

			
 
				+</Window>
			
--- a/WpfApplication19/About.xaml.cs
+++ b/WpfApplication19/About.xaml.cs
@@ -0,0 +1,27 @@
 
				+using System;

			
 
				+using System.Collections.Generic;

			
 
				+using System.Text;

			
 
				+using System.Windows;

			
 
				+using System.Windows.Controls;

			
 
				+using System.Windows.Data;

			
 
				+using System.Windows.Documents;

			
 
				+using System.Windows.Input;

			
 
				+using System.Windows.Media;

			
 
				+using System.Windows.Media.Imaging;

			
 
				+using System.Windows.Shapes;

			
 
				+

			
 
				+namespace WpfApplication19

			
 
				+{

			
 
				+	/// <summary>

			
 
				+	/// Interaction logic for Window1.xaml

			
 
				+	/// </summary>

			
 
				+	public partial class Window1 : Window

			
 
				+	{

			
 
				+		public Window1()

			
 
				+		{

			
 
				+			this.InitializeComponent();

			
 
				+			

			
 
				+			// Insert code required on object creation below this point.

			
 
				+		}

			
 
				+	}

			
 
				+}
			
--- a/WpfApplication19/Alert.xaml
+++ b/WpfApplication19/Alert.xaml
@@ -0,0 +1,14 @@
 
				+<Window x:Class="WpfApplication19.Alert"

			
 
				+        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

			
 
				+        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

			
 
				+        Title="Alert" Height="257" Width="510">

			
 
				+    <Grid>

			
 
				+		<TextBlock Height="43" HorizontalAlignment="Left" Margin="12,34,0,0" Name="MainWarningMsg" Text="TextBlock" VerticalAlignment="Top" Width="464" TextAlignment="Center" FontSize="26" Foreground="#FFFF0A0A" />

			
 
				+		<TextBlock Height="23" HorizontalAlignment="Left" Margin="69,94,0,0" Name="textBlock2" Text="Please replace new measurement header, because it exceeds the limit" VerticalAlignment="Top" Width="344" />

			
 
				+		<TextBlock Height="23" HorizontalAlignment="Left" Margin="123,123,0,0" Name="textBlock3" Text="If header replaced successful, press OK" VerticalAlignment="Top" Width="219" />

			
 
				+		<Button Content="OK" Height="39" HorizontalAlignment="Right" Margin="0,152,120,0" Name="ChangeBtn" VerticalAlignment="Top" Width="120" FontSize="24" Click="ChangeBtn_Click" />

			
 
				+		<Button Content="Stop Alert" Height="39" HorizontalAlignment="Left" Margin="96,152,0,0" Name="stopAlert" VerticalAlignment="Top" Width="132" FontWeight="Normal" FontSize="20" Click="stopAlert_Click" />

			
 
				+		<MediaElement Height="44" HorizontalAlignment="Left" Margin="366,174,0,0" Name="warningSound" VerticalAlignment="Top" Width="122" Source="sounds/Tornado_Siren.mp3" LoadedBehavior="Manual" Volume="1" />

			
 
				+	</Grid>

			
 
				+

			
 
				+</Window>

			
--- a/WpfApplication19/Alert.xaml.cs
+++ b/WpfApplication19/Alert.xaml.cs
@@ -0,0 +1,44 @@
 
				+using System;

			
 
				+using System.Collections.Generic;

			
 
				+using System.Linq;

			
 
				+using System.Text;

			
 
				+using System.Windows;

			
 
				+using System.Windows.Controls;

			
 
				+using System.Windows.Data;

			
 
				+using System.Windows.Documents;

			
 
				+using System.Windows.Input;

			
 
				+using System.Windows.Media;

			
 
				+using System.Windows.Media.Imaging;

			
 
				+using System.Windows.Shapes;

			
 
				+

			
 
				+namespace WpfApplication19

			
 
				+{

			
 
				+	/// <summary>

			
 
				+	/// Interaction logic for Alert.xaml

			
 
				+	/// </summary>

			
 
				+	public partial class Alert : Window

			
 
				+	{

			
 
				+		public Alert()

			
 
				+		{

			
 
				+			InitializeComponent();

			
 
				+			warningSound.Play();

			
 
				+		}

			
 
				+		public void SetAlertMsg(string msg){

			
 
				+			MainWarningMsg.Text = msg;

			
 
				+		}

			
 
				+

			
 
				+		private void ChangeBtn_Click(object sender, RoutedEventArgs e)

			
 
				+		{

			
 
				+			//Application.Current.MainWindow.Show();

			
 
				+			var w = (MainWindow)Application.Current.MainWindow;

			
 
				+			//var s = ((ComboBoxItem)DateTimeCB.SelectedItem).Content.ToString();

			
 
				+			w.ResetHeaderUsage();			

			
 
				+			Close();

			
 
				+		}

			
 
				+

			
 
				+		private void stopAlert_Click(object sender, RoutedEventArgs e)

			
 
				+		{

			
 
				+			warningSound.Stop();

			
 
				+		}

			
 
				+	}

			
 
				+}

			
--- a/WpfApplication19/App.config
+++ b/WpfApplication19/App.config
@@ -0,0 +1,47 @@
 
				+<?xml version="1.0"?>

			
 
				+<configuration>

			
 
				+  <configSections>

			
 
				+  </configSections>

			
 
				+  

			
 
				+  <appSettings>

			
 
				+    

			
 
				+    

			
 
				+    <add key="machinePort" value="COM3"/>

			
 
				+   

			
 
				+    <add key="configDbCS" value="Data Source=192.168.0.253;User ID=user1;Password=1234; Initial Catalog=MGT_Config"/>

			
 
				+    <add key="masterDbCS" value="Data Source=192.168.0.253;User ID=user1;Password=1234; Initial Catalog=MGT_Master"/>

			
 
				+    <add key="tranDbCS" value="Data Source=192.168.0.253;User ID=user1;Password=1234; Initial Catalog=MGT_Trans"/>

			
 
				+    <add key="productionDbCS" value="Data Source=192.168.0.253;User ID=user1;Password=1234; Initial Catalog=OB2011DB;Connection Timeout=7200"/>

			
 
				+    <add key="operatingDbCs" value="Data Source=|DataDirectory|\OperatingDatabase.sdf"/>

			
 
				+    

			
 
				+    <add key="baudRate" value="9600"/>

			
 
				+    <add key="rlMax" value="100"/>

			
 
				+    <add key="rlMin" value="50"/>

			
 
				+    <add key="dataBits" value="8"/>

			
 
				+    <add key="stopBits" value="One"/>

			
 
				+    <add key="parity" value="None"/>

			
 
				+    <add key="webServerURL" value="http://127.0.0.1:3000"/>

			
 
				+    <add key="currentMachine" value="1"/>

			
 
				+    <add key="ClientSettingsProvider.ServiceUri" value=""/>

			
 
				+  </appSettings>

			
 
				+  <connectionStrings>

			
 
				+    <add name="labEntities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\sqlexpress;Initial Catalog=lab;User ID=user1;Password=1234;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient"/>

			
 
				+    <add name="WpfApplication19.Properties.Settings.OperatingDatabaseConnectionString" connectionString="Data Source=|DataDirectory|\OperatingDatabase.sdf" providerName="Microsoft.SqlServerCe.Client.3.5"/>

			
 
				+    <add name="WpfApplication19.Properties.Settings.SampleConnectionString" connectionString="Data Source=|DataDirectory|\Sample.sdf" providerName="Microsoft.SqlServerCe.Client.3.5"/>

			
 
				+  </connectionStrings>

			
 
				+  <startup>

			
 
				+    

			
 
				+  <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1"/></startup>

			
 
				+  <system.web>

			
 
				+    <membership defaultProvider="ClientAuthenticationMembershipProvider">

			
 
				+      <providers>

			
 
				+        <add name="ClientAuthenticationMembershipProvider" type="System.Web.ClientServices.Providers.ClientFormsAuthenticationMembershipProvider, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" serviceUri=""/>

			
 
				+      </providers>

			
 
				+    </membership>

			
 
				+    <roleManager defaultProvider="ClientRoleProvider" enabled="true">

			
 
				+      <providers>

			
 
				+        <add name="ClientRoleProvider" type="System.Web.ClientServices.Providers.ClientRoleProvider, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" serviceUri="" cacheTimeout="86400"/>

			
 
				+      </providers>

			
 
				+    </roleManager>

			
 
				+  </system.web>

			
 
				+</configuration>

			
--- a/WpfApplication19/App.xaml
+++ b/WpfApplication19/App.xaml
@@ -0,0 +1,14 @@
 
				+<Application x:Class="WpfApplication19.App"

			
 
				+             xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

			
 
				+             xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

			
 
				+             StartupUri="MainWindow.xaml">

			
 
				+    <Application.Resources>

			
 
				+         

			
 
				+    	<ResourceDictionary>

			
 
				+    		<ResourceDictionary.MergedDictionaries>

			
 
				+    			<ResourceDictionary Source="Simple Styles.xaml"/>

			
 
				+    		</ResourceDictionary.MergedDictionaries>

			
 
				+    	</ResourceDictionary>

			
 
				+         

			
 
				+    </Application.Resources>

			
 
				+</Application>

			
--- a/WpfApplication19/App.xaml.cs
+++ b/WpfApplication19/App.xaml.cs
@@ -0,0 +1,16 @@
 
				+using System;

			
 
				+using System.Collections.Generic;

			
 
				+using System.Configuration;

			
 
				+using System.Data;

			
 
				+using System.Linq;

			
 
				+using System.Windows;

			
 
				+

			
 
				+namespace WpfApplication19

			
 
				+{

			
 
				+    /// <summary>

			
 
				+    /// Interaction logic for App.xaml

			
 
				+    /// </summary>

			
 
				+    public partial class App : Application

			
 
				+    {

			
 
				+    }

			
 
				+}

			
--- a/WpfApplication19/Authentication.cs
+++ b/WpfApplication19/Authentication.cs
@@ -0,0 +1,115 @@
 
				+using System;

			
 
				+using System.Collections.Generic;

			
 
				+using System.Linq;

			
 
				+using System.Text;

			
 
				+using System.IO;

			
 
				+using System.Security.Cryptography;

			
 
				+namespace WpfApplication19

			
 
				+{

			
 
				+  class Authentication

			
 
				+  {

			
 
				+     static byte[] encryptStringToBytes_AES(string plainText, byte[] Key, byte[] IV)

			
 
				+        {

			
 
				+            // Check arguments.

			
 
				+            if (plainText == null || plainText.Length <= 0)

			
 
				+                throw new ArgumentNullException("plainText");

			
 
				+            if (Key == null || Key.Length <= 0)

			
 
				+                throw new ArgumentNullException("Key");

			
 
				+            if (IV == null || IV.Length <= 0)

			
 
				+                throw new ArgumentNullException("IV");

			
 
				+

			
 
				+            // Declare the stream used to encrypt to an in memory

			
 
				+            // array of bytes.

			
 
				+            MemoryStream msEncrypt = null;

			
 
				+

			
 
				+            // Declare the RijndaelManaged object

			
 
				+            // used to encrypt the data.

			
 
				+            RijndaelManaged aesAlg = null;

			
 
				+

			
 
				+            try

			
 
				+            {

			
 
				+                // Create a RijndaelManaged object

			
 
				+                // with the specified key and IV.

			
 
				+                aesAlg = new RijndaelManaged();

			
 
				+                aesAlg.Key = Key;

			
 
				+                aesAlg.IV = IV;

			
 
				+

			
 
				+                // Create an encrypto to perform the stream transform.

			
 
				+                ICryptoTransform encryptor = aesAlg.CreateEncryptor(aesAlg.Key, aesAlg.IV);

			
 
				+

			
 
				+                // Create the streams used for encryption.

			
 
				+                msEncrypt = new MemoryStream();

			
 
				+                using (CryptoStream csEncrypt = new CryptoStream(msEncrypt, encryptor, CryptoStreamMode.Write))

			
 
				+                {

			
 
				+                    using (StreamWriter swEncrypt = new StreamWriter(csEncrypt))

			
 
				+                    {

			
 
				+                        //Write all data to the stream.

			
 
				+                        swEncrypt.Write(plainText);

			
 
				+                    }

			
 
				+                }

			
 
				+            }

			
 
				+            finally

			
 
				+            {

			
 
				+                // Clear the RijndaelManaged object.

			
 
				+                if (aesAlg != null)

			
 
				+                    aesAlg.Clear();

			
 
				+            }

			
 
				+

			
 
				+            // Return the encrypted bytes from the memory stream.

			
 
				+            return msEncrypt.ToArray();

			
 
				+        }

			
 
				+

			
 
				+        static string decryptStringFromBytes_AES(byte[] cipherText, byte[] Key, byte[] IV)

			
 
				+        {

			
 
				+            // Check arguments.

			
 
				+            if (cipherText == null || cipherText.Length <= 0)

			
 
				+                throw new ArgumentNullException("cipherText");

			
 
				+            if (Key == null || Key.Length <= 0)

			
 
				+                throw new ArgumentNullException("Key");

			
 
				+            if (IV == null || IV.Length <= 0)

			
 
				+                throw new ArgumentNullException("IV");

			
 
				+

			
 
				+            // Declare the RijndaelManaged object

			
 
				+            // used to decrypt the data.

			
 
				+            RijndaelManaged aesAlg = null;

			
 
				+

			
 
				+            // Declare the string used to hold

			
 
				+            // the decrypted text.

			
 
				+            string plaintext = null;

			
 
				+

			
 
				+            try

			
 
				+            {

			
 
				+                // Create a RijndaelManaged object

			
 
				+                // with the specified key and IV.

			
 
				+                aesAlg = new RijndaelManaged();

			
 
				+                aesAlg.Key = Key;

			
 
				+                aesAlg.IV = IV;

			
 
				+

			
 
				+                // Create a decrytor to perform the stream transform.

			
 
				+                ICryptoTransform decryptor = aesAlg.CreateDecryptor(aesAlg.Key, aesAlg.IV);

			
 
				+                // Create the streams used for decryption.

			
 
				+                using (MemoryStream msDecrypt = new MemoryStream(cipherText))

			
 
				+                {

			
 
				+                    using (CryptoStream csDecrypt = new CryptoStream(msDecrypt, decryptor, CryptoStreamMode.Read))

			
 
				+                    {

			
 
				+                        using (StreamReader srDecrypt = new StreamReader(csDecrypt))

			
 
				+

			
 
				+                            // Read the decrypted bytes from the decrypting stream

			
 
				+                            // and place them in a string.

			
 
				+                            plaintext = srDecrypt.ReadToEnd();

			
 
				+                    }

			
 
				+                }

			
 
				+            }

			
 
				+            finally

			
 
				+            {

			
 
				+                // Clear the RijndaelManaged object.

			
 
				+                if (aesAlg != null)

			
 
				+                    aesAlg.Clear();

			
 
				+            }

			
 
				+

			
 
				+            return plaintext;

			
 
				+        }

			
 
				+

			
 
				+

			
 
				+  }

			
 
				+}

			
--- a/WpfApplication19/ChooseRecord.xaml
+++ b/WpfApplication19/ChooseRecord.xaml
@@ -0,0 +1,10 @@
 
				+<Window x:Class="WpfApplication19.ChooseRecord"

			
 
				+        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

			
 
				+        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

			
 
				+        Title="ChooseRecord" Height="136" Width="441" Name="ChooseRecordWindow">

			
 
				+    <Grid>

			
 
				+        <Label Content="Record Date Time" Height="28" HorizontalAlignment="Left" Margin="28,37,0,0" Name="label1" VerticalAlignment="Top" />

			
 
				+        <ComboBox Height="23" HorizontalAlignment="Left" Margin="139,37,0,0" Name="DateTimeCB" VerticalAlignment="Top" Width="120" />

			
 
				+        <Button Content="OK" Height="23" HorizontalAlignment="Left" Margin="280,37,0,0" Name="PreviewBtn" VerticalAlignment="Top" Width="75" Click="PreviewBtn_Click" />

			
 
				+    </Grid>

			
 
				+</Window>

			
--- a/WpfApplication19/ChooseRecord.xaml.cs
+++ b/WpfApplication19/ChooseRecord.xaml.cs
@@ -0,0 +1,61 @@
 
				+using System;

			
 
				+using System.Collections.Generic;

			
 
				+using System.Linq;

			
 
				+using System.Text;

			
 
				+using System.Windows;

			
 
				+using System.Windows.Controls;

			
 
				+using System.Windows.Data;

			
 
				+using System.Windows.Documents;

			
 
				+using System.Windows.Input;

			
 
				+using System.Windows.Media;

			
 
				+using System.Windows.Media.Imaging;

			
 
				+using System.Windows.Shapes;

			
 
				+using System.Data.Sql;

			
 
				+using System.Data.SqlClient;

			
 
				+

			
 
				+namespace WpfApplication19

			
 
				+{

			
 
				+    /// <summary>

			
 
				+    /// Interaction logic for ChooseRecord.xaml

			
 
				+    /// </summary>

			
 
				+    public partial class ChooseRecord : Window

			
 
				+    {

			
 
				+        private SqlConnection _proConn;

			
 
				+        public ChooseRecord(string lotNo)

			
 
				+        {

			
 
				+            InitializeComponent();

			
 
				+            this.LotNo = lotNo;

			
 
				+            try

			
 
				+            {

			
 
				+                _proConn = Utils.createSqlConnection("productionDbCS");

			
 
				+            }

			
 
				+            catch (SqlException se)

			
 
				+            {

			
 
				+                MessageBox.Show("productionDbCS : ", se.Message);

			
 
				+            }

			
 
				+            SetupObject();

			
 
				+            //LotNoLabel.Content = LotNo;

			
 
				+        }

			
 
				+        private void SetupObject()

			
 
				+        {

			
 
				+            SqlDataReader reader = Utils.Query(_proConn, "select updated_at from data where lot_no = '"+this.LotNo+"' group by updated_at");

			
 
				+            while (reader.Read())

			
 
				+            {

			
 
				+                

			
 
				+                DateTimeCB.Items.Add(new ComboBoxItem() { Tag = "a", Content = reader["updated_at"].ToString() });

			
 
				+            }

			
 
				+            reader.Close();

			
 
				+            //DateTimeCB.ItemsSource = 

			
 
				+        }

			
 
				+        public string LotNo { get; set; }

			
 
				+

			
 
				+        private void PreviewBtn_Click(object sender, RoutedEventArgs e)

			
 
				+        {

			
 
				+            Application.Current.MainWindow.Show();

			
 
				+            var w = (MainWindow)Application.Current.MainWindow;

			
 
				+            var s = ((ComboBoxItem)DateTimeCB.SelectedItem).Content.ToString();

			
 
				+            w.setFilterLogData(((ComboBoxItem)DateTimeCB.SelectedItem).Content.ToString());

			
 
				+            Close();

			
 
				+        }

			
 
				+    }

			
 
				+}

			
--- a/WpfApplication19/ChooseRecord2.xaml
+++ b/WpfApplication19/ChooseRecord2.xaml
@@ -0,0 +1,21 @@
 
				+<Window x:Class="WpfApplication19.ChooseRecord2"

			
 
				+        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

			
 
				+        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

			
 
				+        Title="ChooseRecord2" Height="291" Width="517" Loaded="Window_Loaded">

			
 
				+    <Grid>

			
 
				+		<Grid.RowDefinitions>

			
 
				+			<RowDefinition Height="207*" />

			
 
				+			<RowDefinition Height="45*" />

			
 
				+		</Grid.RowDefinitions>

			
 
				+		<DataGrid  AutoGenerateColumns="False" Name="chooseGrid" CanUserAddRows="False">

			
 
				+			<DataGrid.Columns>

			
 
				+				<DataGridTextColumn Header="Lot No." Width="*" Binding="{Binding lotNo}" IsReadOnly="True" />

			
 
				+				<DataGridTextColumn Header="Code" Width="*" Binding="{Binding code}" IsReadOnly="True" />

			
 
				+				<DataGridTextColumn Header="Date"  Width="*" Binding="{Binding date}" IsReadOnly="True" />

			
 
				+				<DataGridTextColumn Header="Average" Width="*" Binding="{Binding avg}" IsReadOnly="True" />

			
 
				+			</DataGrid.Columns>

			
 
				+		</DataGrid>

			
 
				+		<Button Content="Select" Grid.Row="1" Height="23" HorizontalAlignment="Left" Margin="420,10,0,0" Name="selectBtn" VerticalAlignment="Top" Width="75" Click="selectBtn_Click" />

			
 
				+		<Button Content="Cancel" Grid.Row="1" Height="23" HorizontalAlignment="Left" Margin="329,10,0,0" Name="cancel" VerticalAlignment="Top" Width="75" Click="cancel_Click" />

			
 
				+	</Grid>

			
 
				+</Window>

			
--- a/WpfApplication19/ChooseRecord2.xaml.cs
+++ b/WpfApplication19/ChooseRecord2.xaml.cs
@@ -0,0 +1,105 @@
 
				+using System;

			
 
				+using System.Collections.Generic;

			
 
				+using System.Linq;

			
 
				+using System.Text;

			
 
				+using System.Windows;

			
 
				+using System.Windows.Controls;

			
 
				+using System.Windows.Data;

			
 
				+using System.Windows.Documents;

			
 
				+using System.Windows.Input;

			
 
				+using System.Windows.Media;

			
 
				+using System.Windows.Media.Imaging;

			
 
				+using System.Windows.Shapes;

			
 
				+using System.Data.Sql;

			
 
				+using System.Data.SqlClient;

			
 
				+using System.Collections.ObjectModel;

			
 
				+using System.Windows.Interop;

			
 
				+using System.Runtime.InteropServices;

			
 
				+namespace WpfApplication19

			
 
				+{

			
 
				+	/// <summary>

			
 
				+	/// Interaction logic for ChooseRecord2.xaml

			
 
				+	/// </summary>

			
 
				+	public partial class ChooseRecord2 : Window

			
 
				+	{

			
 
				+		private string _lotNo;

			
 
				+		private SqlConnection _proConn;

			
 
				+		private ObservableCollection<RecordSelection> _recordList = new ObservableCollection<RecordSelection>();

			
 
				+		

			
 
				+		private const int GWL_STYLE = -16;

			
 
				+		private const int WS_SYSMENU = 0x80000;

			
 
				+		[DllImport("user32.dll", SetLastError = true)]

			
 
				+		private static extern int GetWindowLong(IntPtr hWnd, int nIndex);

			
 
				+		[DllImport("user32.dll")]

			
 
				+		private static extern int SetWindowLong(IntPtr hWnd, int nIndex, int dwNewLong);

			
 
				+

			
 
				+

			
 
				+		public ChooseRecord2(string lotNo)

			
 
				+		{

			
 
				+			

			
 
				+			InitializeComponent();

			
 
				+			

			
 
				+			_lotNo = lotNo;

			
 
				+			try

			
 
				+			{

			
 
				+				_proConn = Utils.createSqlConnection("productionDbCS");

			
 
				+			}

			
 
				+			catch (SqlException se)

			
 
				+			{

			
 
				+				MessageBox.Show("productionDbCS : ", se.Message);

			
 
				+			}

			
 
				+			setUpGrid();

			
 
				+		}

			
 
				+		private void setUpGrid(){

			
 
				+			/*

			
 
				+			SqlDataReader reader = Utils.Query(_proConn, "select * from data where lot_no = '" + this.LotNo + "' group by updated_at");

			
 
				+			while (reader.Read())

			
 
				+			{

			
 
				+

			
 
				+				DateTimeCB.Items.Add(new ComboBoxItem() { Tag = "a", Content = reader["updated_at"].ToString() });

			
 
				+			}

			
 
				+			reader.Close();*/

			
 
				+			SqlDataReader reader = Utils.Query(_proConn, "select * from lot_summary where lot_no = '"+_lotNo+"' order by created_at desc");

			
 
				+			while(reader.Read()){

			
 
				+					

			
 
				+					_recordList.Add(new RecordSelection(){ lotNo = reader["lot_no"].ToString(), 

			
 
				+					code = reader["code"].ToString(),

			
 
				+					date = Convert.ToDateTime(reader["created_at"]),

			
 
				+					avg = Convert.ToDouble(reader["avg"])});

			
 
				+			}

			
 
				+			chooseGrid.ItemsSource = _recordList;

			
 
				+			reader.Close();

			
 
				+		}

			
 
				+

			
 
				+		private void selectBtn_Click(object sender, RoutedEventArgs e)

			
 
				+		{

			
 
				+			RecordSelection r =  chooseGrid.SelectedItem as RecordSelection;

			
 
				+			var w = (MainWindow)Application.Current.MainWindow;

			
 
				+			try{

			
 
				+			w.setFilterLogData(r.date.ToString());

			
 
				+			Close();

			
 
				+			}catch{

			
 
				+				MessageBox.Show("Please Select A Record");

			
 
				+			}

			
 
				+		}

			
 
				+

			
 
				+		private void Window_Loaded(object sender, RoutedEventArgs e)

			
 
				+		{

			
 
				+			var hwnd = new WindowInteropHelper(this).Handle;

			
 
				+			SetWindowLong(hwnd, GWL_STYLE, GetWindowLong(hwnd, GWL_STYLE) & ~WS_SYSMENU);

			
 
				+

			
 
				+		}

			
 
				+

			
 
				+		private void cancel_Click(object sender, RoutedEventArgs e)

			
 
				+		{

			
 
				+			Close();

			
 
				+		}

			
 
				+		

			
 
				+	}

			
 
				+	class RecordSelection{

			
 
				+		public string lotNo { get; set; }

			
 
				+		public string code { get; set; }

			
 
				+		public DateTime date { get; set; }

			
 
				+		public double avg { get; set; }

			
 
				+	}

			
 
				+}

			
--- a/WpfApplication19/ChooseRecord3.xaml
+++ b/WpfApplication19/ChooseRecord3.xaml
@@ -0,0 +1,21 @@
 
				+<Window x:Class="WpfApplication19.ChooseRecord3"

			
 
				+        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

			
 
				+        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

			
 
				+        Title="ChooseRecord3" Height="291" Width="517" Loaded="Window_Loaded">

			
 
				+    <Grid>

			
 
				+		<Grid.RowDefinitions>

			
 
				+			<RowDefinition Height="207*" />

			
 
				+			<RowDefinition Height="45*" />

			
 
				+		</Grid.RowDefinitions>

			
 
				+		<DataGrid  AutoGenerateColumns="False" Name="chooseGrid" CanUserAddRows="False">

			
 
				+			<DataGrid.Columns>

			
 
				+				<DataGridTextColumn Header="Lot No." Width="*" Binding="{Binding lotNo}" IsReadOnly="True" />

			
 
				+				<DataGridTextColumn Header="Code" Width="*" Binding="{Binding code}" IsReadOnly="True" />

			
 
				+				<DataGridTextColumn Header="Date"  Width="*" Binding="{Binding date}" IsReadOnly="True" />

			
 
				+				<DataGridTextColumn Header="Average" Width="*" Binding="{Binding avg}" IsReadOnly="True" />

			
 
				+			</DataGrid.Columns>

			
 
				+		</DataGrid>

			
 
				+		<Button Content="Select" Grid.Row="1" Height="23" HorizontalAlignment="Left" Margin="420,10,0,0" Name="selectBtn" VerticalAlignment="Top" Width="75" Click="selectBtn_Click" />

			
 
				+		<Button Content="Cancel" Grid.Row="1" Height="23" HorizontalAlignment="Left" Margin="329,10,0,0" Name="cancel" VerticalAlignment="Top" Width="75" Click="cancel_Click" />

			
 
				+	</Grid>

			
 
				+</Window>

			
--- a/WpfApplication19/ChooseRecord3.xaml.cs
+++ b/WpfApplication19/ChooseRecord3.xaml.cs
@@ -0,0 +1,106 @@
 
				+using System;

			
 
				+using System.Collections.Generic;

			
 
				+using System.Linq;

			
 
				+using System.Text;

			
 
				+using System.Windows;

			
 
				+using System.Windows.Controls;

			
 
				+using System.Windows.Data;

			
 
				+using System.Windows.Documents;

			
 
				+using System.Windows.Input;

			
 
				+using System.Windows.Media;

			
 
				+using System.Windows.Media.Imaging;

			
 
				+using System.Windows.Shapes;

			
 
				+using System.Data.Sql;

			
 
				+using System.Data.SqlClient;

			
 
				+using System.Collections.ObjectModel;

			
 
				+using System.Windows.Interop;

			
 
				+using System.Runtime.InteropServices;

			
 
				+namespace WpfApplication19

			
 
				+{

			
 
				+	/// <summary>

			
 
				+	/// Interaction logic for ChooseRecord2.xaml

			
 
				+	/// </summary>

			
 
				+	public partial class ChooseRecord3 : Window

			
 
				+	{

			
 
				+		private string _lotNo;

			
 
				+		private SqlConnection _proConn;

			
 
				+		private ObservableCollection<RecordSelection> _recordList = new ObservableCollection<RecordSelection>();

			
 
				+		

			
 
				+		private const int GWL_STYLE = -16;

			
 
				+		private const int WS_SYSMENU = 0x80000;

			
 
				+		[DllImport("user32.dll", SetLastError = true)]

			
 
				+		private static extern int GetWindowLong(IntPtr hWnd, int nIndex);

			
 
				+		[DllImport("user32.dll")]

			
 
				+		private static extern int SetWindowLong(IntPtr hWnd, int nIndex, int dwNewLong);

			
 
				+

			
 
				+

			
 
				+		public ChooseRecord3(string lotNo)

			
 
				+		{

			
 
				+			

			
 
				+			InitializeComponent();

			
 
				+			

			
 
				+			_lotNo = lotNo;

			
 
				+			try

			
 
				+			{

			
 
				+				_proConn = Utils.createSqlConnection("productionDbCS");

			
 
				+			}

			
 
				+			catch (SqlException se)

			
 
				+			{

			
 
				+				MessageBox.Show("productionDbCS : ", se.Message);

			
 
				+			}

			
 
				+			setUpGrid();

			
 
				+		}

			
 
				+		private void setUpGrid(){

			
 
				+			/*

			
 
				+			SqlDataReader reader = Utils.Query(_proConn, "select * from data where lot_no = '" + this.LotNo + "' group by updated_at");

			
 
				+			while (reader.Read())

			
 
				+			{

			
 
				+

			
 
				+				DateTimeCB.Items.Add(new ComboBoxItem() { Tag = "a", Content = reader["updated_at"].ToString() });

			
 
				+			}

			
 
				+			reader.Close();*/

			
 
				+			SqlDataReader reader = Utils.Query(_proConn, "select * from lot_summary_rl where lot_no = '"+_lotNo+"' order by created_at desc");

			
 
				+			while(reader.Read()){

			
 
				+					

			
 
				+					_recordList.Add(new RecordSelection(){ lotNo = reader["lot_no"].ToString(), 

			
 
				+					code = reader["code"].ToString(),

			
 
				+					date = Convert.ToDateTime(reader["created_at"]),

			
 
				+					avg = Convert.ToDouble(reader["avg"])});

			
 
				+			}

			
 
				+			chooseGrid.ItemsSource = _recordList;

			
 
				+			reader.Close();

			
 
				+		}

			
 
				+

			
 
				+		private void selectBtn_Click(object sender, RoutedEventArgs e)

			
 
				+		{

			
 
				+			RecordSelection r =  chooseGrid.SelectedItem as RecordSelection;

			
 
				+			var w = (MainWindow)Application.Current.MainWindow;

			
 
				+			try{

			
 
				+			w._rlWindow.setFilterLogData(r.date.ToString());

			
 
				+			Close();

			
 
				+			}catch{

			
 
				+				MessageBox.Show("Please Select A Record");

			
 
				+			}

			
 
				+		}

			
 
				+

			
 
				+		private void Window_Loaded(object sender, RoutedEventArgs e)

			
 
				+		{

			
 
				+			var hwnd = new WindowInteropHelper(this).Handle;

			
 
				+			SetWindowLong(hwnd, GWL_STYLE, GetWindowLong(hwnd, GWL_STYLE) & ~WS_SYSMENU);

			
 
				+

			
 
				+		}

			
 
				+

			
 
				+		private void cancel_Click(object sender, RoutedEventArgs e)

			
 
				+		{

			
 
				+			Close();

			
 
				+		}

			
 
				+		

			
 
				+	}

			
 
				+    /*

			
 
				+	class RecordSelection{

			
 
				+		public string lotNo { get; set; }

			
 
				+		public string code { get; set; }

			
 
				+		public DateTime date { get; set; }

			
 
				+		public double avg { get; set; }

			
 
				+	}*/

			
 
				+}

			
--- a/WpfApplication19/DailyCheck.xaml
+++ b/WpfApplication19/DailyCheck.xaml
@@ -0,0 +1,119 @@
 
				+<Window x:Class="WpfApplication19.DailyCheck"

			
 
				+        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

			
 
				+        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

			
 
				+        Title="DailyCheck" mc:Ignorable="d" xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" d:DesignHeight="351" SizeToContent="WidthAndHeight" ResizeMode="CanResize" WindowStartupLocation="CenterScreen" WindowState="Maximized" Closed="Window_Closed">

			
 
				+	<Window.Resources>

			
 
				+		<Style TargetType="{x:Type DataGridCell}">

			
 
				+			<Style.Triggers>

			
 
				+				<Trigger Property="DataGridCell.IsFocused" Value="True">

			
 
				+					<Setter Property="Background" Value="#ff0000" />

			
 
				+					<Setter Property="Foreground" Value="#ffffff" />

			
 
				+				</Trigger>

			
 
				+				

			
 
				+

			
 
				+			</Style.Triggers>

			
 
				+			<Setter Property="FontSize" Value="20" />

			
 
				+		</Style>

			
 
				+		<Style x:Key="DatePickerStyle1" TargetType="{x:Type DatePicker}">

			
 
				+			<Setter Property="Foreground" Value="#FF333333"/>

			
 
				+			<Setter Property="IsTodayHighlighted" Value="True"/>

			
 
				+			<Setter Property="SelectedDateFormat" Value="Short"/>

			
 
				+			<Setter Property="Background" Value="Transparent"/>

			
 
				+			<Setter Property="Padding" Value="2"/>

			
 
				+			<Setter Property="BorderBrush">

			
 
				+				<Setter.Value>

			
 
				+					<LinearGradientBrush EndPoint=".5,0" StartPoint=".5,1">

			
 
				+						<GradientStop Color="#FFA3AEB9" Offset="0"/>

			
 
				+						<GradientStop Color="#FF8399A9" Offset="0.375"/>

			
 
				+						<GradientStop Color="#FF718597" Offset="0.375"/>

			
 
				+						<GradientStop Color="#FF617584" Offset="1"/>

			
 
				+					</LinearGradientBrush>

			
 
				+				</Setter.Value>

			
 
				+			</Setter>

			
 
				+			<Setter Property="BorderThickness" Value="1"/>

			
 
				+			<Setter Property="HorizontalContentAlignment" Value="Stretch"/>

			
 
				+			<Setter Property="Template">

			
 
				+				<Setter.Value>

			
 
				+					<ControlTemplate TargetType="{x:Type DatePicker}">

			
 
				+						<Border BorderBrush="{TemplateBinding BorderBrush}" BorderThickness="{TemplateBinding BorderThickness}" Background="{TemplateBinding Background}" Padding="{TemplateBinding Padding}">

			
 
				+							<VisualStateManager.VisualStateGroups>

			
 
				+								<VisualStateGroup x:Name="CommonStates">

			
 
				+									<VisualState x:Name="Normal"/>

			
 
				+									<VisualState x:Name="Disabled">

			
 
				+										<Storyboard>

			
 
				+											<DoubleAnimation Duration="0" To="1" Storyboard.TargetProperty="Opacity" Storyboard.TargetName="PART_DisabledVisual"/>

			
 
				+										</Storyboard>

			
 
				+									</VisualState>

			
 
				+								</VisualStateGroup>

			
 
				+							</VisualStateManager.VisualStateGroups>

			
 
				+							<Grid x:Name="PART_Root" HorizontalAlignment="{TemplateBinding HorizontalContentAlignment}" VerticalAlignment="{TemplateBinding VerticalContentAlignment}">

			
 
				+								<Grid.Resources>

			
 
				+									<SolidColorBrush x:Key="DisabledBrush" Color="#A5FFFFFF"/>

			
 
				+									<ControlTemplate x:Key="DropDownButtonTemplate" TargetType="{x:Type Button}">

			
 
				+										<Grid>

			
 
				+											<VisualStateManager.VisualStateGroups>

			
 
				+												<VisualStateGroup x:Name="CommonStates">

			
 
				+													<VisualStateGroup.Transitions>

			
 
				+														<VisualTransition GeneratedDuration="0"/>

			
 
				+														<VisualTransition GeneratedDuration="0:0:0.1" To="MouseOver"/>

			
 
				+														<VisualTransition GeneratedDuration="0:0:0.1" To="Pressed"/>

			
 
				+													</VisualStateGroup.Transitions>

			
 
				+													<VisualState x:Name="Normal"/>

			
 
				+													<VisualState x:Name="MouseOver"/>

			
 
				+													<VisualState x:Name="Pressed"/>

			
 
				+													<VisualState x:Name="Disabled"/>

			
 
				+												</VisualStateGroup>

			
 
				+											</VisualStateManager.VisualStateGroups>

			
 
				+											<Image Grid.ColumnSpan="1" Grid.RowSpan="1" Source="ical2.png" Margin="0,0,1,0.298"/>

			
 
				+										</Grid>

			
 
				+									</ControlTemplate>

			
 
				+								</Grid.Resources>

			
 
				+								<Grid.ColumnDefinitions>

			
 
				+									<ColumnDefinition Width="*"/>

			
 
				+									<ColumnDefinition Width="Auto"/>

			
 
				+								</Grid.ColumnDefinitions>

			
 
				+								<Button x:Name="PART_Button" Grid.Column="1" Foreground="{TemplateBinding Foreground}" Focusable="False" HorizontalAlignment="Left" Margin="3,0,3,0" Grid.Row="0" Template="{StaticResource DropDownButtonTemplate}" VerticalAlignment="Top" Width="30"/>

			
 
				+								<DatePickerTextBox x:Name="PART_TextBox" Grid.Column="0" Foreground="{TemplateBinding Foreground}" Focusable="{TemplateBinding Focusable}" HorizontalContentAlignment="Stretch" Grid.Row="0" VerticalContentAlignment="Stretch" FontSize="16"/>

			
 
				+								<Grid x:Name="PART_DisabledVisual" Grid.ColumnSpan="2" Grid.Column="0" IsHitTestVisible="False" Opacity="0" Grid.Row="0">

			
 
				+									<Grid.ColumnDefinitions>

			
 
				+										<ColumnDefinition Width="*"/>

			
 
				+										<ColumnDefinition Width="Auto"/>

			
 
				+									</Grid.ColumnDefinitions>

			
 
				+									<Rectangle Grid.Column="0" Fill="#A5FFFFFF" RadiusY="1" Grid.Row="0" RadiusX="1"/>

			
 
				+									<Rectangle Grid.Column="1" Fill="#A5FFFFFF" Height="18" Margin="3,0,3,0" RadiusY="1" Grid.Row="0" RadiusX="1" Width="19"/>

			
 
				+									<Popup x:Name="PART_Popup" AllowsTransparency="True" Placement="Bottom" PlacementTarget="{Binding ElementName=PART_TextBox}" StaysOpen="False"/>

			
 
				+								</Grid>

			
 
				+							</Grid>

			
 
				+						</Border>

			
 
				+					</ControlTemplate>

			
 
				+				</Setter.Value>

			
 
				+			</Setter>

			
 
				+		</Style>

			
 
				+	</Window.Resources>

			
 
				+	<Viewbox>

			
 
				+	<Grid Width="800" Height="311">

			
 
				+		<Button Content="Save" Height="32" HorizontalAlignment="Left" Margin="673,175,0,0" Name="saveBtn" VerticalAlignment="Top" Width="81" Click="saveBtn_Click" />

			
 
				+		<TextBlock Height="94" HorizontalAlignment="Left" Margin="646,67,0,0" Name="measureBlock" Text="00.00" VerticalAlignment="Top" Width="142" Background="#FF1A0202" Foreground="#FFF21919" TextAlignment="Center" FontSize="56" Padding="0,8" />

			
 
				+		<DataGrid AutoGenerateColumns="False" Height="187" HorizontalAlignment="Left" Margin="41,67,0,0" Name="dailyCheckGrid" VerticalAlignment="Top" Width="561" CanUserAddRows="False"  CanUserReorderColumns="False" CanUserSortColumns="False" Focusable="True"  SelectedValuePath="P1" SelectionUnit="FullRow" GotFocus="dailyCheckGrid_GotFocus"  Loaded="dailyCheckGrid_Loaded">

			
 
				+			<DataGrid.Columns>

			
 
				+				<DataGridTextColumn Header="Header" Width="*" Binding="{Binding header}" IsReadOnly="True"/>

			
 
				+				<DataGridTextColumn Header="P1" Width="*" Binding="{Binding p1, StringFormat=0.00}" IsReadOnly="True" />

			
 
				+				<DataGridTextColumn Header="P2" Width="*" Binding="{Binding p2, StringFormat=0.00}" IsReadOnly="True"/>

			
 
				+				<DataGridTextColumn Header="P3"  Width="*" Binding="{Binding p3, StringFormat=0.00}" IsReadOnly="True"/>

			
 
				+				<DataGridTextColumn Header="Avg"  Width="*" Binding="{Binding avg, StringFormat=0.00}" IsReadOnly="True"/>

			
 
				+				<DataGridTextColumn Header="Result"  Width="*" Binding="{Binding result}" IsReadOnly="True"/>

			
 
				+			</DataGrid.Columns>

			
 
				+		</DataGrid>

			
 
				+		<Button Content="Commit" Height="23" HorizontalAlignment="Left" Margin="527,268,0,0" Name="commitBtn" VerticalAlignment="Top" Width="75" Click="commitBtn_Click" />

			
 
				+		<DatePicker Height="29" HorizontalAlignment="Left" Margin="233.725,24.683,0,0" Name="datePicker" VerticalAlignment="Top" Width="142" Text="hello" SelectedDateChanged="datePicker_SelectedDateChanged" Style="{DynamicResource DatePickerStyle1}" RenderTransformOrigin="0.509,-0.966" />

			
 
				+		<ComboBox Height="29.858" HorizontalAlignment="Left" Margin="41,24.254,0,0" Name="shiftCB" VerticalAlignment="Top" Width="172.853" SelectedIndex="0" FontSize="16">

			
 
				+			<ComboBoxItem Content="Day ( 08.00 - 20.00 )" Tag="day" />

			
 
				+			<ComboBoxItem Content="Night ( 20.00 - 08.00 )" Tag="night" />

			
 
				+		</ComboBox>

			
 
				+		<TextBlock Height="23" HorizontalAlignment="Left" Margin="41,269,0,0" Name="textBlock1" Text="Standard values,  OB :" VerticalAlignment="Top" Foreground="#CA000000" />

			
 
				+		<TextBlock Height="23" HorizontalAlignment="Left" Margin="164,268,0,0" Name="textBlock2" Text="0.59 - 0.70" VerticalAlignment="Top" Foreground="#FF3063F0" FontWeight="Bold" FontSize="14" />

			
 
				+		<TextBlock Foreground="#CA000000" Height="23" HorizontalAlignment="Left" Margin="265,270,0,0" Name="textBlock4" Text="OC :" VerticalAlignment="Top" />

			
 
				+		<TextBlock FontSize="14" FontWeight="Bold" Foreground="#FF3063F0" Height="23" HorizontalAlignment="Left" Margin="297,268,0,0" Name="textBlock3" Text="0.28 - 0.37" VerticalAlignment="Top" />

			
 
				+	</Grid>

			
 
				+	</Viewbox>

			
 
				+</Window>

			
--- a/WpfApplication19/DailyCheck.xaml.cs
+++ b/WpfApplication19/DailyCheck.xaml.cs
@@ -0,0 +1,293 @@
 
				+using System;

			
 
				+using System.Collections.Generic;

			
 
				+using System.Linq;

			
 
				+using System.Text;

			
 
				+using System.Windows;

			
 
				+using System.Windows.Controls;

			
 
				+using System.Windows.Data;

			
 
				+using System.Windows.Documents;

			
 
				+using System.Windows.Input;

			
 
				+using System.Windows.Media;

			
 
				+using System.Windows.Media.Imaging;

			
 
				+using System.Windows.Shapes;

			
 
				+using System.Collections.ObjectModel;

			
 
				+using System.Data.SqlClient;

			
 
				+using System.Data;

			
 
				+namespace WpfApplication19

			
 
				+{

			
 
				+	/// <summary>

			
 
				+	/// Interaction logic for DailyCheck.xaml

			
 
				+	/// </summary>

			
 
				+	public partial class DailyCheck : Window

			
 
				+	{

			
 
				+		ObservableCollection<DailyChecker> _dailyChecks = new ObservableCollection<DailyChecker>();

			
 
				+		DataGridCellInfo _cell;

			
 
				+		DataGridColumn _col;

			
 
				+		DailyChecker _item;

			
 
				+		SqlConnection _proConn;

			
 
				+		DateTime _now, _tomorrow;

			
 
				+		string _shift;

			
 
				+		public DailyCheck()

			
 
				+		{

			
 
				+			InitializeComponent();

			
 
				+

			
 
				+			//nowLabel.Content = String.Format("{0:dd/MM/yyyy}", DateTime.Now);

			
 
				+			//var test = DateTime.Now + 1;

			
 
				+			_now  = DateTime.Now.Date;

			
 
				+			_tomorrow = _now.AddDays(1);

			
 
				+			var c = DateTime.Now.AddDays(1);

			
 
				+

			
 
				+			var hr = DateTime.Now.TimeOfDay.Hours;

			
 
				+			//shiftCB.SelectionChanged -= shiftCB_SelectionChanged;

			
 
				+			if(hr >= 8 && hr <= 19){

			
 
				+				_shift = "day";

			
 
				+				shiftCB.SelectedIndex = 0;

			
 
				+			}else{

			
 
				+				_shift = "night";

			
 
				+				shiftCB.SelectedIndex = 1;

			
 
				+			}

			
 
				+			

			
 
				+

			
 
				+			datePicker.SelectedDateChanged -= datePicker_SelectedDateChanged;

			
 
				+			datePicker.SelectedDate  =_now;

			
 
				+			datePicker.SelectedDateChanged += datePicker_SelectedDateChanged;

			
 
				+

			
 
				+			shiftCB.SelectionChanged += shiftCB_SelectionChanged;

			
 
				+			try

			
 
				+			{

			
 
				+				_proConn = Utils.createSqlConnection("productionDbCS");

			
 
				+			

			
 
				+			}

			
 
				+			catch (SqlException se)

			
 
				+			{

			
 
				+				MessageBox.Show("productionDbCS : ", se.Message);

			
 
				+			}

			
 
				+			//var w = (MainWindow)Application.Current.MainWindow;

			
 
				+			//_proConn = w.proConn;

			
 
				+			initDataGrid();

			
 
				+			//dailyCheckGrid.Focus();

			
 
				+

			
 
				+

			
 
				+		}

			
 
				+		void initDataGrid(){

			
 
				+			setGrid(_now, _tomorrow, _shift);

			
 
				+			

			
 
				+		

			
 
				+		}

			
 
				+

			
 
				+		private void setGrid(DateTime from, DateTime to, string shift)

			
 
				+		{

			
 
				+			var id = Utils.getSetting("currentMachine");

			
 
				+			var sql = string.Format("select * from daily_checks where created_at >= '{0:yyyy-MM-dd}' and created_at < '{1:yyyy-MM-dd}' and machine_id = {2} and shift = '{3}'"

			
 
				+			, from,to, id, shift);

			
 
				+			var reader = Utils.Query(_proConn, sql);

			
 
				+

			
 
				+			dailyCheckGrid.ItemsSource = null;

			
 
				+			_dailyChecks.Clear();

			
 
				+			if (reader.HasRows)

			
 
				+			{

			
 
				+				while (reader.Read())

			
 
				+				{

			
 
				+

			
 
				+					_dailyChecks.Add(new DailyChecker()

			
 
				+					{

			
 
				+						header = reader["header"].ToString().ToUpper(),

			
 
				+						p1 = Math.Round(Convert.ToDouble(reader["p1"]), 2),

			
 
				+						p2 = Math.Round(Convert.ToDouble(reader["p2"]), 2),

			
 
				+						p3 = Math.Round(Convert.ToDouble(reader["p3"]), 2),

			
 
				+						avg = Math.Round(Convert.ToDouble(reader["avg"]), 2),

			
 
				+						result = reader["result"].ToString()

			
 
				+					});

			
 
				+				}

			
 
				+

			
 
				+			}

			
 
				+			else

			
 
				+			{

			
 
				+				_dailyChecks.Add(new DailyChecker() { header = "OB", p1 = 0, p2 = 0, p3 = 0, avg = 0 });

			
 
				+				_dailyChecks.Add(new DailyChecker() { header = "OC", p1 = 0, p2 = 0, p3 = 0, avg = 0 });

			
 
				+				_dailyChecks.Add(new DailyChecker() { header = "RH", p1 = 0, p2 = 0, p3 = 0, avg = 0 });

			
 
				+			}

			
 
				+			reader.Close();

			
 
				+			dailyCheckGrid.Items.Clear();

			
 
				+			dailyCheckGrid.ItemsSource = _dailyChecks;

			
 
				+		}

			
 
				+

			
 
				+	

			
 
				+		private void saveBtn_Click(object sender, RoutedEventArgs e)

			
 
				+		{

			
 
				+			int row, col;

			
 
				+			string header;

			
 
				+			//dailyCheckGrid.Focus();

			
 
				+			try{

			
 
				+				header = _cell.Column.Header.ToString();

			
 
				+				row  = _dailyChecks.IndexOf((_cell.Item as DailyChecker));

			
 
				+				col = _col.DisplayIndex;

			
 
				+			}catch{

			
 
				+				dailyCheckGrid.Focus();

			
 
				+				dailyCheckGrid.CurrentCell = new DataGridCellInfo(

			
 
				+							dailyCheckGrid.Items[0], dailyCheckGrid.Columns[1]);

			
 
				+				dailyCheckGrid.BeginEdit();

			
 
				+				header = "P1";

			
 
				+				row = 0;

			
 
				+				col = 1;

			
 
				+				_item = _dailyChecks[0];

			
 
				+			}

			
 
				+			switch(header){

			
 
				+				case "P1":

			
 
				+					//var c = dailyCheckGrid.CurrentItem as DailyChecker;

			
 
				+					_item.p1 = Convert.ToDouble(measureBlock.Text);

			
 
				+				break;

			
 
				+				case "P2":

			
 
				+					_item.p2 = Convert.ToDouble(measureBlock.Text);

			
 
				+				break;

			
 
				+				case "P3":

			
 
				+					_item.p3 = Convert.ToDouble(measureBlock.Text);

			
 
				+				break;

			
 
				+				

			
 
				+			}

			
 
				+			_item.avg = Math.Round((_item.p1 + _item.p2 + _item.p3)/3, 2);

			
 
				+			if(_item.header == "OB"){

			
 
				+				if(_item.avg >= 0.59 && _item.avg <= 0.70){

			
 
				+					_item.result = "OK";

			
 
				+				}else {

			
 
				+					_item.result = "NG";

			
 
				+				}

			
 
				+			}

			
 
				+			if(_item.header == "OC"){

			
 
				+				if (_item.avg >= 0.28 && _item.avg <= 0.37)

			
 
				+				{

			
 
				+					_item.result = "OK";

			
 
				+				}

			
 
				+				else

			
 
				+				{

			
 
				+					_item.result = "NG";

			
 
				+				}

			
 
				+			}

			
 
				+			dailyCheckGrid.Items.Refresh();

			
 
				+			dailyCheckGrid.Focus();

			
 
				+			if(header != "Header" && header != "Avg" && header != "P3"){

			
 
				+				dailyCheckGrid.CurrentCell = new DataGridCellInfo(

			
 
				+						dailyCheckGrid.Items[row], dailyCheckGrid.Columns[col + 1]);

			
 
				+				dailyCheckGrid.BeginEdit();

			
 
				+			}

			
 
				+			if(header == "P3"){

			
 
				+				try{

			
 
				+				dailyCheckGrid.CurrentCell = new DataGridCellInfo(

			
 
				+						dailyCheckGrid.Items[row+1], dailyCheckGrid.Columns[1]);

			
 
				+				dailyCheckGrid.SelectedItem = dailyCheckGrid.Items[row + 1];

			
 
				+				dailyCheckGrid.BeginEdit();

			
 
				+				}catch{

			
 
				+					dailyCheckGrid.CurrentCell = new DataGridCellInfo(

			
 
				+							dailyCheckGrid.Items[0], dailyCheckGrid.Columns[1]);

			
 
				+					dailyCheckGrid.SelectedItem = dailyCheckGrid.Items[0];

			
 
				+					dailyCheckGrid.BeginEdit();

			
 
				+				}

			
 
				+			}

			
 
				+			

			
 
				+		}

			
 
				+

			
 
				+	

			
 
				+	

			
 
				+		

			
 
				+		

			
 
				+		private void dailyCheckGrid_GotFocus(object sender, RoutedEventArgs e)

			
 
				+		{

			
 
				+			_cell = dailyCheckGrid.CurrentCell;

			
 
				+			_col = dailyCheckGrid.CurrentColumn;

			
 
				+			_item = dailyCheckGrid.CurrentItem as DailyChecker;

			
 
				+			

			
 
				+		}

			
 
				+

			
 
				+		

			
 
				+

			
 
				+		private void dailyCheckGrid_Loaded(object sender, RoutedEventArgs e)

			
 
				+		{

			
 
				+			dailyCheckGrid.Focus();

			
 
				+			dailyCheckGrid.CurrentCell = new DataGridCellInfo(

			
 
				+										dailyCheckGrid.Items[0], dailyCheckGrid.Columns[1]);

			
 
				+			dailyCheckGrid.BeginEdit();

			
 
				+		}

			
 
				+

			
 
				+		private void commitBtn_Click(object sender, RoutedEventArgs e)

			
 
				+		{

			
 
				+			commitData();

			
 
				+			MessageBox.Show("Commit Daily Check Complete");

			
 
				+			Close();

			
 
				+		}

			
 
				+

			
 
				+		private void commitData()

			
 
				+		{

			
 
				+			var id = Utils.getSetting("currentMachine");

			
 
				+			var sql = string.Format("delete daily_checks where machine_id = {0} and created_at >= '{1:yyyy-MM-dd}' and created_at < '{2:yyyy-MM-dd}' and shift = '{3}'", id, _now, _tomorrow, _shift);

			
 
				+			var reader = Utils.Query(_proConn, sql);

			
 
				+			reader.Close();

			
 
				+			string empid = GlobalVars.user.empid;

			
 
				+			foreach (var item in _dailyChecks)

			
 
				+			{

			
 
				+

			
 
				+				sql = string.Format("insert into daily_checks(header, p1, p2, p3, avg, created_at, updated_at,machine_id, empid, shift, result) values('{0}', {1}, {2}, {3}, {4}, '{5}', '{6}', {7}, '{8}', '{9}', '{10}')"

			
 
				+					, item.header.ToUpper(), item.p1, item.p2, item.p3, item.avg, _now, DateTime.Now, id, empid, _shift, item.result);

			
 
				+				reader = Utils.Query(_proConn, sql);

			
 
				+				reader.Close();

			
 
				+			}

			
 
				+		}

			
 
				+

			
 
				+		private void datePicker_SelectedDateChanged(object sender, SelectionChangedEventArgs e)

			
 
				+		{

			
 
				+			//MessageBox.Show("change date");

			
 
				+			if (commitBtn.IsEnabled == true)

			
 
				+				commitData();

			
 
				+			var d =  (DateTime)datePicker.SelectedDate;

			
 
				+			var shift = (shiftCB.SelectedItem as ComboBoxItem).Tag.ToString();

			
 
				+			if (d.Date == DateTime.Now.Date && shift == _shift)

			
 
				+			{

			
 
				+				saveBtn.IsEnabled = true;

			
 
				+				commitBtn.IsEnabled = true;

			
 
				+			}

			
 
				+			else

			
 
				+			{

			
 
				+				saveBtn.IsEnabled = false;

			
 
				+				commitBtn.IsEnabled = false;

			
 
				+			}

			
 
				+			var from  = (DateTime)datePicker.SelectedDate;

			
 
				+			

			
 
				+			setGrid(from.Date, from.Date.AddDays(1), shift);

			
 
				+		}

			
 
				+

			
 
				+		private void shiftCB_SelectionChanged(object sender, SelectionChangedEventArgs e)

			
 
				+		{

			
 
				+			//var d = (DateTime)datePicker.SelectedDate;

			
 
				+			if( commitBtn.IsEnabled == true)

			
 
				+				commitData();

			
 
				+			var d = (DateTime)datePicker.SelectedDate;

			
 
				+			var shift = (shiftCB.SelectedItem as ComboBoxItem).Tag.ToString();

			
 
				+			if (d.Date == DateTime.Now.Date && shift == _shift)

			
 
				+			{

			
 
				+				saveBtn.IsEnabled = true;

			
 
				+				commitBtn.IsEnabled = true;

			
 
				+			}

			
 
				+			else

			
 
				+			{

			
 
				+				saveBtn.IsEnabled = false;

			
 
				+				commitBtn.IsEnabled = false;

			
 
				+			}

			
 
				+			var from = (DateTime)datePicker.SelectedDate;

			
 
				+

			
 
				+			setGrid(from.Date, from.Date.AddDays(1), shift);

			
 
				+		}

			
 
				+

			
 
				+		private void Window_Closed(object sender, EventArgs e)

			
 
				+		{

			
 
				+			if (commitBtn.IsEnabled == true)

			
 
				+				commitData();

			
 
				+		}

			
 
				+

			
 
				+		

			
 
				+

			
 
				+		

			
 
				+

			
 
				+		

			
 
				+		

			
 
				+		

			
 
				+	}

			
 
				+}

			
--- a/WpfApplication19/DailyChecker.cs
+++ b/WpfApplication19/DailyChecker.cs
@@ -0,0 +1,17 @@
 
				+using System;

			
 
				+using System.Collections.Generic;

			
 
				+using System.Linq;

			
 
				+using System.Text;

			
 
				+

			
 
				+namespace WpfApplication19

			
 
				+{

			
 
				+	class DailyChecker

			
 
				+	{

			
 
				+		public string header { get; set; }

			
 
				+		public double p1 {get; set; }

			
 
				+		public double p2 { get; set; }

			
 
				+		public double p3 { get; set; }

			
 
				+		public double avg { get; set; }

			
 
				+		public string result {get; set; }

			
 
				+	}

			
 
				+}

			
--- a/WpfApplication19/Debug.xaml
+++ b/WpfApplication19/Debug.xaml
@@ -0,0 +1,8 @@
 
				+<Window x:Class="WpfApplication19.Debug"

			
 
				+        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

			
 
				+        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

			
 
				+        Title="Debug" Height="300" Width="300" Name="debugWindow">

			
 
				+    <Grid>

			
 
				+        <TextBox Margin="12,12,0,0" Name="debugTextBox" TextWrapping="WrapWithOverflow" VerticalScrollBarVisibility="Auto" AcceptsReturn="True" />

			
 
				+    </Grid>

			
 
				+</Window>

			
--- a/WpfApplication19/Debug.xaml.cs
+++ b/WpfApplication19/Debug.xaml.cs
@@ -0,0 +1,26 @@
 
				+using System;

			
 
				+using System.Collections.Generic;

			
 
				+using System.Linq;

			
 
				+using System.Text;

			
 
				+using System.Windows;

			
 
				+using System.Windows.Controls;

			
 
				+using System.Windows.Data;

			
 
				+using System.Windows.Documents;

			
 
				+using System.Windows.Input;

			
 
				+using System.Windows.Media;

			
 
				+using System.Windows.Media.Imaging;

			
 
				+using System.Windows.Shapes;

			
 
				+

			
 
				+namespace WpfApplication19

			
 
				+{

			
 
				+    /// <summary>

			
 
				+    /// Interaction logic for Debug.xaml

			
 
				+    /// </summary>

			
 
				+    public partial class Debug : Window

			
 
				+    {

			
 
				+        public Debug()

			
 
				+        {

			
 
				+            InitializeComponent();

			
 
				+        }

			
 
				+    }

			
 
				+}

			
--- a/WpfApplication19/EditINWindow.xaml
+++ b/WpfApplication19/EditINWindow.xaml
@@ -0,0 +1,11 @@
 
				+<Window x:Class="WpfApplication19.EditINWindow"

			
 
				+        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

			
 
				+        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

			
 
				+        Title="IN* Editor" Height="140" Width="447" ResizeMode="NoResize" WindowStyle="None" BorderThickness="2" BorderBrush="Red" WindowStartupLocation="CenterScreen">

			
 
				+		<Grid Name="grid1">

			
 
				+			<Button Content="Save" Height="23" HorizontalAlignment="Left" Margin="177,56,0,0" Name="saveBtn" VerticalAlignment="Top" Width="75" Click="saveBtn_Click" DataContext="{Binding}" />

			
 
				+		<Label Content="Grain Size" Height="28" HorizontalAlignment="Left" Margin="25,10,0,0" Name="label1" VerticalAlignment="Top" FontWeight="Bold" FontSize="16" />

			
 
				+		<TextBox Height="26" HorizontalAlignment="Left" Margin="116,12,0,0" Name="grainSizeInput" VerticalAlignment="Top" Width="249" FontSize="16" PreviewKeyDown="grainSizeInput_PreviewKeyDown" />

			
 
				+	</Grid>

			
 
				+	

			
 
				+</Window>

			
--- a/WpfApplication19/EditINWindow.xaml.cs
+++ b/WpfApplication19/EditINWindow.xaml.cs
@@ -0,0 +1,42 @@
 
				+using System;

			
 
				+using System.Collections.Generic;

			
 
				+using System.Linq;

			
 
				+using System.Text;

			
 
				+using System.Windows;

			
 
				+using System.Windows.Controls;

			
 
				+using System.Windows.Data;

			
 
				+using System.Windows.Documents;

			
 
				+using System.Windows.Input;

			
 
				+using System.Windows.Media;

			
 
				+using System.Windows.Media.Imaging;

			
 
				+using System.Windows.Shapes;

			
 
				+

			
 
				+namespace WpfApplication19

			
 
				+{

			
 
				+	/// <summary>

			
 
				+	/// Interaction logic for EditINWindow.xaml

			
 
				+	/// </summary>

			
 
				+	public partial class EditINWindow : Window

			
 
				+	{

			
 
				+		public EditINWindow()

			
 
				+		{

			
 
				+			InitializeComponent();

			
 
				+			var w = (MainWindow)Application.Current.MainWindow;

			
 
				+			grainSizeInput.Text = w.inStarGS;

			
 
				+		}

			
 
				+

			
 
				+		private void saveBtn_Click(object sender, RoutedEventArgs e)

			
 
				+		{

			
 
				+			var w = (MainWindow)Application.Current.MainWindow;

			
 
				+			w.inStarGS = grainSizeInput.Text;

			
 
				+			this.Close();

			
 
				+		}

			
 
				+

			
 
				+		private void grainSizeInput_PreviewKeyDown(object sender, KeyEventArgs e)

			
 
				+		{

			
 
				+			if ((e.Key >= Key.D0 && e.Key <= Key.D9) || e.Key == Key.Next || e.Key == Key.Back || e.Key == Key.Delete || e.Key == Key.Left || e.Key == Key.Right)

			
 
				+				e.Handled = false;

			
 
				+			else e.Handled = true;

			
 
				+		}

			
 
				+	}

			
 
				+}

			
--- a/WpfApplication19/EditMIDWindow.xaml
+++ b/WpfApplication19/EditMIDWindow.xaml
@@ -0,0 +1,10 @@
 
				+<Window x:Class="WpfApplication19.EditMIDWindow"

			
 
				+        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

			
 
				+        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

			
 
				+        Title="MID Editor" Height="162" Width="436" WindowStartupLocation="CenterScreen" WindowStyle="None" BorderThickness="2" BorderBrush="Red">

			
 
				+    <Grid>

			
 
				+		<Label Content="Grain Size" Height="28" HorizontalAlignment="Left" Margin="35,32,0,0" Name="label1" VerticalAlignment="Top" FontWeight="Bold" FontSize="14" />

			
 
				+		<TextBox Height="28" HorizontalAlignment="Left" Margin="116,34,0,0" Name="grainSizeInput" VerticalAlignment="Top" Width="227" FontSize="14" PreviewKeyDown="grainSizeInput_PreviewKeyDown" />

			
 
				+		<Button Content="Save" Height="23" HorizontalAlignment="Left" Margin="170,78,0,0" Name="saveBtn" VerticalAlignment="Top" Width="75" Click="saveBtn_Click" />

			
 
				+	</Grid>

			
 
				+</Window>

			
--- a/WpfApplication19/EditMIDWindow.xaml.cs
+++ b/WpfApplication19/EditMIDWindow.xaml.cs
@@ -0,0 +1,45 @@
 
				+using System;

			
 
				+using System.Collections.Generic;

			
 
				+using System.Linq;

			
 
				+using System.Text;

			
 
				+using System.Windows;

			
 
				+using System.Windows.Controls;

			
 
				+using System.Windows.Data;

			
 
				+using System.Windows.Documents;

			
 
				+using System.Windows.Input;

			
 
				+using System.Windows.Media;

			
 
				+using System.Windows.Media.Imaging;

			
 
				+using System.Windows.Shapes;

			
 
				+

			
 
				+namespace WpfApplication19

			
 
				+{

			
 
				+	/// <summary>

			
 
				+	/// Interaction logic for EditMIDWindow.xaml

			
 
				+	/// </summary>

			
 
				+	public partial class EditMIDWindow : Window

			
 
				+	{

			
 
				+		public EditMIDWindow()

			
 
				+		{

			
 
				+			InitializeComponent();

			
 
				+			var w = (MainWindow)Application.Current.MainWindow;

			
 
				+			grainSizeInput.Text = w.midGS;

			
 
				+		}

			
 
				+

			
 
				+		private void saveBtn_Click(object sender, RoutedEventArgs e)

			
 
				+		{

			
 
				+			var w = (MainWindow)Application.Current.MainWindow;

			
 
				+			w.midGS = grainSizeInput.Text;

			
 
				+			this.Close();

			
 
				+		}

			
 
				+

			
 
				+		private void grainSizeInput_PreviewKeyDown(object sender, KeyEventArgs e)

			
 
				+		{

			
 
				+			if( (e.Key >= Key.D0 && e.Key <= Key.D9) || e.Key == Key.Next  || e.Key == Key.Back || e.Key == Key.Delete || e.Key == Key.Left || e.Key == Key.Right)

			
 
				+				e.Handled = false;

			
 
				+			else e.Handled = true;

			
 
				+		}

			
 
				+

			
 
				+		

			
 
				+		

			
 
				+	}

			
 
				+}

			
--- a/WpfApplication19/EditUsingTime.xaml
+++ b/WpfApplication19/EditUsingTime.xaml
@@ -0,0 +1,18 @@
 
				+<Window x:Class="WpfApplication19.EditUsingTime"

			
 
				+        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

			
 
				+        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

			
 
				+        Title="Edit Using Time" WindowStartupLocation="CenterScreen">

			
 
				+	<Viewbox Stretch="Fill">

			
 
				+    <Grid Width="400" Height="252">

			
 
				+			<Label Content="OB" Height="39" HorizontalAlignment="Left" Margin="91,72,0,0" Name="label1" VerticalAlignment="Top" FontSize="22" />

			
 
				+			<TextBox Height="28" HorizontalAlignment="Left" Margin="143,79,0,0" Name="obInput" VerticalAlignment="Top" Width="120" />

			
 
				+			<TextBlock Height="44" HorizontalAlignment="Left" Margin="32,15,0,0" Name="textBlock1" Text="You can edit using time of any header by enter value in text box and click &quot;Save&quot;" VerticalAlignment="Top" TextWrapping="Wrap" TextAlignment="Center" Width="340" Foreground="#FF5A63DB" />

			
 
				+			<Label Content="OC" FontSize="22" Height="39" HorizontalAlignment="Left" Margin="92,111,0,0" Name="label2" VerticalAlignment="Top" />

			
 
				+			<TextBox Height="28" HorizontalAlignment="Left" Margin="143,118,0,0" Name="ocInput" VerticalAlignment="Top" Width="120" />

			
 
				+			<Label Content="RH" FontSize="22" Height="39" HorizontalAlignment="Left" Margin="93,156,0,0" Name="label3" VerticalAlignment="Top" />

			
 
				+			<TextBox Height="28" HorizontalAlignment="Left" Margin="143,163,0,0" Name="rhInput" VerticalAlignment="Top" Width="120" />

			
 
				+			<Button Content="Save" Height="23" HorizontalAlignment="Left" Margin="306,212,0,0" Name="saveBtn" VerticalAlignment="Top" Width="75" Click="saveBtn_Click" />

			
 
				+		</Grid>

			
 
				+	</Viewbox>

			
 
				+	

			
 
				+</Window>

			
--- a/WpfApplication19/EditUsingTime.xaml.cs
+++ b/WpfApplication19/EditUsingTime.xaml.cs
@@ -0,0 +1,125 @@
 
				+using System;

			
 
				+using System.Collections.Generic;

			
 
				+using System.Linq;

			
 
				+using System.Text;

			
 
				+using System.Windows;

			
 
				+using System.Windows.Controls;

			
 
				+using System.Windows.Data;

			
 
				+using System.Windows.Documents;

			
 
				+using System.Windows.Input;

			
 
				+using System.Windows.Media;

			
 
				+using System.Windows.Media.Imaging;

			
 
				+using System.Windows.Navigation;

			
 
				+using System.Windows.Shapes;

			
 
				+using System.Globalization;

			
 
				+using WpfLocalization;

			
 
				+using System.Threading;

			
 
				+using System.Data.SqlClient;

			
 
				+using System.Data;

			
 
				+using System.Diagnostics;

			
 
				+using System.IO;

			
 
				+using System.Collections;

			
 
				+using System.IO.Ports;

			
 
				+using System.Collections.ObjectModel;

			
 
				+using System.Reflection;

			
 
				+using System.Configuration;

			
 
				+using System.Collections.Specialized;

			
 
				+using System.Data.SqlServerCe;

			
 
				+using System.ComponentModel;

			
 
				+using System.Windows.Threading;

			
 
				+

			
 
				+namespace WpfApplication19

			
 
				+{

			
 
				+	/// <summary>

			
 
				+	/// Interaction logic for EditUsingTime.xaml

			
 
				+	/// </summary>

			
 
				+	public partial class EditUsingTime : Window

			
 
				+	{

			
 
				+		SqlCeConnection _opConn;

			
 
				+		public EditUsingTime()

			
 
				+		{

			
 
				+			InitializeComponent();

			
 
				+			initDatabase();

			
 
				+			initUI();

			
 
				+		}

			
 
				+		void initDatabase()

			
 
				+		{

			
 
				+			try

			
 
				+			{

			
 
				+				_opConn = Utils.createSqlCeConnection("operatingDbCS");

			
 
				+

			
 
				+

			
 
				+			}

			
 
				+			catch (SqlCeException se)

			
 
				+			{

			
 
				+				MessageBox.Show("operatingDbCS : ", se.Message);

			
 
				+			}

			
 
				+		}

			
 
				+		void initUI()

			
 
				+		{

			
 
				+			obInput.Text = getUsingTime("OB").ToString();

			
 
				+			ocInput.Text = getUsingTime("OC").ToString();

			
 
				+			rhInput.Text = getUsingTime("RH").ToString();

			
 
				+		}

			
 
				+		private int getUsingTime(string header)

			
 
				+		{

			
 
				+			var reader = Utils.Query(_opConn, "select * from UsingTime");

			
 
				+			reader.Read();

			
 
				+			int v = 0;

			
 
				+			switch (header)

			
 
				+			{

			
 
				+				case "OB":

			
 
				+					v = Convert.ToInt32(reader["ob"]);

			
 
				+

			
 
				+					break;

			
 
				+				case "OC":

			
 
				+					v = Convert.ToInt32(reader["oc"]);

			
 
				+					break;

			
 
				+				case "RH":

			
 
				+					v = Convert.ToInt32(reader["rh"]);

			
 
				+					break;

			
 
				+				default:

			
 
				+					MessageBox.Show("Bad Header Name");

			
 
				+					break;

			
 
				+			}

			
 
				+			reader.Close();

			
 
				+

			
 
				+

			
 
				+			return v;

			
 
				+		}

			
 
				+

			
 
				+		private void saveBtn_Click(object sender, RoutedEventArgs e)

			
 
				+		{

			
 
				+			updateUsingTime("OB", Convert.ToInt32(obInput.Text));

			
 
				+			updateUsingTime("OC", Convert.ToInt32(ocInput.Text));

			
 
				+			updateUsingTime("RH", Convert.ToInt32(rhInput.Text));

			
 
				+			//Application.Current.MainWindow.Show();

			
 
				+			var w = (MainWindow)Application.Current.MainWindow;

			
 
				+			w.refreshUsingTime();

			
 
				+			Close();

			
 
				+		}

			
 
				+		private void updateUsingTime(string p, int n = -1)

			
 
				+		{

			
 
				+

			
 
				+			switch (p)

			
 
				+			{

			
 
				+				case "OB":

			
 
				+					Utils.Query(_opConn, "update UsingTime set ob = " + n);

			
 
				+					break;

			
 
				+				case "OC":

			
 
				+

			
 
				+

			
 
				+					Utils.Query(_opConn, "update UsingTime set oc = " + n);

			
 
				+					break;

			
 
				+				case "RH":

			
 
				+

			
 
				+					Utils.Query(_opConn, "update UsingTime set rh = " + n);

			
 
				+

			
 
				+					break;

			
 
				+				default:

			
 
				+					MessageBox.Show("Header Name Error");

			
 
				+					break;

			
 
				+			}

			
 
				+		}

			
 
				+	}

			
 
				+}

			
--- a/WpfApplication19/EncDec.cs
+++ b/WpfApplication19/EncDec.cs
@@ -0,0 +1,579 @@
 
				+using System;

			
 
				+using System.IO;

			
 
				+using System.Security.Cryptography;

			
 
				+

			
 
				+namespace WpfApplication19

			
 
				+{

			
 
				+    // 

			
 
				+

			
 
				+

			
 
				+    //    This sample code is provided "AS IS" with no warranties,

			
 
				+

			
 
				+    //    and confers no rights. 

			
 
				+

			
 
				+    // 

			
 
				+

			
 
				+    //    ATTENTION: This sample is designed to be more of a

			
 
				+

			
 
				+    //    tutorial rather than something you can copy and paste in

			
 
				+

			
 
				+    //    the production code! 

			
 
				+

			
 
				+    // 

			
 
				+

			
 
				+

			
 
				+

			
 
				+

			
 
				+    

			
 
				+

			
 
				+    // 

			
 
				+

			
 
				+    // Sample encrypt/decrypt functions 

			
 
				+

			
 
				+    // Parameter checks and error handling

			
 
				+

			
 
				+    // are ommited for better readability 

			
 
				+

			
 
				+    // 

			
 
				+

			
 
				+

			
 
				+    public class EncDec

			
 
				+    {

			
 
				+        // Encrypt a byte array into a byte array using a key and an IV 

			
 
				+

			
 
				+        public static byte[] Encrypt(byte[] clearData, byte[] Key, byte[] IV)

			
 
				+        {

			
 
				+            // Create a MemoryStream to accept the encrypted bytes 

			
 
				+

			
 
				+            MemoryStream ms = new MemoryStream();

			
 
				+

			
 
				+            // Create a symmetric algorithm. 

			
 
				+

			
 
				+            // We are going to use Rijndael because it is strong and

			
 
				+

			
 
				+            // available on all platforms. 

			
 
				+

			
 
				+            // You can use other algorithms, to do so substitute the

			
 
				+

			
 
				+            // next line with something like 

			
 
				+

			
 
				+            //      TripleDES alg = TripleDES.Create(); 

			
 
				+

			
 
				+            Rijndael alg = Rijndael.Create();

			
 
				+

			
 
				+            // Now set the key and the IV. 

			
 
				+

			
 
				+            // We need the IV (Initialization Vector) because

			
 
				+

			
 
				+            // the algorithm is operating in its default 

			
 
				+

			
 
				+            // mode called CBC (Cipher Block Chaining).

			
 
				+

			
 
				+            // The IV is XORed with the first block (8 byte) 

			
 
				+

			
 
				+            // of the data before it is encrypted, and then each

			
 
				+

			
 
				+            // encrypted block is XORed with the 

			
 
				+

			
 
				+            // following block of plaintext.

			
 
				+

			
 
				+            // This is done to make encryption more secure. 

			
 
				+

			
 
				+

			
 
				+            // There is also a mode called ECB which does not need an IV,

			
 
				+

			
 
				+            // but it is much less secure. 

			
 
				+

			
 
				+            alg.Key = Key;

			
 
				+            alg.IV = IV;

			
 
				+

			
 
				+            // Create a CryptoStream through which we are going to be

			
 
				+

			
 
				+            // pumping our data. 

			
 
				+

			
 
				+            // CryptoStreamMode.Write means that we are going to be

			
 
				+

			
 
				+            // writing data to the stream and the output will be written

			
 
				+

			
 
				+            // in the MemoryStream we have provided. 

			
 
				+

			
 
				+            CryptoStream cs = new CryptoStream(ms,

			
 
				+               alg.CreateEncryptor(), CryptoStreamMode.Write);

			
 
				+

			
 
				+            // Write the data and make it do the encryption 

			
 
				+

			
 
				+            cs.Write(clearData, 0, clearData.Length);

			
 
				+

			
 
				+            // Close the crypto stream (or do FlushFinalBlock). 

			
 
				+

			
 
				+            // This will tell it that we have done our encryption and

			
 
				+

			
 
				+            // there is no more data coming in, 

			
 
				+

			
 
				+            // and it is now a good time to apply the padding and

			
 
				+

			
 
				+            // finalize the encryption process. 

			
 
				+

			
 
				+            cs.Close();

			
 
				+

			
 
				+            // Now get the encrypted data from the MemoryStream.

			
 
				+

			
 
				+            // Some people make a mistake of using GetBuffer() here,

			
 
				+

			
 
				+            // which is not the right way. 

			
 
				+

			
 
				+            byte[] encryptedData = ms.ToArray();

			
 
				+

			
 
				+            return encryptedData;

			
 
				+        }

			
 
				+

			
 
				+        // Encrypt a string into a string using a password 

			
 
				+

			
 
				+        //    Uses Encrypt(byte[], byte[], byte[]) 

			
 
				+

			
 
				+

			
 
				+        public static string Encrypt(string clearText, string Password)

			
 
				+        {

			
 
				+            // First we need to turn the input string into a byte array. 

			
 
				+

			
 
				+            byte[] clearBytes =

			
 
				+              System.Text.Encoding.Unicode.GetBytes(clearText);

			
 
				+

			
 
				+            // Then, we need to turn the password into Key and IV 

			
 
				+

			
 
				+            // We are using salt to make it harder to guess our key

			
 
				+

			
 
				+            // using a dictionary attack - 

			
 
				+

			
 
				+            // trying to guess a password by enumerating all possible words. 

			
 
				+

			
 
				+            PasswordDeriveBytes pdb = new PasswordDeriveBytes(Password,

			
 
				+                new byte[] {0x49, 0x76, 0x61, 0x6e, 0x20, 0x4d, 

			
 
				+            0x65, 0x64, 0x76, 0x65, 0x64, 0x65, 0x76});

			
 
				+

			
 
				+            // Now get the key/IV and do the encryption using the

			
 
				+

			
 
				+            // function that accepts byte arrays. 

			
 
				+

			
 
				+            // Using PasswordDeriveBytes object we are first getting

			
 
				+

			
 
				+            // 32 bytes for the Key 

			
 
				+

			
 
				+            // (the default Rijndael key length is 256bit = 32bytes)

			
 
				+

			
 
				+            // and then 16 bytes for the IV. 

			
 
				+

			
 
				+            // IV should always be the block size, which is by default

			
 
				+

			
 
				+            // 16 bytes (128 bit) for Rijndael. 

			
 
				+

			
 
				+            // If you are using DES/TripleDES/RC2 the block size is

			
 
				+

			
 
				+            // 8 bytes and so should be the IV size. 

			
 
				+

			
 
				+            // You can also read KeySize/BlockSize properties off

			
 
				+

			
 
				+            // the algorithm to find out the sizes. 

			
 
				+

			
 
				+            byte[] encryptedData = Encrypt(clearBytes,

			
 
				+                     pdb.GetBytes(32), pdb.GetBytes(16));

			
 
				+

			
 
				+            // Now we need to turn the resulting byte array into a string. 

			
 
				+

			
 
				+            // A common mistake would be to use an Encoding class for that.

			
 
				+

			
 
				+            //It does not work because not all byte values can be

			
 
				+

			
 
				+            // represented by characters. 

			
 
				+

			
 
				+            // We are going to be using Base64 encoding that is designed

			
 
				+

			
 
				+            //exactly for what we are trying to do. 

			
 
				+

			
 
				+            return Convert.ToBase64String(encryptedData);

			
 
				+

			
 
				+        }

			
 
				+

			
 
				+        // Encrypt bytes into bytes using a password 

			
 
				+

			
 
				+        //    Uses Encrypt(byte[], byte[], byte[]) 

			
 
				+

			
 
				+

			
 
				+        public static byte[] Encrypt(byte[] clearData, string Password)

			
 
				+        {

			
 
				+            // We need to turn the password into Key and IV. 

			
 
				+

			
 
				+            // We are using salt to make it harder to guess our key

			
 
				+

			
 
				+            // using a dictionary attack - 

			
 
				+

			
 
				+            // trying to guess a password by enumerating all possible words. 

			
 
				+

			
 
				+            PasswordDeriveBytes pdb = new PasswordDeriveBytes(Password,

			
 
				+                new byte[] {0x49, 0x76, 0x61, 0x6e, 0x20, 0x4d, 

			
 
				+            0x65, 0x64, 0x76, 0x65, 0x64, 0x65, 0x76});

			
 
				+

			
 
				+            // Now get the key/IV and do the encryption using the function

			
 
				+

			
 
				+            // that accepts byte arrays. 

			
 
				+

			
 
				+            // Using PasswordDeriveBytes object we are first getting

			
 
				+

			
 
				+            // 32 bytes for the Key 

			
 
				+

			
 
				+            // (the default Rijndael key length is 256bit = 32bytes)

			
 
				+

			
 
				+            // and then 16 bytes for the IV. 

			
 
				+

			
 
				+            // IV should always be the block size, which is by default

			
 
				+

			
 
				+            // 16 bytes (128 bit) for Rijndael. 

			
 
				+

			
 
				+            // If you are using DES/TripleDES/RC2 the block size is 8

			
 
				+

			
 
				+            // bytes and so should be the IV size. 

			
 
				+

			
 
				+            // You can also read KeySize/BlockSize properties off the

			
 
				+

			
 
				+            // algorithm to find out the sizes. 

			
 
				+

			
 
				+            return Encrypt(clearData, pdb.GetBytes(32), pdb.GetBytes(16));

			
 
				+

			
 
				+        }

			
 
				+

			
 
				+        // Encrypt a file into another file using a password 

			
 
				+

			
 
				+        public static void Encrypt(string fileIn,

			
 
				+                    string fileOut, string Password) 

			
 
				+    { 

			
 
				+

			
 
				+        // First we are going to open the file streams 

			
 
				+

			
 
				+        FileStream fsIn = new FileStream(fileIn, 

			
 
				+            FileMode.Open, FileAccess.Read); 

			
 
				+        FileStream fsOut = new FileStream(fileOut, 

			
 
				+            FileMode.OpenOrCreate, FileAccess.Write); 

			
 
				+

			
 
				+        // Then we are going to derive a Key and an IV from the

			
 
				+

			
 
				+        // Password and create an algorithm 

			
 
				+

			
 
				+        PasswordDeriveBytes pdb = new PasswordDeriveBytes(Password, 

			
 
				+            new byte[] {0x49, 0x76, 0x61, 0x6e, 0x20, 0x4d, 

			
 
				+            0x65, 0x64, 0x76, 0x65, 0x64, 0x65, 0x76}); 

			
 
				+

			
 
				+        Rijndael alg = Rijndael.Create(); 

			
 
				+        alg.Key = pdb.GetBytes(32); 

			
 
				+        alg.IV = pdb.GetBytes(16); 

			
 
				+

			
 
				+        // Now create a crypto stream through which we are going

			
 
				+

			
 
				+        // to be pumping data. 

			
 
				+

			
 
				+        // Our fileOut is going to be receiving the encrypted bytes. 

			
 
				+

			
 
				+        CryptoStream cs = new CryptoStream(fsOut, 

			
 
				+            alg.CreateEncryptor(), CryptoStreamMode.Write); 

			
 
				+

			
 
				+        // Now will will initialize a buffer and will be processing

			
 
				+

			
 
				+        // the input file in chunks. 

			
 
				+

			
 
				+        // This is done to avoid reading the whole file (which can

			
 
				+

			
 
				+        // be huge) into memory. 

			
 
				+

			
 
				+        int bufferLen = 4096; 

			
 
				+        byte[] buffer = new byte[bufferLen]; 

			
 
				+        int bytesRead; 

			
 
				+

			
 
				+        do { 

			
 
				+            // read a chunk of data from the input file 

			
 
				+

			
 
				+            bytesRead = fsIn.Read(buffer, 0, bufferLen); 

			
 
				+

			
 
				+            // encrypt it 

			
 
				+

			
 
				+            cs.Write(buffer, 0, bytesRead); 

			
 
				+        } while(bytesRead != 0); 

			
 
				+

			
 
				+        // close everything 

			
 
				+

			
 
				+

			
 
				+        // this will also close the unrelying fsOut stream

			
 
				+

			
 
				+        cs.Close(); 

			
 
				+        fsIn.Close();     

			
 
				+    }

			
 
				+

			
 
				+        // Decrypt a byte array into a byte array using a key and an IV 

			
 
				+

			
 
				+        public static byte[] Decrypt(byte[] cipherData,

			
 
				+                                    byte[] Key, byte[] IV)

			
 
				+        {

			
 
				+            // Create a MemoryStream that is going to accept the

			
 
				+

			
 
				+            // decrypted bytes 

			
 
				+

			
 
				+            MemoryStream ms = new MemoryStream();

			
 
				+

			
 
				+            // Create a symmetric algorithm. 

			
 
				+

			
 
				+            // We are going to use Rijndael because it is strong and

			
 
				+

			
 
				+            // available on all platforms. 

			
 
				+

			
 
				+            // You can use other algorithms, to do so substitute the next

			
 
				+

			
 
				+            // line with something like 

			
 
				+

			
 
				+            //     TripleDES alg = TripleDES.Create(); 

			
 
				+

			
 
				+            Rijndael alg = Rijndael.Create();

			
 
				+

			
 
				+            // Now set the key and the IV. 

			
 
				+

			
 
				+            // We need the IV (Initialization Vector) because the algorithm

			
 
				+

			
 
				+            // is operating in its default 

			
 
				+

			
 
				+            // mode called CBC (Cipher Block Chaining). The IV is XORed with

			
 
				+

			
 
				+            // the first block (8 byte) 

			
 
				+

			
 
				+            // of the data after it is decrypted, and then each decrypted

			
 
				+

			
 
				+            // block is XORed with the previous 

			
 
				+

			
 
				+            // cipher block. This is done to make encryption more secure. 

			
 
				+

			
 
				+            // There is also a mode called ECB which does not need an IV,

			
 
				+

			
 
				+            // but it is much less secure. 

			
 
				+

			
 
				+            alg.Key = Key;

			
 
				+            alg.IV = IV;

			
 
				+

			
 
				+            // Create a CryptoStream through which we are going to be

			
 
				+

			
 
				+            // pumping our data. 

			
 
				+

			
 
				+            // CryptoStreamMode.Write means that we are going to be

			
 
				+

			
 
				+            // writing data to the stream 

			
 
				+

			
 
				+            // and the output will be written in the MemoryStream

			
 
				+

			
 
				+            // we have provided. 

			
 
				+

			
 
				+            CryptoStream cs = new CryptoStream(ms,

			
 
				+                alg.CreateDecryptor(), CryptoStreamMode.Write);

			
 
				+

			
 
				+            // Write the data and make it do the decryption 

			
 
				+

			
 
				+            cs.Write(cipherData, 0, cipherData.Length);

			
 
				+

			
 
				+            // Close the crypto stream (or do FlushFinalBlock). 

			
 
				+

			
 
				+            // This will tell it that we have done our decryption

			
 
				+

			
 
				+            // and there is no more data coming in, 

			
 
				+

			
 
				+            // and it is now a good time to remove the padding

			
 
				+

			
 
				+            // and finalize the decryption process. 

			
 
				+

			
 
				+            cs.Close();

			
 
				+

			
 
				+            // Now get the decrypted data from the MemoryStream. 

			
 
				+

			
 
				+            // Some people make a mistake of using GetBuffer() here,

			
 
				+

			
 
				+            // which is not the right way. 

			
 
				+

			
 
				+            byte[] decryptedData = ms.ToArray();

			
 
				+

			
 
				+            return decryptedData;

			
 
				+        }

			
 
				+

			
 
				+        // Decrypt a string into a string using a password 

			
 
				+

			
 
				+        //    Uses Decrypt(byte[], byte[], byte[]) 

			
 
				+

			
 
				+

			
 
				+        public static string Decrypt(string cipherText, string Password)

			
 
				+        {

			
 
				+            // First we need to turn the input string into a byte array. 

			
 
				+

			
 
				+            // We presume that Base64 encoding was used 

			
 
				+

			
 
				+            byte[] cipherBytes = Convert.FromBase64String(cipherText);

			
 
				+

			
 
				+            // Then, we need to turn the password into Key and IV 

			
 
				+

			
 
				+            // We are using salt to make it harder to guess our key

			
 
				+

			
 
				+            // using a dictionary attack - 

			
 
				+

			
 
				+            // trying to guess a password by enumerating all possible words. 

			
 
				+

			
 
				+            PasswordDeriveBytes pdb = new PasswordDeriveBytes(Password,

			
 
				+                new byte[] {0x49, 0x76, 0x61, 0x6e, 0x20, 0x4d, 0x65, 

			
 
				+            0x64, 0x76, 0x65, 0x64, 0x65, 0x76});

			
 
				+

			
 
				+            // Now get the key/IV and do the decryption using

			
 
				+

			
 
				+            // the function that accepts byte arrays. 

			
 
				+

			
 
				+            // Using PasswordDeriveBytes object we are first

			
 
				+

			
 
				+            // getting 32 bytes for the Key 

			
 
				+

			
 
				+            // (the default Rijndael key length is 256bit = 32bytes)

			
 
				+

			
 
				+            // and then 16 bytes for the IV. 

			
 
				+

			
 
				+            // IV should always be the block size, which is by

			
 
				+

			
 
				+            // default 16 bytes (128 bit) for Rijndael. 

			
 
				+

			
 
				+            // If you are using DES/TripleDES/RC2 the block size is

			
 
				+

			
 
				+            // 8 bytes and so should be the IV size. 

			
 
				+

			
 
				+            // You can also read KeySize/BlockSize properties off

			
 
				+

			
 
				+            // the algorithm to find out the sizes. 

			
 
				+

			
 
				+            byte[] decryptedData = Decrypt(cipherBytes,

			
 
				+                pdb.GetBytes(32), pdb.GetBytes(16));

			
 
				+

			
 
				+            // Now we need to turn the resulting byte array into a string. 

			
 
				+

			
 
				+            // A common mistake would be to use an Encoding class for that.

			
 
				+

			
 
				+            // It does not work 

			
 
				+

			
 
				+            // because not all byte values can be represented by characters. 

			
 
				+

			
 
				+            // We are going to be using Base64 encoding that is 

			
 
				+

			
 
				+            // designed exactly for what we are trying to do. 

			
 
				+

			
 
				+            return System.Text.Encoding.Unicode.GetString(decryptedData);

			
 
				+        }

			
 
				+

			
 
				+        // Decrypt bytes into bytes using a password 

			
 
				+

			
 
				+        //    Uses Decrypt(byte[], byte[], byte[]) 

			
 
				+

			
 
				+

			
 
				+        public static byte[] Decrypt(byte[] cipherData, string Password)

			
 
				+        {

			
 
				+            // We need to turn the password into Key and IV. 

			
 
				+

			
 
				+            // We are using salt to make it harder to guess our key

			
 
				+

			
 
				+            // using a dictionary attack - 

			
 
				+

			
 
				+            // trying to guess a password by enumerating all possible words. 

			
 
				+

			
 
				+            PasswordDeriveBytes pdb = new PasswordDeriveBytes(Password,

			
 
				+                new byte[] {0x49, 0x76, 0x61, 0x6e, 0x20, 0x4d, 

			
 
				+            0x65, 0x64, 0x76, 0x65, 0x64, 0x65, 0x76});

			
 
				+

			
 
				+            // Now get the key/IV and do the Decryption using the 

			
 
				+

			
 
				+            //function that accepts byte arrays. 

			
 
				+

			
 
				+            // Using PasswordDeriveBytes object we are first getting

			
 
				+

			
 
				+            // 32 bytes for the Key 

			
 
				+

			
 
				+            // (the default Rijndael key length is 256bit = 32bytes)

			
 
				+

			
 
				+            // and then 16 bytes for the IV. 

			
 
				+

			
 
				+            // IV should always be the block size, which is by default

			
 
				+

			
 
				+            // 16 bytes (128 bit) for Rijndael. 

			
 
				+

			
 
				+            // If you are using DES/TripleDES/RC2 the block size is

			
 
				+

			
 
				+            // 8 bytes and so should be the IV size. 

			
 
				+

			
 
				+

			
 
				+            // You can also read KeySize/BlockSize properties off the

			
 
				+

			
 
				+            // algorithm to find out the sizes. 

			
 
				+

			
 
				+            return Decrypt(cipherData, pdb.GetBytes(32), pdb.GetBytes(16));

			
 
				+        }

			
 
				+

			
 
				+        // Decrypt a file into another file using a password 

			
 
				+

			
 
				+        public static void Decrypt(string fileIn,

			
 
				+                    string fileOut, string Password) 

			
 
				+    { 

			
 
				+    

			
 
				+        // First we are going to open the file streams 

			
 
				+

			
 
				+        FileStream fsIn = new FileStream(fileIn,

			
 
				+                    FileMode.Open, FileAccess.Read); 

			
 
				+        FileStream fsOut = new FileStream(fileOut,

			
 
				+                    FileMode.OpenOrCreate, FileAccess.Write); 

			
 
				+  

			
 
				+        // Then we are going to derive a Key and an IV from

			
 
				+

			
 
				+        // the Password and create an algorithm 

			
 
				+

			
 
				+        PasswordDeriveBytes pdb = new PasswordDeriveBytes(Password, 

			
 
				+            new byte[] {0x49, 0x76, 0x61, 0x6e, 0x20, 0x4d, 

			
 
				+            0x65, 0x64, 0x76, 0x65, 0x64, 0x65, 0x76}); 

			
 
				+        Rijndael alg = Rijndael.Create(); 

			
 
				+

			
 
				+        alg.Key = pdb.GetBytes(32); 

			
 
				+        alg.IV = pdb.GetBytes(16); 

			
 
				+

			
 
				+        // Now create a crypto stream through which we are going

			
 
				+

			
 
				+        // to be pumping data. 

			
 
				+

			
 
				+        // Our fileOut is going to be receiving the Decrypted bytes. 

			
 
				+

			
 
				+        CryptoStream cs = new CryptoStream(fsOut, 

			
 
				+            alg.CreateDecryptor(), CryptoStreamMode.Write); 

			
 
				+  

			
 
				+        // Now will will initialize a buffer and will be 

			
 
				+

			
 
				+        // processing the input file in chunks. 

			
 
				+

			
 
				+        // This is done to avoid reading the whole file (which can be

			
 
				+

			
 
				+        // huge) into memory. 

			
 
				+

			
 
				+        int bufferLen = 4096;

			
 
				+        byte[] buffer = new byte[bufferLen];

			
 
				+        int bytesRead; 

			
 
				+

			
 
				+        do { 

			
 
				+            // read a chunk of data from the input file 

			
 
				+

			
 
				+            bytesRead = fsIn.Read(buffer, 0, bufferLen); 

			
 
				+

			
 
				+            // Decrypt it 

			
 
				+

			
 
				+            cs.Write(buffer, 0, bytesRead); 

			
 
				+

			
 
				+        } while(bytesRead != 0); 

			
 
				+

			
 
				+        // close everything 

			
 
				+

			
 
				+        cs.Close(); // this will also close the unrelying fsOut stream 

			
 
				+

			
 
				+        fsIn.Close();     

			
 
				+        }

			
 
				+    }

			
 
				+

			
 
				+

			
 
				+}

			
--- a/WpfApplication19/GlobalVars.cs
+++ b/WpfApplication19/GlobalVars.cs
@@ -0,0 +1,12 @@
 
				+using System;

			
 
				+using System.Collections.Generic;

			
 
				+using System.Linq;

			
 
				+using System.Text;

			
 
				+

			
 
				+namespace WpfApplication19

			
 
				+{

			
 
				+    public static class GlobalVars

			
 
				+    {

			
 
				+        public static User user { get; set; }

			
 
				+    }

			
 
				+}

			
--- a/WpfApplication19/Images/Actions-file-save-as-icon.png
+++ b/WpfApplication19/Images/Actions-file-save-as-icon.png
--- a/WpfApplication19/Images/Delete.png
+++ b/WpfApplication19/Images/Delete.png
Prach Pongpanich 6f337d0a21 install tailwind alpine daisyui		2 lat temu
..
aaa	6f337d0a21 install tailwind alpine daisyui	2 lat temu
bbb	6f337d0a21 install tailwind alpine daisyui	2 lat temu
aaa.js	6f337d0a21 install tailwind alpine daisyui	2 lat temu
bbb.js	6f337d0a21 install tailwind alpine daisyui	2 lat temu