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 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 IHttpActionResult SaveInsComStructureHeader([FromBody] JObject data)
{
try
{
string comStructName = !string.IsNullOrEmpty(data.SelectToken("ComStructName").Value <string>()) ? data.SelectToken("ComStructName").Value <string>() : string.Empty;
int businessUnitID = !string.IsNullOrEmpty(data.SelectToken("BUID").Value <string>()) ? Convert.ToInt32(data.SelectToken("BUID").Value <string>()) : 0;
int insCompanyID = !string.IsNullOrEmpty(data.SelectToken("InsCompanyID").Value <string>()) ? Convert.ToInt32(data.SelectToken("InsCompanyID").Value <string>()) : 0;
int insClassID = !string.IsNullOrEmpty(data.SelectToken("InsClassID").Value <string>()) ? Convert.ToInt32(data.SelectToken("InsClassID").Value <string>()) : 0;
int insSubClassID = !string.IsNullOrEmpty(data.SelectToken("InsSubClassID").Value <string>()) ? Convert.ToInt32(data.SelectToken("InsSubClassID").Value <string>()) : 0;
int userID = !string.IsNullOrEmpty(data.SelectToken("UserID").Value <string>()) ? Convert.ToInt32(data.SelectToken("UserID").Value <string>()) : 0;
List <ChargeTypeVM> chargeType = data.SelectToken("policyInfoRecObj").ToObject <List <ChargeTypeVM> >();
//ChargeTypeVM chargeType = data.SelectToken("policyInfoChargeList").ToObject<ChargeTypeVM>();
//chargeType.chargeTypeObj = chargeType;
if (!manageInsCommission.IsInsCommisionStructureHeaderAvailable(null, comStructName))
{
InsCommissionStructureHeaderVM commisionStructureHeaderVM = new InsCommissionStructureHeaderVM();
commisionStructureHeaderVM.CommisionStructureName = comStructName;
commisionStructureHeaderVM.BusinessUnitID = businessUnitID;
commisionStructureHeaderVM.InsuranceCompanyID = insCompanyID;
commisionStructureHeaderVM.InsuranceClassID = insClassID;
commisionStructureHeaderVM.InsuranceSubClassID = insSubClassID;
commisionStructureHeaderVM.CreatedBy = userID;
commisionStructureHeaderVM.ChargeTypeList = chargeType;
bool status = manageInsCommission.SaveInsCommisionStructureHeader(commisionStructureHeaderVM);
if (status)
{
return(Json(new { status = true, message = "Successfully Saved" }));
}
else
{
return(Json(new { status = false, message = "Save Failed" }));
}
}
else
{
return(Json(new { status = false, message = "Commission Structure Header already exists" }));
}
}
catch (Exception ex)
{
return(Json(new { status = false, message = "Unknown error occurred" }));
}
}
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);
}
}
}
