public bool DeleteGrainInventory(int GrainInventoryId) { bool isSaved = true; using (WTCCeresEntities db = new WTCCeresEntities()) { try { gi = db.GrainInventory.Find(GrainInventoryId); db.GrainInventory.Remove(gi); db.SaveChanges(); } catch (Exception e) { var msg = e.Message; isSaved = false; } } return(isSaved); }
public bool UpdateGrainInventory(int GrainInventoryId, int CustomerId, int BagId, double InitialQuantity, int MiniUnitid) { bool isSaved = true; using (WTCCeresEntities db = new WTCCeresEntities()) { try { gi = db.GrainInventory.Find(GrainInventoryId); gi.CustomerId = CustomerId; gi.BagId = BagId; gi.InitialQuantity = InitialQuantity; gi.MiniUnitId = MiniUnitid; db.GrainInventory.AddOrUpdate(gi); db.SaveChanges(); } catch (Exception e) { var msg = e.Message; isSaved = false; } } return(isSaved); }