public Boolean Save(tbl_000_H_ITEM_TABULATION_VP record) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { db.ItemTabulationVPList.Add(record); db.SaveChanges(); dbContextTransaction.Commit(); return(true); } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } }
public Boolean Delete(tbl_000_H_ITEM_TABULATION_VP record) { try { if (record == null) { throw new Exception("Invalid Parameter!"); } if (!itvpdal.IsExistID(record.DocID)) { throw new Exception("Record does not exist!"); } return(itvpdal.Delete(record)); } catch (Exception ex) { throw ex; } }
public Boolean Delete(tbl_000_H_ITEM_TABULATION_VP record) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { //var existrecord = GetByID(record.YEARUSED, record.ItemNo, record.PartNo); var existrecord = GetByID(record.DocID); db.ItemTabulationVPList.Remove(existrecord); db.SaveChanges(); dbContextTransaction.Commit(); return(true); } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } }
public Boolean Save(tbl_000_H_ITEM_TABULATION_VP record) { try { if (record == null) { throw new Exception("Invalid Parameter!"); } if (itvpdal.IsExistID(record.DocID)) { throw new Exception("VP No. already taken!"); } if (itvpdal.IsExistPartName(record.PartName)) { throw new Exception(" VP Name already taken!"); } return(itvpdal.Save(record)); } catch (Exception ex) { throw ex; } }