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);
}
