public void deleteCategory(string categoryName) { string selectedCategory = ExistingCategoriesCombo.GetItemText(ExistingCategoriesCombo.SelectedItem); using (var db = new POSApplication.Model.posdbEntities()) { var query = (from d in db.cateogries where d.CategoryName == selectedCategory select new { CategoryID = d.CategoryID, CategoryName = d.CategoryName }).SingleOrDefault(); Model.cateogry c = new Model.cateogry(); c.CategoryID = query.CategoryID; c.CategoryName = query.CategoryName; db.cateogries.Remove(c); db.SaveChanges(); MessageBox.Show("Existing Category " + selectedCategory + " has been deleted."); } }
private void SaveCategoryButton_Click(object sender, EventArgs e) { string newCategoryName; try { newCategoryName = NewCategoryField.Text; if (newCategoryName.Length > 0) { using (var db = new POSApplication.Model.posdbEntities()) { var query2 = (from d in db.cateogries where d.CategoryName == newCategoryName select new { CategoryName = d.CategoryName }).SingleOrDefault(); if (query2 == null) { Model.cateogry c = new Model.cateogry(); c.CategoryName = newCategoryName; db.cateogries.Add(c); db.SaveChanges(); MessageBox.Show("New Category '" + newCategoryName + "' has been added in the system."); resetCategoriesField(); } else { MessageBox.Show("Category already exists in the system."); NewCategoryField.Text = ""; } } } } catch (Exception e1) { MessageBox.Show("Enter Correct CategoryName"); } }