public bool UpdateInsCommisionStructureHeader(InsCommissionStructureHeaderVM commisionStructureHeaderVM) { using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction()) { try { tblInsComCommisionStructureHeader commisionStructureHeader = new tblInsComCommisionStructureHeader(); commisionStructureHeader.ComStructName = commisionStructureHeaderVM.CommisionStructureName; commisionStructureHeader.ExtraFloat1 = commisionStructureHeaderVM.BusinessUnitID; commisionStructureHeader.InsCompanyID = commisionStructureHeaderVM.InsuranceCompanyID; commisionStructureHeader.InsClassID = commisionStructureHeaderVM.InsuranceClassID; commisionStructureHeader.InsSubClassID = commisionStructureHeaderVM.InsuranceSubClassID; commisionStructureHeader.CreatedDate = DateTime.Now; commisionStructureHeader.CreatedBy = commisionStructureHeaderVM.CreatedBy; unitOfWork.TblInsCommisionStructureHeaderRepository.Insert(commisionStructureHeader); unitOfWork.Save(); //Complete the Transaction dbTransaction.Commit(); return(true); } catch (Exception ex) { //Roll back the Transaction dbTransaction.Rollback(); return(false); } } }
public bool SaveInsCommisionStructureHeader(InsCommissionStructureHeaderVM commisionStructureHeaderVM) { using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction()) { try { tblInsComCommisionStructureHeader commisionStructureHeader = new tblInsComCommisionStructureHeader(); commisionStructureHeader.ComStructName = commisionStructureHeaderVM.CommisionStructureName; commisionStructureHeader.ExtraFloat1 = commisionStructureHeaderVM.BusinessUnitID; commisionStructureHeader.InsCompanyID = commisionStructureHeaderVM.InsuranceCompanyID; commisionStructureHeader.InsClassID = commisionStructureHeaderVM.InsuranceClassID; commisionStructureHeader.InsSubClassID = commisionStructureHeaderVM.InsuranceSubClassID; commisionStructureHeader.CreatedDate = DateTime.Now; commisionStructureHeader.CreatedBy = commisionStructureHeaderVM.CreatedBy; unitOfWork.TblInsCommisionStructureHeaderRepository.Insert(commisionStructureHeader); unitOfWork.Save(); int savedIndex = commisionStructureHeader.ComHeaderID; foreach (var chargeType in commisionStructureHeaderVM.ChargeTypeList) { tblComCommisionStructureLine inscommissionLine = new tblComCommisionStructureLine(); inscommissionLine.ComStructID = savedIndex; inscommissionLine.ChargeTypeID = chargeType.ChargeTypeID; inscommissionLine.Percentage = chargeType.Amount; inscommissionLine.CreatedDate = DateTime.Now; inscommissionLine.CreatedBy = commisionStructureHeaderVM.CreatedBy; unitOfWork.TblInsCommisionStructureLineRepository.Insert(inscommissionLine); unitOfWork.Save(); } //Complete the Transaction dbTransaction.Commit(); return(true); } catch (Exception ex) { //Roll back the Transaction dbTransaction.Rollback(); return(false); } } }
public bool DeleteInsCommisionStructureHeader(int commisionStructureID) { using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction()) { try { tblInsComCommisionStructureHeader commisionStructureHeader = unitOfWork.TblInsCommisionStructureHeaderRepository.GetByID(commisionStructureID); unitOfWork.TblInsCommisionStructureHeaderRepository.Delete(commisionStructureHeader); unitOfWork.Save(); //Complete the Transaction dbTransaction.Commit(); return(true); } catch (Exception ex) { //Roll back the Transaction dbTransaction.Rollback(); return(false); } } }