private void Brand_Edit_Click(object sender, EventArgs e) { try { var b_ID = Convert.ToInt32(txtBrandID.Text); Brand_Table brand_Table = model.Brand_Table.Where(a => a.Brand_ID == b_ID).FirstOrDefault(); if (brand_Table != null) { var B_Name = txtBrandName.Text; //Brand_Table Btable = new Brand_Table(); //Btable.Brand_ID = b_ID; brand_Table.Brand_Name = B_Name; model.Entry(brand_Table).State = EntityState.Modified; model.SaveChanges(); MessageBox.Show("Edit Successfully!!!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); this.brand_TableTableAdapter.Fill(this.scrapeTestDataSetBrandTable.Brand_Table); } else { MessageBox.Show("Your Id is Mismatched!!!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Save_Brands_Click(object sender, EventArgs e) { try { if (txtBrandName.Text != "") { var B_Name = txtBrandName.Text; Brand_Table Btable = new Brand_Table(); Btable.Brand_Name = B_Name; model.Brand_Table.Add(Btable); model.SaveChanges(); MessageBox.Show("Brands Saved Successfully!!!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); this.brand_TableTableAdapter.Fill(this.scrapeTestDataSetBrandTable.Brand_Table); } else { MessageBox.Show("Please!!! fill Reqired Fields!!!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Del_Brand_Btn_Click(object sender, EventArgs e) { try { var b_ID = Convert.ToInt32(txtBrandID.Text); Brand_Table brand_Table = model.Brand_Table.Where(a => a.Brand_ID == b_ID).FirstOrDefault(); model.Brand_Table.Remove(brand_Table); model.SaveChanges(); MessageBox.Show("Deleted Successfully!!!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); this.brand_TableTableAdapter.Fill(this.scrapeTestDataSetBrandTable.Brand_Table); } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }