public JsonResult getAllStats()
{
//by defaults start year is 2015, end year = 2017
string Company = ((ClaimsIdentity)User.Identity).Claims.First(x => x.Type == ClaimTypes.UserData).Value;
ASKUEProvider AP = new ASKUEProvider(Company);
List<Power> DT = AP.GetASKUEAllRecords(2015, 2017);
return Json(new { startYear = 2015, endYear = 2017, data = DT }, JsonRequestBehavior.AllowGet);
}
public List<Power> getMonthByDayPower(string company,int year,int month)
{
var month_data = (from rows in workFacade.DaySumDataList()
where rows.Date.Value.Year == year
where rows.Date.Value.Month == month
where rows.Company == company
select rows).ToList();
string companyCode = workFacade.CompanyCodeList().Where(x => x.Company == company).First().Code;
int? month_theory_data = (from expData in workFacade.MonthDataList()
where expData.Year == year
where expData.Month == month
select expData.TheoryDayPower).ToList().First();
List<Power> returned = new List<Power>();
if (month_data.Count == 0)
{
workFacade.AddMonthToDaySumData(year,month, company);
}
DateTime date;
var info = TimeZoneInfo.FindSystemTimeZoneById("E. Europe Standard Time");
DateTimeOffset localServerTime = DateTimeOffset.Now;
DateTimeOffset UkraineTime = TimeZoneInfo.ConvertTime(localServerTime, info);
foreach (var item in month_data)
{
date = item.Date.Value.Date;
if (!item.PowerInvertor.HasValue)
{
if (date < UkraineTime.AddDays(-1))
{
try
{
var day_power = (from expData in workFacade.DayDataList()
where expData.Date.Value.Year == item.Date.Value.Year
where expData.Date.Value.Month == item.Date.Value.Month
where expData.Date.Value.Day == item.Date.Value.Day
where expData.Company == companyCode
orderby expData.Date
select expData).ToList().Last();
item.PowerInvertor = day_power.SumPowerDay / 1000;
workFacade.UpdateDaySumDataRow(item);
}
catch (Exception ex)
{
}
}
}
if ((!item.PowerASKUE.HasValue || !item.PowerKTP.HasValue)||(item.PowerASKUE == 0 || item.PowerKTP == 0))
{
if (date < UkraineTime.AddDays(-1))
{
ASKUEProvider ASP = new ASKUEProvider(company);
Tuple<int, int> data = ASP.GetDayData(item.Date.Value);
item.PowerASKUE = data.Item1;
item.PowerKTP = data.Item2;
workFacade.UpdateDaySumDataRow(item);
}
}
returned.Add(new Power(month_theory_data ?? 0, item.PowerInvertor ?? 0, item.PowerKTP ?? 0, item.PowerASKUE ?? 0, item.Insolation ?? 0));
}
return returned;
}
public JsonResult GetYearStats(int year)
{
if (year < 2000)
{
year += 1900;
}
string Company = ((ClaimsIdentity)User.Identity).Claims.First(x => x.Type == ClaimTypes.UserData).Value;
ASKUEProvider AP = new ASKUEProvider(Company);
List<Power> returned = AP.GetYearRecords(year);
return Json(returned, JsonRequestBehavior.AllowGet);
}