private void Delete_Click(object sender, EventArgs e)
{
try
{
DataLinqToSqlDataContext dbdelete = new DataLinqToSqlDataContext();
int prodID = Convert.ToInt32(DataView.CurrentRow.Cells["ID"].Value);
PRODUCT prod = dbdelete.PRODUCTs.SingleOrDefault(o => o.ID == prodID);
dbdelete.PRODUCTs.DeleteOnSubmit(prod);
dbdelete.SubmitChanges();
DataView.DataSource = dbdelete.PRODUCTs;
}
catch (Exception)
{
MessageBox.Show("Something went wrong! Retry please ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void Update_Click(object sender, EventArgs e)
{
try
{
DataLinqToSqlDataContext dbupcon = new DataLinqToSqlDataContext();
int prodId = Convert.ToInt32(Name.Tag);
PRODUCT prod = dbupcon.PRODUCTs.SingleOrDefault(product => product.ID == prodId);
prod.NAME = Name.Text;
prod.CATEGORY = Category.Text;
prod.MADED_BY = Maded_by.Text;
prod.PRODUCT_DATE = Convert.ToDateTime(dateTimePicker1.Text);
prod.PRICE = numericUpDown1.Value;
dbupcon.SubmitChanges();
DataView.DataSource = dbupcon.PRODUCTs;
}
catch (Exception)
{
MessageBox.Show("Something went wrong :( , please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
partial void DeletePRODUCT(PRODUCT instance);
partial void UpdatePRODUCT(PRODUCT instance);
partial void InsertPRODUCT(PRODUCT instance);
