Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        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);
        }