private void btnKaydet_Click(object sender, EventArgs e)
{
ctx = new NorthWindDataContext();
Product p = ctx.Products.SingleOrDefault(urun => urun.ProductID == (int)txtProductName.Tag);
p.ProductName = txtProductName.Text;
p.UnitPrice = nudFiyat.Value;
p.UnitsInStock = Convert.ToInt16(nudStock.Value);
p.CategoryID = (int)comboKategori.SelectedValue;
p.SupplierID = (int)comboTedarikci.SelectedValue;
ctx.SubmitChanges(); // değişiklikleri ADO.Net koduna cevirerek veritabanina gonder
//refresh the grid
//dataGridViev1.DataSource = ctx.Products;
ListeDoldur();
}
private void btnSil_Click(object sender, EventArgs e)
{
NorthWindDataContext ctx = new NorthWindDataContext();
Product p = new Product();
if (dataGridView1.CurrentRow == null)
{
return;
}
int urunId = (int)dataGridView1.CurrentRow.Cells["ProductID"].Value;
p = ctx.Products.SingleOrDefault(urun => urun.ProductID == urunId);
ctx.Products.DeleteOnSubmit(p);
ctx.SubmitChanges();
//refresh the grid
//dataGridView1.DataSource = ctx.Products;
ListeDoldur();
}
private void btnEkle_Click(object sender, EventArgs e)
{
ctx = new NorthWindDataContext();
Product p = new Product();
p.ProductName = txtProductName.Text;
p.UnitPrice = nudFiyat.Value;
p.UnitsInStock = Convert.ToInt16(nudStock.Value);
p.CategoryID = (int)comboKategori.SelectedValue;
p.SupplierID = (int)comboTedarikci.SelectedValue;
ctx.Products.InsertOnSubmit(p);
MessageBox.Show($"SubmitChanges oncesi ProductID = {p.ProductID}");
ctx.SubmitChanges();
MessageBox.Show($"SubmitChanges sonrasi ProductID = {p.ProductID}");
ListeDoldur();
}