private void Urun_Guncelle_Click(object sender, EventArgs e)
{
Guncelle guncelle = new Guncelle();
guncelle.StartPosition = FormStartPosition.CenterScreen;
guncelle.Show();
this.Hide();
}
private void Update_Product_Click(object sender, EventArgs e)
{
if (DropDown.SelectedItem != null)
{
connection.Open();
foreach (var item in deletedDrinkTypes)
{
commandUpdate = new SqlCommand("Delete dbo.Menu_Drink where Id_Drink = @deletedID and Id_Type = @deletedType ", connection);
commandUpdate.Parameters.AddWithValue("@deletedID", item.productID);
commandUpdate.Parameters.AddWithValue("@deletedType", item.typeID);
commandUpdate.ExecuteNonQuery();
}
foreach (var item in deletedFoodTypes)
{
commandUpdate = new SqlCommand("Delete dbo.Menu_Food where Id_Food = @deletedID and Id_Type = @deletedType ", connection);
commandUpdate.Parameters.AddWithValue("@deletedID", item.productID);
commandUpdate.Parameters.AddWithValue("@deletedType", item.typeID);
commandUpdate.ExecuteNonQuery();
}
foreach (var item in addedFoodTypes)
{
commandUpdate = new SqlCommand("insert into dbo.Menu_Food values(@insertID,@insertType) ", connection);
commandUpdate.Parameters.AddWithValue("@insertID", item.productID);
commandUpdate.Parameters.AddWithValue("@insertType", item.typeID);
commandUpdate.ExecuteNonQuery();
}
foreach (var item in addedDrinkTypes)
{
commandUpdate = new SqlCommand("insert into dbo.Menu_Drink values(@insertID,@insertType) ", connection);
commandUpdate.Parameters.AddWithValue("@insertID", item.productID);
commandUpdate.Parameters.AddWithValue("@insertType", item.typeID);
commandUpdate.ExecuteNonQuery();
}
UpdateInformation();
MessageBox.Show("Güncellendi");
connection.Close();
ResetAllData();
Guncelle newForm1 = new Guncelle();
newForm1.Show();
this.Dispose(false);
}
else
{
MessageBox.Show("Onur, yapma böyle şeyler!!!");
}
}