public List <CommisionStructureLineVM> GetAllCommisionStructureLinesByBusinessUnitID(int businessUnitID)
{
try
{
var commisionStructureLineData = unitOfWork.TblCommisionStructureLineRepository.Get(x => x.tblCommisionStructureHeader.BUID == businessUnitID).ToList();
List <CommisionStructureLineVM> commisionStructureLineList = new List <CommisionStructureLineVM>();
foreach (var commisionStructureLine in commisionStructureLineData)
{
CommisionStructureLineVM commisionStructureLineVM = new CommisionStructureLineVM();
commisionStructureLineVM.CommisionStructureLineID = commisionStructureLine.ComStructLineID;
commisionStructureLineVM.CommisionStructureID = commisionStructureLine.ComStructID != null?Convert.ToInt32(commisionStructureLine.ComStructID) : 0;
if (commisionStructureLineVM.CommisionStructureID > 0)
{
commisionStructureLineVM.CommisionStructureName = commisionStructureLine.tblCommisionStructureHeader.ComStructName;
}
commisionStructureLineVM.RateCategoryID = commisionStructureLine.RateCategoryID != null?Convert.ToInt32(commisionStructureLine.RateCategoryID) : 0;
if (commisionStructureLineVM.RateCategoryID > 0)
{
commisionStructureLineVM.RateCategoryName = commisionStructureLine.tblRateCategory.RateCategory;
}
commisionStructureLineVM.IsAgeConsider = commisionStructureLine.IsAgeConsider;
commisionStructureLineVM.AgeFrom = commisionStructureLine.AgeFrom != null?Convert.ToInt32(commisionStructureLine.AgeFrom) : 0;
commisionStructureLineVM.AgeTo = commisionStructureLine.AgeTo != null?Convert.ToInt32(commisionStructureLine.AgeTo) : 0;
commisionStructureLineVM.IsFixed = commisionStructureLine.isFixed;
commisionStructureLineVM.RateValue = commisionStructureLine.RateValue != null?Convert.ToDouble(commisionStructureLine.RateValue) : 0;
commisionStructureLineVM.CreatedDate = commisionStructureLine.CreatedDate != null?commisionStructureLine.CreatedDate.ToString() : string.Empty;
commisionStructureLineVM.ModifiedDate = commisionStructureLine.ModifiedDate != null?commisionStructureLine.ModifiedDate.ToString() : string.Empty;
commisionStructureLineVM.CreatedBy = commisionStructureLine.CreatedBy != null?Convert.ToInt32(commisionStructureLine.CreatedBy) : 0;
commisionStructureLineVM.ModifiedBy = commisionStructureLine.ModifiedBy != null?Convert.ToInt32(commisionStructureLine.ModifiedBy) : 0;
commisionStructureLineList.Add(commisionStructureLineVM);
}
return(commisionStructureLineList);
}
catch (Exception ex)
{
throw;
}
}
public CommisionStructureLineVM GetCommisionStructureLineByID(int commisionStructureLineID)
{
try
{
tblCommisionStructureLine commisionStructureLineData = unitOfWork.TblCommisionStructureLineRepository.GetByID(commisionStructureLineID);
CommisionStructureLineVM commisionStructureLineVM = new CommisionStructureLineVM();
commisionStructureLineVM.CommisionStructureLineID = commisionStructureLineData.ComStructLineID;
commisionStructureLineVM.CommisionStructureID = commisionStructureLineData.ComStructID != null?Convert.ToInt32(commisionStructureLineData.ComStructID) : 0;
if (commisionStructureLineVM.CommisionStructureID > 0)
{
commisionStructureLineVM.CommisionStructureName = commisionStructureLineData.tblCommisionStructureHeader.ComStructName;
}
commisionStructureLineVM.RateCategoryID = commisionStructureLineData.RateCategoryID != null?Convert.ToInt32(commisionStructureLineData.RateCategoryID) : 0;
if (commisionStructureLineVM.RateCategoryID > 0)
{
commisionStructureLineVM.RateCategoryName = commisionStructureLineData.tblRateCategory.RateCategory;
}
commisionStructureLineVM.IsAgeConsider = commisionStructureLineData.IsAgeConsider;
commisionStructureLineVM.AgeFrom = commisionStructureLineData.AgeFrom != null?Convert.ToInt32(commisionStructureLineData.AgeFrom) : 0;
commisionStructureLineVM.AgeTo = commisionStructureLineData.AgeTo != null?Convert.ToInt32(commisionStructureLineData.AgeTo) : 0;
commisionStructureLineVM.IsFixed = commisionStructureLineData.isFixed;
commisionStructureLineVM.RateValue = commisionStructureLineData.RateValue != null?Convert.ToDouble(commisionStructureLineData.RateValue) : 0;
commisionStructureLineVM.CreatedDate = commisionStructureLineData.CreatedDate != null?commisionStructureLineData.CreatedDate.ToString() : string.Empty;
commisionStructureLineVM.ModifiedDate = commisionStructureLineData.ModifiedDate != null?commisionStructureLineData.ModifiedDate.ToString() : string.Empty;
commisionStructureLineVM.CreatedBy = commisionStructureLineData.CreatedBy != null?Convert.ToInt32(commisionStructureLineData.CreatedBy) : 0;
commisionStructureLineVM.ModifiedBy = commisionStructureLineData.ModifiedBy != null?Convert.ToInt32(commisionStructureLineData.ModifiedBy) : 0;
return(commisionStructureLineVM);
}
catch (Exception ex)
{
throw;
}
}
public IHttpActionResult UpdateComStructureLine([FromBody] JObject data)
{
try
{
int comStructLineID = !string.IsNullOrEmpty(data.SelectToken("ComStructLineID").Value <string>()) ? Convert.ToInt32(data.SelectToken("ComStructLineID").Value <string>()) : 0;
int comStructID = !string.IsNullOrEmpty(data.SelectToken("ComStructID").Value <string>()) ? Convert.ToInt32(data.SelectToken("ComStructID").Value <string>()) : 0;
int rateCategoryID = !string.IsNullOrEmpty(data.SelectToken("RateCategoryID").Value <string>()) ? Convert.ToInt32(data.SelectToken("RateCategoryID").Value <string>()) : 0;
bool isAgeConsider = !string.IsNullOrEmpty(data.SelectToken("IsAgeConsider").Value <string>()) ? Convert.ToBoolean(data.SelectToken("IsAgeConsider").Value <string>()) : false;
int ageFrom = !string.IsNullOrEmpty(data.SelectToken("AgeFrom").Value <string>()) ? Convert.ToInt32(data.SelectToken("AgeFrom").Value <string>()) : 0;
int ageTo = !string.IsNullOrEmpty(data.SelectToken("AgeTo").Value <string>()) ? Convert.ToInt32(data.SelectToken("AgeTo").Value <string>()) : 0;
bool isFixed = !string.IsNullOrEmpty(data.SelectToken("isFixed").Value <string>()) ? Convert.ToBoolean(data.SelectToken("isFixed").Value <string>()) : false;
double rateValue = !string.IsNullOrEmpty(data.SelectToken("RateValue").Value <string>()) ? Convert.ToDouble(data.SelectToken("RateValue").Value <string>()) : 0;
int userID = !string.IsNullOrEmpty(data.SelectToken("UserID").Value <string>()) ? Convert.ToInt32(data.SelectToken("UserID").Value <string>()) : 0;
CommisionStructureLineVM commisionStructureLineVM = new CommisionStructureLineVM();
commisionStructureLineVM.CommisionStructureLineID = comStructLineID;
commisionStructureLineVM.CommisionStructureID = comStructID;
commisionStructureLineVM.RateCategoryID = rateCategoryID;
commisionStructureLineVM.IsAgeConsider = isAgeConsider;
commisionStructureLineVM.AgeFrom = ageFrom;
commisionStructureLineVM.AgeTo = ageTo;
commisionStructureLineVM.IsFixed = isFixed;
commisionStructureLineVM.RateValue = rateValue;
commisionStructureLineVM.ModifiedBy = userID;
bool status = manageCommisionStructure.UpdateCommisionStructureLine(commisionStructureLineVM);
if (status)
{
return(Json(new { status = true, message = "Successfully updated" }));
}
else
{
return(Json(new { status = false, message = "Update Failed" }));
}
}
catch (Exception ex)
{
return(Json(new { status = false, message = "Unknown error occurred" }));
}
}
public bool UpdateCommisionStructureLine(CommisionStructureLineVM commisionStructureLineVM)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
tblCommisionStructureLine commisionStructureLine = unitOfWork.TblCommisionStructureLineRepository.GetByID(commisionStructureLineVM.CommisionStructureLineID);
commisionStructureLine.ComStructID = commisionStructureLineVM.CommisionStructureID;
commisionStructureLine.RateCategoryID = commisionStructureLineVM.RateCategoryID;
commisionStructureLine.IsAgeConsider = commisionStructureLineVM.IsAgeConsider;
if (commisionStructureLine.IsAgeConsider)
{
commisionStructureLine.AgeFrom = commisionStructureLineVM.AgeFrom;
commisionStructureLine.AgeTo = commisionStructureLineVM.AgeTo;
}
else
{
commisionStructureLine.AgeFrom = null;
commisionStructureLine.AgeTo = null;
}
commisionStructureLine.isFixed = commisionStructureLineVM.IsFixed;
commisionStructureLine.RateValue = commisionStructureLineVM.RateValue;
commisionStructureLine.ModifiedDate = DateTime.Now;
commisionStructureLine.ModifiedBy = commisionStructureLineVM.ModifiedBy;
unitOfWork.TblCommisionStructureLineRepository.Update(commisionStructureLine);
unitOfWork.Save();
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
