public GetAllYearlyMaintenance GetAllYearlyMaintenance(GetAllYearlyMaintenanceRequest getAllYearlyMaintenanceRequest, GlobalCodeMainResponse feeType)
{
IEnumerable <GetYearlyMaintenance> data;
GetAllYearlyMaintenance getAllYearlyMaintenance = new GetAllYearlyMaintenance();
List <GetYearlyMaintenance> getYearlyMaintenances = new List <GetYearlyMaintenance>();
var allYears = _ObjContext.YearlyMaintainence.Where(x => x.IsActive == true && x.IsDeleted == false).ToList();
if (allYears.Count() != 0)
{
for (int i = 0; i <= allYears.Count() - 1; i++)
{
GetYearlyMaintenance getYearlyMaintenance = new GetYearlyMaintenance();
var yearlyFee = _ObjContext.YearlyMaintainenceFee.Where(x => x.YearlyMaintainenceId == allYears[i].YearlyMaintainenceId &&
x.FeeType == "GeneralFee" &&
x.FeeName == "Administration" && x.IsActive == true && x.IsDeleted == false).ToList();
decimal yearlyPreFee = yearlyFee.Where(x => x.TimeFrame == "Pre").Select(x => x.Amount).FirstOrDefault();
decimal yearlyPostFee = yearlyFee.Where(x => x.TimeFrame == "Post").Select(x => x.Amount).FirstOrDefault();
getYearlyMaintenance.YearlyMaintenanceId = allYears[i].YearlyMaintainenceId;
getYearlyMaintenance.Year = allYears[i].Years;
getYearlyMaintenance.PreEntryCutOffDate = allYears[i].PreEntryCutOffDate;
getYearlyMaintenance.PreEntryFee = yearlyPreFee;
getYearlyMaintenance.PostEntryFee = yearlyPostFee;
getYearlyMaintenance.DateCreated = allYears[i].Date;
getYearlyMaintenances.Add(getYearlyMaintenance);
}
}
data = getYearlyMaintenances.ToList();
if (data.Count() != 0)
{
if (getAllYearlyMaintenanceRequest.SearchTerm != null && getAllYearlyMaintenanceRequest.SearchTerm != "")
{
data = data.Where(x => Convert.ToString(x.Year).Contains(getAllYearlyMaintenanceRequest.SearchTerm) || Convert.ToString(x.PreEntryCutOffDate.Date).Contains(getAllYearlyMaintenanceRequest.SearchTerm) ||
Convert.ToString(x.PreEntryFee).Contains(getAllYearlyMaintenanceRequest.SearchTerm) || Convert.ToString(x.PostEntryFee).Contains(getAllYearlyMaintenanceRequest.SearchTerm) ||
Convert.ToString(x.DateCreated.Date).Contains(getAllYearlyMaintenanceRequest.SearchTerm));
}
if (getAllYearlyMaintenanceRequest.OrderByDescending == true)
{
data = data.OrderByDescending(x => x.GetType().GetProperty(getAllYearlyMaintenanceRequest.OrderBy).GetValue(x));
}
else
{
data = data.OrderBy(x => x.GetType().GetProperty(getAllYearlyMaintenanceRequest.OrderBy).GetValue(x));
}
getAllYearlyMaintenance.TotalRecords = data.Count();
if (getAllYearlyMaintenanceRequest.AllRecords)
{
getAllYearlyMaintenance.getYearlyMaintenances = data.ToList();
}
else
{
getAllYearlyMaintenance.getYearlyMaintenances = data.Skip((getAllYearlyMaintenanceRequest.Page - 1) * getAllYearlyMaintenanceRequest.Limit).Take(getAllYearlyMaintenanceRequest.Limit).ToList();
}
}
return(getAllYearlyMaintenance);
}
public ActionResult GetAllYearlyMaintenance(GetAllYearlyMaintenanceRequest getAllYearlyMaintenanceRequest)
{
_mainResponse = _yearlyMaintenanceService.GetAllYearlyMaintenance(getAllYearlyMaintenanceRequest);
_jsonString = Mapper.Convert <GetAllYearlyMaintenance>(_mainResponse);
return(new OkObjectResult(_jsonString));
}