public bool UpdateInsuranceSubClass(InsuranceSubClassVM insuranceSubClassVM)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
tblInsSubClass insSubClass = unitOfWork.TblInsSubClassRepository.GetByID(insuranceSubClassVM.InsuranceSubClassID);
insSubClass.InsClassID = insuranceSubClassVM.InsuranceClassID;
insSubClass.Description = insuranceSubClassVM.Description;
insSubClass.IsActive = insuranceSubClassVM.IsActive;
insSubClass.ModifiedDate = DateTime.Now;
insSubClass.ModifiedBy = insuranceSubClassVM.ModifiedBy;
unitOfWork.TblInsSubClassRepository.Update(insSubClass);
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 DeleteInsuranceSubClass(int insuranceSubClassID)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
tblInsSubClass insSubClass = unitOfWork.TblInsSubClassRepository.GetByID(insuranceSubClassID);
unitOfWork.TblInsSubClassRepository.Delete(insSubClass);
unitOfWork.Save();
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
