private void btn_vinde_masina_Click(object sender, EventArgs e) { var context = new Parc_AutoDataContext(); string nume_angajat = textBox_nume_vanzator.Text.ToString(); string nume_client = textBox_nume_client.Text.ToString(); var id_angajat = from db in context.Angajatis where db.Nume.Equals(nume_angajat) select db.AngajatID; var contract = new Vanzari { Angajat_ID = id_angajat.First(), Client = nume_client, Vanzator = nume_angajat, VIN = vvv, Pret_vanzare = ppp, Data = DateTime.Now }; var car = from db in context.Masinis where db.VIN.Equals(vvv) select db; foreach (var masina in car) { context.Masinis.DeleteOnSubmit(masina); } context.Vanzaris.InsertOnSubmit(contract); context.SubmitChanges(); this.Close(); }
public bool Update(Vanzari v) { bool succes = false; SqlConnection conn = new SqlConnection(CONNECTION_STRING); try { string sql = "Update vanzari_autoturisme set id_Auto= @id_Auto, id_Client= @id_Client, date_vanzare= @date_vanzare WHERE id_Vanzari= @id_Vanzari"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@id_Auto", v.Id_auto_V); cmd.Parameters.AddWithValue("@id_Client", v.Id_clienti_v); cmd.Parameters.AddWithValue("@date_vanzare", v.Data_vanzare); cmd.Parameters.AddWithValue("@id_Vanzari", v.Id_vanzari); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { //query succes succes = true; } else { //query failed succes = false; } } catch (Exception ex) { MessageBox.Show("Exceptie" + ex.Message); } finally { conn.Close(); } return(succes); }