private void button5_Click(object sender, EventArgs e) { if (listView1.SelectedItems.Count > 0) { DialogResult result = folderBrowserDialog1.ShowDialog(); if (result == DialogResult.OK) { WebApplication1.Class1.USBSerialNumber usb = new WebApplication1.Class1.USBSerialNumber(); string path = folderBrowserDialog1.SelectedPath; string serial = usb.getSerialNumberFromDriveLetter(path.Remove(path.Length - 1)); SqlConnection connection = new SqlConnection(connectionString); connection.Open(); SqlCommand command = connection.CreateCommand(); SqlDataReader reader; command.CommandText = "SELECT * FROM farmer where uuid=@p3"; command.Prepare(); command.Parameters.AddWithValue("@p3", listView1.SelectedItems[0].Text); reader = command.ExecuteReader(); string farmer_serial = ""; if (reader.Read()) { farmer_serial = reader["usb"].ToString(); } reader.Close(); if (serial == farmer_serial) { //string key = "12"; command.Parameters.Clear(); command.CommandText = "UPDATE farmer SET units= units + @p1 WHERE uuid=@p2"; command.Prepare(); command.Parameters.AddWithValue("@p1", Convert.ToInt32(numericUpDown1.Text)); command.Parameters.AddWithValue("@p2", listView1.SelectedItems[0].Text); command.ExecuteNonQuery(); command.Parameters.Clear(); command.CommandText = "SELECT * FROM farmer where uuid=@p3"; command.Prepare(); command.Parameters.AddWithValue("@p3", listView1.SelectedItems[0].Text); reader = command.ExecuteReader(); string test = ""; string text = ""; string text1 = ""; int units = 0; int uuid = 0; try { test = File.ReadLines(folderBrowserDialog1.SelectedPath + "units.txt", Encoding.Default).First().Trim(); //MessageBox.Show(test); if (reader.Read()) { if (test != "") { //char[] array3 = test.ToCharArray(); //char[] array4 = key.ToCharArray(); //char[] array5 = WebApplication1.Class1.XORENC(test); string test1 = WebApplication1.Class1.XORENC(test); text = test1.Substring(0, test1.IndexOf(",")); text1 = test1.Substring(test1.IndexOf(" ")); text = text + "," + reader["units"].ToString() + "," + reader["uuid"].ToString() + text1; //DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss") units = Convert.ToInt32(reader["units"]); uuid = Convert.ToInt32(reader["uuid"]); } else { text = "NA," + reader["units"].ToString() + "," + reader["uuid"].ToString() + " "; units = Convert.ToInt32(reader["units"]); uuid = Convert.ToInt32(reader["uuid"]); } } reader.Close(); //char[] array = text.ToCharArray(); //key = "12"; //char[] array1 = key.ToCharArray(); //char[] array2 = WebApplication1.Class1.XORENC(array, array1); string encrypt = WebApplication1.Class1.XORENC(text); File.WriteAllText(folderBrowserDialog1.SelectedPath + "units.txt", encrypt, Encoding.Default); fillFarmer(); command.Parameters.Clear(); command.CommandText = "INSERT into fill (uuid,date,adding,units) values (@p1,@p2,@p3,@p4)"; command.Prepare(); command.Parameters.AddWithValue("@p1", uuid); command.Parameters.AddWithValue("@p2", DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss")); command.Parameters.AddWithValue("@p3", "+" + numericUpDown1.Text); command.Parameters.AddWithValue("@p4", units); command.ExecuteNonQuery(); MessageBox.Show("Η Προσθήκη Μονάδων στο USB ολοκληρώθηκε"); connection.Close(); } catch (Exception) { if (reader.Read()) { text = "NA," + reader["units"].ToString() + "," + reader["uuid"].ToString() + " "; //char[] array = text.ToCharArray(); //key = "12"; //char[] array1 = key.ToCharArray(); //char[] array2 = WebApplication1.Class1.XORENC(text); string encrypt = WebApplication1.Class1.XORENC(text); units = Convert.ToInt32(reader["units"]); uuid = Convert.ToInt32(reader["uuid"]); reader.Close(); File.WriteAllText(folderBrowserDialog1.SelectedPath + "units.txt", encrypt, Encoding.Default); fillFarmer(); command.Parameters.Clear(); command.CommandText = "INSERT into fill (uuid,date,adding,units) values (@p1,@p2,@p3,@p4)"; command.Prepare(); command.Parameters.AddWithValue("@p1", uuid); command.Parameters.AddWithValue("@p2", DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss")); command.Parameters.AddWithValue("@p3", "+" + numericUpDown1.Text); command.Parameters.AddWithValue("@p4", units); command.ExecuteNonQuery(); MessageBox.Show("Η Προσθήκη Μονάδων στο USB ολοκληρώθηκε"); connection.Close(); } } } else { MessageBox.Show("Το Serial Number του αγρότη και του Usb δεν ταιριάζουν"); } } } else { MessageBox.Show("Επιλέξτε έναν αγρότη"); } }
private void usb_Click(object sender, EventArgs e) { DialogResult result = folderBrowserDialog1.ShowDialog(); if (result == DialogResult.OK) { WebApplication1.Class1.USBSerialNumber usb1 = new WebApplication1.Class1.USBSerialNumber(); string path = folderBrowserDialog1.SelectedPath; string serial = usb1.getSerialNumberFromDriveLetter(path.Remove(path.Length - 1)); if (serial != null) { SqlConnection connection = new SqlConnection(connectionString); connection.Open(); SqlCommand command = connection.CreateCommand(); SqlDataReader reader; command.CommandText = "SELECT * FROM farmer where usb=@p3"; command.Prepare(); command.Parameters.AddWithValue("@p3", serial); reader = command.ExecuteReader(); File.Create(path + "farmer.txt").Close(); if (reader.Read()) { MessageBox.Show("Το συγκεκριμένο Usb χρησιμοποιείται από άλλο αγρότη"); File.Delete(path + "farmer.txt"); } else { usb.Text = serial; } reader.Close(); connection.Close(); } else { MessageBox.Show("Η διαδρομή που επιλέξατε δεν είναι σωστή"); } } }