public JsonResult Get()
{
var almanacDays =
_repository.Query<AlmanacDay>(x=> x.Date >= SystemDateTime.Now().AddDays(-30)).OrderByDescending(x=>x.Date);
var mappedAlmanacDays =
_mappingEngine.Map<IEnumerable<AlmanacDay>, IEnumerable<AlmanacDayGridItemModel>>(almanacDays);
var almanacDayGridSummary = new AlmanacDayGridSummaryModel {AlmanacDays = mappedAlmanacDays};
return Json(almanacDayGridSummary, JsonRequestBehavior.AllowGet);
}
public JsonResult GetRainfallData(int locationId, int periodId)
{
var daysToAdd = 0;
switch ((PeriodType)periodId)
{
case PeriodType.Today:
daysToAdd = 0;
break;
case PeriodType.Yesterday:
daysToAdd = -1;
break;
case PeriodType.LastWeek:
daysToAdd = -7;
break;
case PeriodType.LastMonth:
daysToAdd = -30;
break;
case PeriodType.LastYear:
daysToAdd = -365;
break;
default:
daysToAdd = 0;
break;
}
IEnumerable<AlmanacDay> almanacDays = locationId != 0
? _repository.Query<AlmanacDay>(
x => x.Date.Date >= SystemDateTime.Now().AddDays(daysToAdd).Date && x.City.Id == locationId)
.OrderByDescending(x => x.Date)
: _repository.Query<AlmanacDay>(x => x.Date.Date >= SystemDateTime.Now().AddDays(daysToAdd).Date)
.OrderByDescending(x => x.Date);
var mappedAlmanacDays =
_mappingEngine.Map<IEnumerable<AlmanacDay>, IEnumerable<AlmanacDayGridItemModel>>(almanacDays);
var almanacDayGridSummary = new AlmanacDayGridSummaryModel { AlmanacDays = mappedAlmanacDays };
return Json(almanacDayGridSummary, JsonRequestBehavior.AllowGet);
}
public JsonResult GetRainfallData(int locationId, int periodId, TableParameter param)
{
int daysfrom;
int daysTo;
switch ((PeriodType)periodId)
{
case PeriodType.Today:
daysfrom = 0;
daysTo = 0;
break;
case PeriodType.Yesterday:
daysfrom = -1;
daysTo = -1;
break;
case PeriodType.LastWeek:
daysfrom = -7;
daysTo = -1;
break;
case PeriodType.LastMonth:
daysfrom = -30;
daysTo = -1;
break;
case PeriodType.LastYear:
daysfrom = -365;
daysTo = -1;
break;
default:
daysfrom = 0;
daysTo = 0;
break;
}
var totalRecords = locationId != 0
? _repository.Query<AlmanacDay>(
x => x.Date.Date >= SystemDateTime.Now().AddDays(daysfrom).Date
&& x.Date.Date <= SystemDateTime.Now().AddDays(daysTo).Date
&& x.City.Id == locationId).Count()
: _repository.Query<AlmanacDay>(
x => x.Date.Date >= SystemDateTime.Now().AddDays(daysfrom).Date
&& x.Date.Date <= SystemDateTime.Now().AddDays(daysTo).Date).Count();
IEnumerable<AlmanacDay> almanacDays = locationId != 0
? _repository.Query<AlmanacDay>(
x => x.Date.Date >= SystemDateTime.Now().AddDays(daysfrom).Date
&& x.Date.Date <= SystemDateTime.Now().AddDays(daysTo).Date
&& x.City.Id == locationId)
.OrderByDescending(x => x.Date).Skip(param.iDisplayStart).Take(param.iDisplayLength)
: _repository.Query<AlmanacDay>(
x => x.Date.Date >= SystemDateTime.Now().AddDays(daysfrom).Date
&& x.Date.Date <= SystemDateTime.Now().AddDays(daysTo).Date)
.OrderByDescending(x => x.Date).Skip(param.iDisplayStart).Take(param.iDisplayLength);
var mappedAlmanacDays =
_mappingEngine.Map<IEnumerable<AlmanacDay>, IEnumerable<AlmanacDayGridItemModel>>(almanacDays);
var almanacDayGridSummary = new AlmanacDayGridSummaryModel
{
sEcho = param.sEcho,
aaData = mappedAlmanacDays,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords
};
return Json(almanacDayGridSummary, JsonRequestBehavior.AllowGet);
}
public JsonResult GetRainfallDataByLocation(int locationId)
{
var almanacDays = _repository.Query<AlmanacDay>(x => x.City.Id == locationId);
var mappedAlmanacDays =
_mappingEngine.Map<IEnumerable<AlmanacDay>, IEnumerable<AlmanacDayGridItemModel>>(almanacDays);
var almanacDayGridSummary = new AlmanacDayGridSummaryModel { AlmanacDays = mappedAlmanacDays };
return Json(almanacDayGridSummary, JsonRequestBehavior.AllowGet);
}
