public static bool Update(ItemViewModel model) { bool result = true; try { using (var db = new VapeContext()) { if (model.Id == 0) { Mst_Item ite = new Mst_Item(); ite.ItemCode = model.ItemCode; ite.ItemName = model.ItemName; ite.CategoryCode = model.CategoryCode; ite.Description = model.Description; ite.Stock = ite.Stock; ite.IsActive = model.IsActive; db.Mst_Item.Add(ite); db.SaveChanges(); } else { Mst_Item ite = db.Mst_Item.Where(o => o.Id == model.Id).FirstOrDefault(); if (ite != null) { ite.ItemCode = model.ItemCode; ite.ItemName = model.ItemName; ite.CategoryCode = model.CategoryCode; ite.Description = ite.Description; ite.Stock = ite.Stock; ite.IsActive = model.IsActive; db.SaveChanges(); } } } } catch (Exception ex) { Message = ex.Message; result = false; } return(result); }
public static bool Delete(int id) { bool result = true; try { using (var db = new VapeContext()) { Mst_Item ite = db.Mst_Item.Where(o => o.Id == id).FirstOrDefault(); if (ite != null) { db.Mst_Item.Remove(ite); db.SaveChanges(); } } } catch (Exception ex) { Message = ex.Message; result = false; } return(result); }