public bool UpdateCommisionStructureHeader(CommisionStructureHeaderVM commisionStructureHeaderVM) { using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction()) { try { tblCommisionStructureHeader commisionStructureHeader = unitOfWork.TblCommisionStructureHeaderRepository.GetByID(commisionStructureHeaderVM.CommisionStructureID); commisionStructureHeader.ComStructName = commisionStructureHeaderVM.CommisionStructureName; commisionStructureHeader.BUID = commisionStructureHeaderVM.BusinessUnitID; commisionStructureHeader.PartnerID = commisionStructureHeaderVM.PartnerID; commisionStructureHeader.InsCompanyID = commisionStructureHeaderVM.InsuranceCompanyID; commisionStructureHeader.InsClassID = commisionStructureHeaderVM.InsuranceClassID; commisionStructureHeader.InsSubClassID = commisionStructureHeaderVM.InsuranceSubClassID; commisionStructureHeader.ModifiedDate = DateTime.Now; commisionStructureHeader.ModifiedBy = commisionStructureHeaderVM.ModifiedBy; unitOfWork.TblCommisionStructureHeaderRepository.Update(commisionStructureHeader); unitOfWork.Save(); //Complete the Transaction dbTransaction.Commit(); return(true); } catch (Exception ex) { //Roll back the Transaction dbTransaction.Rollback(); return(false); } } }
public CommisionStructureHeaderVM GetCommisionStructureHeaderByID(int commisionStructureID) { try { tblCommisionStructureHeader commisionStructureHeaderData = unitOfWork.TblCommisionStructureHeaderRepository.GetByID(commisionStructureID); CommisionStructureHeaderVM commisionStructureHeaderVM = new CommisionStructureHeaderVM(); commisionStructureHeaderVM.CommisionStructureID = commisionStructureHeaderData.ComStructID; commisionStructureHeaderVM.CommisionStructureName = commisionStructureHeaderData.ComStructName; commisionStructureHeaderVM.BusinessUnitID = commisionStructureHeaderData.BUID != null?Convert.ToInt32(commisionStructureHeaderData.BUID) : 0; if (commisionStructureHeaderVM.BusinessUnitID > 0) { commisionStructureHeaderVM.BusinessUnitName = commisionStructureHeaderData.tblBussinessUnit.BussinessUnit; } commisionStructureHeaderVM.PartnerID = commisionStructureHeaderData.PartnerID != null?Convert.ToInt32(commisionStructureHeaderData.PartnerID) : 0; if (commisionStructureHeaderVM.PartnerID > 0) { commisionStructureHeaderVM.PartnerName = commisionStructureHeaderData.tblPartner.PartnerName; } commisionStructureHeaderVM.InsuranceCompanyID = commisionStructureHeaderData.InsCompanyID != null?Convert.ToInt32(commisionStructureHeaderData.InsCompanyID) : 0; if (commisionStructureHeaderVM.InsuranceCompanyID > 0) { commisionStructureHeaderVM.InsuranceCompanyName = commisionStructureHeaderData.tblInsCompany.InsCompany; } commisionStructureHeaderVM.InsuranceClassID = commisionStructureHeaderData.InsClassID != null?Convert.ToInt32(commisionStructureHeaderData.InsClassID) : 0; if (commisionStructureHeaderVM.InsuranceClassID > 0) { commisionStructureHeaderVM.InsuranceClassName = commisionStructureHeaderData.tblInsClass.Code; } commisionStructureHeaderVM.InsuranceSubClassID = commisionStructureHeaderData.InsSubClassID != null?Convert.ToInt32(commisionStructureHeaderData.InsSubClassID) : 0; if (commisionStructureHeaderVM.InsuranceSubClassID > 0) { commisionStructureHeaderVM.InsuranceSubClassName = commisionStructureHeaderData.tblInsSubClass.Description; } commisionStructureHeaderVM.CreatedDate = commisionStructureHeaderData.CreatedDate != null?commisionStructureHeaderData.CreatedDate.ToString() : string.Empty; commisionStructureHeaderVM.ModifiedDate = commisionStructureHeaderData.ModifiedDate != null?commisionStructureHeaderData.ModifiedDate.ToString() : string.Empty; commisionStructureHeaderVM.CreatedBy = commisionStructureHeaderData.CreatedBy != null?Convert.ToInt32(commisionStructureHeaderData.CreatedBy) : 0; commisionStructureHeaderVM.ModifiedBy = commisionStructureHeaderData.ModifiedBy != null?Convert.ToInt32(commisionStructureHeaderData.ModifiedBy) : 0; return(commisionStructureHeaderVM); } catch (Exception ex) { throw; } }
public IHttpActionResult UpdateComStructureHeader([FromBody] JObject data) { try { int comStructID = !string.IsNullOrEmpty(data.SelectToken("ComStructID").Value <string>()) ? Convert.ToInt32(data.SelectToken("ComStructID").Value <string>()) : 0; 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 partnerID = !string.IsNullOrEmpty(data.SelectToken("PartnerID").Value <string>()) ? Convert.ToInt32(data.SelectToken("PartnerID").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; if (!manageCommisionStructure.IsCommisionStructureHeaderAvailable(comStructID, comStructName)) { CommisionStructureHeaderVM commisionStructureHeaderVM = new CommisionStructureHeaderVM(); commisionStructureHeaderVM.CommisionStructureID = comStructID; commisionStructureHeaderVM.CommisionStructureName = comStructName; commisionStructureHeaderVM.BusinessUnitID = businessUnitID; commisionStructureHeaderVM.PartnerID = partnerID; commisionStructureHeaderVM.InsuranceCompanyID = insCompanyID; commisionStructureHeaderVM.InsuranceClassID = insClassID; commisionStructureHeaderVM.InsuranceSubClassID = insSubClassID; commisionStructureHeaderVM.ModifiedBy = userID; bool status = manageCommisionStructure.UpdateCommisionStructureHeader(commisionStructureHeaderVM); if (status) { return(Json(new { status = true, message = "Successfully updated" })); } else { return(Json(new { status = false, message = "Update 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 List <CommisionStructureHeaderVM> GetAllCommisionStructureHeadersByBusinessUnitID(int businessUnitID) { try { var commisionStructureHeaderData = unitOfWork.TblCommisionStructureHeaderRepository.Get(x => x.BUID == businessUnitID).ToList(); List <CommisionStructureHeaderVM> commisionStructureHeaderList = new List <CommisionStructureHeaderVM>(); foreach (var commisionStructureHeader in commisionStructureHeaderData) { CommisionStructureHeaderVM commisionStructureHeaderVM = new CommisionStructureHeaderVM(); commisionStructureHeaderVM.CommisionStructureID = commisionStructureHeader.ComStructID; commisionStructureHeaderVM.CommisionStructureName = commisionStructureHeader.ComStructName; commisionStructureHeaderVM.BusinessUnitID = commisionStructureHeader.BUID != null?Convert.ToInt32(commisionStructureHeader.BUID) : 0; if (commisionStructureHeaderVM.BusinessUnitID > 0) { commisionStructureHeaderVM.BusinessUnitName = commisionStructureHeader.tblBussinessUnit.BussinessUnit; } commisionStructureHeaderVM.PartnerID = commisionStructureHeader.PartnerID != null?Convert.ToInt32(commisionStructureHeader.PartnerID) : 0; if (commisionStructureHeaderVM.PartnerID > 0) { commisionStructureHeaderVM.PartnerName = commisionStructureHeader.tblPartner.PartnerName; } commisionStructureHeaderVM.InsuranceCompanyID = commisionStructureHeader.InsCompanyID != null?Convert.ToInt32(commisionStructureHeader.InsCompanyID) : 0; if (commisionStructureHeaderVM.InsuranceCompanyID > 0) { commisionStructureHeaderVM.InsuranceCompanyName = commisionStructureHeader.tblInsCompany.InsCompany; } commisionStructureHeaderVM.InsuranceClassID = commisionStructureHeader.InsClassID != null?Convert.ToInt32(commisionStructureHeader.InsClassID) : 0; if (commisionStructureHeaderVM.InsuranceClassID > 0) { commisionStructureHeaderVM.InsuranceClassName = commisionStructureHeader.tblInsClass.Code; } commisionStructureHeaderVM.InsuranceSubClassID = commisionStructureHeader.InsSubClassID != null?Convert.ToInt32(commisionStructureHeader.InsSubClassID) : 0; if (commisionStructureHeaderVM.InsuranceSubClassID > 0) { commisionStructureHeaderVM.InsuranceSubClassName = commisionStructureHeader.tblInsSubClass.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 != null?Convert.ToInt32(commisionStructureHeader.CreatedBy) : 0; commisionStructureHeaderVM.ModifiedBy = commisionStructureHeader.ModifiedBy != null?Convert.ToInt32(commisionStructureHeader.ModifiedBy) : 0; commisionStructureHeaderList.Add(commisionStructureHeaderVM); } return(commisionStructureHeaderList); } catch (Exception ex) { throw; } }