Example #1
0
 public Boolean Save(tbl_000_H_ITEM_MPT record)
 {
     using (var dbContextTransaction = db.Database.BeginTransaction())
     {
         try
         {
             db.ItemMPTList.Add(record);
             db.SaveChanges();
             dbContextTransaction.Commit();
             return(true);
         }
         catch (Exception ex)
         {
             dbContextTransaction.Rollback();
             throw ex;
         }
     }
 }
Example #2
0
 public Boolean Delete(tbl_000_H_ITEM_MPT record)
 {
     try
     {
         if (record == null)
         {
             throw new Exception("Invalid Parameter!");
         }
         if (!itmptdal.IsExistID(record.DocID))
         {
             throw new Exception("Record does not exist!");
         }
         return(itmptdal.Delete(record));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Example #3
0
 public Boolean Save(tbl_000_H_ITEM_MPT record)
 {
     try
     {
         if (record == null)
         {
             throw new Exception("Invalid Parameter!");
         }
         if (itmptdal.IsExistID(record.DocID))
         {
             throw new Exception("MPT Code already taken!");
         }
         return(itmptdal.Save(record));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Example #4
0
 public Boolean Update(tbl_000_H_ITEM_MPT record)
 {
     using (var dbContextTransaction = db.Database.BeginTransaction())
     {
         try
         {
             //var existrecord = GetByID(record.YEARUSED, record.ItemNo, record.SectionCode);
             var existrecord = GetByID(record.DocID);
             db.Entry(existrecord).GetDatabaseValues().SetValues(record);
             db.SaveChanges();
             dbContextTransaction.Commit();
             return(true);
         }
         catch (Exception ex)
         {
             dbContextTransaction.Rollback();
             throw ex;
         }
     }
 }