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");
}
}
