private void saveBtn_Click(object sender, EventArgs e) { String name = BrandNameTxt.Text; String id = BrandIdTxt.Text; var search = (from x in db.LaptopBrands where name == x.LaptopBrandName select x.LaptopBrandName).FirstOrDefault(); if (name.Length < 2 || name.Length > 15) { MessageBox.Show("Brand name length must be between 2-15 characters", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (search != null) { MessageBox.Show("Brand name already exists!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var searchid = (from x in db.LaptopBrands where x.LaptopBrandID == id select x).FirstOrDefault(); if (searchid != null) { LaptopBrand updateBrand = (from x in db.LaptopBrands where x.LaptopBrandID == id select x).FirstOrDefault(); updateBrand.LaptopBrandName = name; } else { LaptopBrand insertBrand = new LaptopBrand() { LaptopBrandID = id, LaptopBrandName = name }; db.LaptopBrands.Add(insertBrand); } db.SaveChanges(); refresh(); MessageBox.Show("Data inserted/updated succesfully", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information); state(); } }
private void deleteBtn_Click(object sender, EventArgs e) { var id = BrandIdTxt.Text; var name = BrandNameTxt.Text; if (id == "" || name == "") { MessageBox.Show("Please select data first!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (MessageBox.Show("Are you sure?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { LaptopBrand deleteBrand = (from x in db.LaptopBrands where x.LaptopBrandID == id select x).FirstOrDefault(); db.LaptopBrands.Remove(deleteBrand); db.SaveChanges(); refresh(); } state(); } }