public void updateCategory(CategoryDTO updatedCategory) { using (DeviceCategoryContext context = new DeviceCategoryContext()) { var category = context.Categories.FirstOrDefault(c => c.id_categ == updatedCategory.id_categ); category.categ_name = updatedCategory.categ_name; context.SaveChanges(); } }
public void deleteCategory(CategoryDTO deletedCategory) { using (DeviceCategoryContext context = new DeviceCategoryContext()) { var category = (from c in context.Categories where c.categ_name == deletedCategory.categ_name select c).First(); context.Categories.Remove(category); context.SaveChanges(); } }
public CategoryDTO GetCategoryByName(string categ_name) { var category = new CategoryDTO(); using (DeviceCategoryContext context = new DeviceCategoryContext()) { category = context.Categories.Select(c => new CategoryDTO { id_categ = c.id_categ, categ_name = c.categ_name }).FirstOrDefault(c => c.categ_name == categ_name); } return category; }
private void addBtn_Click(object sender, EventArgs e) { if (nameEditTxt.Text != "") { CategoryDTO dto = new CategoryDTO(); CategoriesDAL c = new CategoriesDAL(); dto.categ_name = nameEditTxt.Text; dto.id_categ = Convert.ToInt32(idEditTxt.Text); c.updateCategory(dto); loadData(); MessageBox.Show("Edited"); } else { MessageBox.Show("select row for editing"); } }
private void addBtn_Click(object sender, EventArgs e) { CategoryDTO dto=new CategoryDTO(); CategoriesDAL c = new CategoriesDAL(); dto = c.GetCategoryByName(nameTxt.Text); if (dto == null) { MessageBox.Show("Category is not found!"); } else { c.deleteCategory(dto); loadData(); clearText(); MessageBox.Show("Deleted!"); } }
private void addBtn_Click(object sender, EventArgs e) { CategoryDTO dto=new CategoryDTO(); CategoriesDAL c = new CategoriesDAL(); dto.categ_name = nameTxt.Text; c.insertCategory(dto); start = (c.CountCateg() / size) * size; loadData(); clearText(); MessageBox.Show("Added!"); }
public void insertCategory(CategoryDTO insertedCategory) { using (DeviceCategoryContext context = new DeviceCategoryContext()) { Categories category = new Categories(); category.categ_name = insertedCategory.categ_name; context.Categories.Add(category); context.SaveChanges(); } }