public bool UpdateInsuranceClass(InsuranceClassVM insuranceClassVM) { using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction()) { try { tblInsClass insClass = unitOfWork.TblInsClassRepository.GetByID(insuranceClassVM.InsuranceClassID); insClass.BUID = insuranceClassVM.BusinessUnitID; insClass.Code = insuranceClassVM.InsuranceCode; insClass.Description = insuranceClassVM.Description; insClass.IsActive = insuranceClassVM.IsActive; insClass.ModifiedDate = DateTime.Now; insClass.ModifiedBy = insuranceClassVM.ModifiedBy; unitOfWork.TblInsClassRepository.Update(insClass); unitOfWork.Save(); //Complete the Transaction dbTransaction.Commit(); return(true); } catch (Exception ex) { //Roll back the Transaction dbTransaction.Rollback(); return(false); } } }
public List <InsCommissionStructureHeaderVM> GetAllInsCommisionStructureHeaders(int businessUnitID) { try { var commisionStructureHeaderData = unitOfWork.TblInsCommisionStructureHeaderRepository.Get(x => x.ExtraFloat1 == (double)businessUnitID).ToList(); List <InsCommissionStructureHeaderVM> commisionStructureHeaderList = new List <InsCommissionStructureHeaderVM>(); List <ChargeTypeVM> chargeTpeListVm = new List <ChargeTypeVM>(); foreach (var commisionStructureHeader in commisionStructureHeaderList) { InsCommissionStructureHeaderVM commisionStructureHeaderVM = new InsCommissionStructureHeaderVM(); commisionStructureHeaderVM.CommisionStructureID = commisionStructureHeader.CommisionStructureLineID; commisionStructureHeaderVM.CommisionStructureName = commisionStructureHeader.CommisionStructureName; commisionStructureHeaderVM.BusinessUnitID = commisionStructureHeader.BusinessUnitID > 0 ? Convert.ToInt32(commisionStructureHeader.BusinessUnitID) : 0; commisionStructureHeaderVM.InsuranceCompanyID = commisionStructureHeader.InsuranceCompanyID > 0? commisionStructureHeader.InsuranceCompanyID:0; tblInsCompany insuranceCompany = unitOfWork.TblInsCompanyRepository.GetByID(commisionStructureHeaderVM.InsuranceCompanyID); commisionStructureHeaderVM.InsuranceCompanyName = string.IsNullOrEmpty(insuranceCompany.InsCompany)? "": insuranceCompany.InsCompany; commisionStructureHeaderVM.InsuranceClassID = commisionStructureHeader.InsuranceClassID > 0 ? commisionStructureHeader.InsuranceClassID : 0; tblInsClass insuranceClass = unitOfWork.TblInsClassRepository.GetByID(commisionStructureHeaderVM.InsuranceClassID); commisionStructureHeaderVM.InsuranceClassName = string.IsNullOrEmpty(insuranceClass.Code) ? "" : insuranceClass.Code; commisionStructureHeaderVM.InsuranceSubClassID = commisionStructureHeader.InsuranceSubClassID > 0 ? commisionStructureHeader.InsuranceSubClassID : 0; tblInsSubClass insuranceSubClass = unitOfWork.TblInsSubClassRepository.GetByID(commisionStructureHeaderVM.InsuranceSubClassID); commisionStructureHeaderVM.InsuranceSubClassName = string.IsNullOrEmpty(insuranceSubClass.Description) ? "" : insuranceSubClass.Description; commisionStructureHeaderVM.CreatedDate = commisionStructureHeader.CreatedDate != null?commisionStructureHeader.CreatedDate.ToString() : string.Empty; commisionStructureHeaderVM.ModifiedDate = commisionStructureHeader.ModifiedDate != null?commisionStructureHeader.ModifiedDate.ToString() : string.Empty; commisionStructureHeaderVM.CreatedBy = commisionStructureHeader.CreatedBy > 0 ? commisionStructureHeader.CreatedBy : 0; commisionStructureHeaderVM.ModifiedBy = commisionStructureHeader.ModifiedBy > 0 ? commisionStructureHeader.ModifiedBy : 0; var chargeTypeList = unitOfWork.TblInsCommisionStructureLineRepository.Get(x => x.ComStructID == commisionStructureHeader.CommisionStructureLineID).ToList(); ChargeTypeVM chargeType = new ChargeTypeVM(); foreach (var chargeTpeListLines in chargeTypeList) { chargeType.ChargeTypeID = (int)chargeTpeListLines.ChargeTypeID > 0 ? (int)chargeTpeListLines.ChargeTypeID:0; chargeType.Percentage = Convert.ToDouble(chargeTpeListLines.Percentage) > 0 ? Convert.ToDouble(chargeTpeListLines.Percentage) : 0.0; chargeTpeListVm.Add(chargeType); } commisionStructureHeaderVM.ChargeTypeList = chargeTpeListVm; commisionStructureHeaderList.Add(commisionStructureHeaderVM); } return(commisionStructureHeaderList); } catch (Exception ex) { throw; } }
public bool DeleteInsuranceClass(int insuranceClassID) { using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction()) { try { tblInsClass insClass = unitOfWork.TblInsClassRepository.GetByID(insuranceClassID); unitOfWork.TblInsClassRepository.Delete(insClass); unitOfWork.Save(); //Complete the Transaction dbTransaction.Commit(); return(true); } catch (Exception ex) { //Roll back the Transaction dbTransaction.Rollback(); return(false); } } }