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); } } }