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