private void button1_Click(object sender, EventArgs e) { var context = new DataClasses2DataContext(); final ss = new final(); ss.Show(); var result23 = (from t in context.comenzi3s where t.id > 0 select t).First(); System.Nullable <int> totalUnitsOnOrder = (from ord in context.PTcos select ord.Pret).Sum(); result23.suma = totalUnitsOnOrder; context.SubmitChanges(); //var deleteorder = from detail in context.PTcos // select detail; //foreach (var detail in deleteorder) //{ // context.PTcos.DeleteOnSubmit(detail); // context.SubmitChanges(); //} //for (int n=0;n<dataGridView3.Rows.Count;n++) //dataGridView3.Rows.RemoveAt(n); }
private void button2_Click(object sender, EventArgs e) { string clearText = textBox2.Text.Trim(); string cipherText = CryptorEngine.Encrypt(clearText, true); try { DataClasses2DataContext data = new DataClasses2DataContext(); // string Insertstatement = "Insert into Useri values('textBox1.Text', textBox2.Text,textBox3.Text,textBox4.Text)"; //data.ExecuteQuery<Useri>(Insertstatement); var employee = new Useri { Username = textBox1.Text, Parola = cipherText, email = textBox3.Text, adresa = textBox4.Text }; data.Useris.InsertOnSubmit(employee); data.SubmitChanges(); MessageBox.Show("User inregistrat"); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void pictureBox2_Click(object sender, EventArgs e) { if (checkBox4.Checked == true) { panel1.Enabled = false; } if (checkBox1.Enabled == true) { DataClasses2DataContext data = new DataClasses2DataContext(); var result23 = (from t in data.comenzi3s where t.id > 0 select t).First(); var res = (from t in data.Shippers where t.Nume == "Posta" select t).First(); result23.shipper_id = res.ID_shipper; data.SubmitChanges(); } if (checkBox2.Checked == true) { DataClasses2DataContext data = new DataClasses2DataContext(); var result23 = (from t in data.comenzi3s where t.user_id > 0 select t).First(); var res = (from t in data.Shippers where t.Nume == "FanCourier" select t).First(); result23.shipper_id = res.ID_shipper; data.SubmitChanges(); } if (checkBox3.Checked == true) { DataClasses2DataContext data = new DataClasses2DataContext(); var result23 = (from t in data.comenzi2s where t.user_id > 0 select t).First(); var res = (from t in data.Shippers where t.Nume == "DHL" select t).First(); data.UPDATESHIPPER(res.ID_shipper); data.SubmitChanges(); } var context = new DataClasses2DataContext(); var deleteorder = from detail in context.PTcos select detail; foreach (var detail in deleteorder) { context.PTcos.DeleteOnSubmit(detail); context.SubmitChanges(); } MessageBox.Show("Multumim ca ati cumparat de la noi"); }
private void button2_Click(object sender, EventArgs e) { //App.CosCumparaturi.AddCosCumparaturiRow(App.CosCumparaturi.NewCosCumparaturiRow()); //produseBindingSource.MoveLast(); //var context = new DataClasses2DataContext(); //// string cipherText = textBox2.Text.Trim(); //// string decryptedText = CryptorEngine.Decrypt(cipherText, true); //var alex = from emp in context.Produses // where (emp.Nume == "HP" && emp.Categorie_id == 1) // select emp; //foreach(var a in alex) //{ // // string Insertstatement = "Insert into Useri values('textBox1.Text', textBox2.Text,textBox3.Text,textBox4.Text)"; // //data.ExecuteQuery<Useri>(Insertstatement); // var employee = new CosCumparaturi // { // id_produs = a.Id_produs, // numar_produse = 1, // suma =a.Pret // }; // context.CosCumparaturis.InsertOnSubmit(employee); // context.SubmitChanges(); //} //produseBindingSource.EndEdit(); //App.CosCumparaturi.AcceptChanges(); //App.CosCumparaturi.WriteXml(string.Format("{0}//data.dat", Application.StartupPath)); var context = new DataClasses2DataContext(); // string cipherText = textBox2.Text.Trim(); // string decryptedText = CryptorEngine.Decrypt(cipherText, true); var alex = from emp in context.Produses where (emp.Nume == "HP" && emp.Categorie_id == 1) select emp; foreach (var a in alex) { var employee = new PTco { Nume = a.Nume.ToString(), Pret = a.Pret, Cantitta = 1 }; context.PTcos.InsertOnSubmit(employee); context.SubmitChanges(); frm1.BLA(); } //dataGridView1.DataSource = alex; }
private void pictureBox2_Click(object sender, EventArgs e) { var context = new DataClasses2DataContext(); foreach (DataGridViewRow row in dataGridView3.SelectedRows) { int v = Convert.ToInt32(row.Cells[0].Value.ToString()); dataGridView3.Rows.RemoveAt(row.Index); var deleteorder = from detail in context.PTcos where detail.id == v select detail; foreach (var detail in deleteorder) { context.PTcos.DeleteOnSubmit(detail); context.SubmitChanges(); } } }
private void button3_Click_1(object sender, EventArgs e) { var context = new DataClasses2DataContext(); // string cipherText = textBox2.Text.Trim(); // string decryptedText = CryptorEngine.Decrypt(cipherText, true); var alex = from emp in context.Produses where (emp.Nume == "Lenovo" && emp.Categorie_id == 1) select emp; foreach (var a in alex) { var employee = new PTco { Nume = a.Nume.ToString(), Pret = a.Pret, Cantitta = 1 }; context.PTcos.InsertOnSubmit(employee); context.SubmitChanges(); frm1.BLA(); } }
private void button2_Click(object sender, EventArgs e) { string decryptedText; try { var context = new DataClasses2DataContext(); // string cipherText = textBox2.Text.Trim(); // string decryptedText = CryptorEngine.Decrypt(cipherText, true); var alex = from emp in context.Useris where (emp.Username == textBox1.Text) select emp; if (alex.Any()) { foreach (var a in alex) { decryptedText = CryptorEngine.Decrypt(a.Parola, true); var employees = from emp in context.Useris where (emp.Username == textBox1.Text) && (decryptedText == textBox2.Text && emp.Administrator.StartsWith("da")) select emp; var employees2 = from emp in context.Useris where (emp.Username.Contains(textBox1.Text)) && (decryptedText == textBox2.Text) //&& emp.Administrator.StartsWith("nu")) select emp; if (employees.Any()) { this.Hide(); admin administrare = new admin(); administrare.Show(); } else if (employees2.Any()) { this.Hide(); Main ss = new Main(); ss.Show(); var context3 = new DataClasses2DataContext(); Random rnd = new Random(); foreach (var al in alex) { // var emp = new comenzi2 // { // id = rnd.Next(50000), // user_id = al.ID context3.inserare(rnd.Next(50000), al.ID, 1, 1); context3.SubmitChanges(); } // }; // context3.comenzi2s.InsertOnSubmit(emp); // context3.SubmitChanges();} // frm.Show(); } else { MessageBox.Show("USER sau PAROLA incorecta"); } } } else { MessageBox.Show("USER incorect"); } // string decryptedText = CryptorEngine.Decrypt(alex, true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }