public bool DeleteGrainInventoryTransaction(int GrainInventoryTransactionId) { bool isSaved = true; using (WTCCeresEntities db = new WTCCeresEntities()) { try { git = db.GrainInventoryTransaction.Find(GrainInventoryTransactionId); db.GrainInventoryTransaction.Remove(git); db.SaveChanges(); } catch (Exception e) { var msg = e.Message; isSaved = false; } } return(isSaved); }
public bool UpdateGrainInventoryTransaction(int GrainInventoryTransactionId, int GrainInventoryId, int TransactionTypeId, double Quantity, DateTime CreatedAt) { bool isSaved = true; using (WTCCeresEntities db = new WTCCeresEntities()) { try { git = db.GrainInventoryTransaction.Find(GrainInventoryTransactionId); git.GrainInventoryId = GrainInventoryId; git.TransactionTypeId = TransactionTypeId; git.Quantity = Quantity; git.CreatedAt = CreatedAt; db.GrainInventoryTransaction.AddOrUpdate(git); db.SaveChanges(); } catch (Exception e) { var msg = e.Message; isSaved = false; } } return(isSaved); }