public PartialViewResult GetGazRecord(int year)
{
ewidencjaContext ew = new ewidencjaContext();
List <Gaz> lista_gaz = new List <Gaz>();
var tzg = ew.TblZuzycieGazu.Where(a => a.Data.Value.Year == year).OrderByDescending(a => a.Data).Select(x => new { x.Kwh, x.Data, x.WskLicznika });
if (year == 0)
{
tzg = ew.TblZuzycieGazu.OrderByDescending(a => a.Data).Select(x => new { x.Kwh, x.Data, x.WskLicznika });
}
foreach (var entry in tzg)
{
Gaz g = new Gaz();
g.kwh = entry.Kwh.ToString();
g.data = entry.Data.ToString();
g.stan_licznika = entry.WskLicznika.ToString();
lista_gaz.Add(g);
}
return(PartialView("_GazValuesPartial", lista_gaz));
}
public IActionResult Gaz()
{
List <Gaz> gaz = new List <Gaz>();
ViewBag.path = configuration.GetSection("AppSettings").GetSection("appath").Value;
try
{
ewidencjaContext ew = new ewidencjaContext();
var tzg = ew.TblZuzycieGazu.OrderByDescending(a => a.Data).Select(x => new { x.Kwh, x.Data, x.WskLicznika });
foreach (var entry in tzg)
{
Gaz g = new Gaz();
g.kwh = entry.Kwh.ToString();
g.data = entry.Data.ToString();
g.stan_licznika = entry.WskLicznika.ToString();
gaz.Add(g);
}
ViewBag.IP = HttpContext.Features.Get <IHttpConnectionFeature>()?.RemoteIpAddress.ToString();
Model m = new Model();
m.InsertIPIntoDB((string)ViewBag.IP, "/Home/Gaz");
}
catch (Exception ex)
{
ViewBag.info_msg = ex.ToString();
}
return(View(gaz));
}
public JsonResult GetGazChartYear()
{
List <Gaz> gazyears = new List <Gaz>();
ewidencjaContext ew = new ewidencjaContext();
var tzg = ew.TblZuzycieGazu.Select(x => new { x.Data, x.WskLicznika }).ToList();
foreach (var item in tzg)
{
Gaz g = new Gaz();
g.data = item.Data.ToString();
g.stan_licznika = item.WskLicznika.ToString();
gazyears.Add(g);
}
return(Json(gazyears));
}
public override String ToString()
{
String value = "Roll: " + Roll.ToString("0.000") + ", Pitch: " + Pitch.ToString("0.000") + ", Yaw: " + Yaw.ToString("0.000") + ", Gaz: " + Gaz.ToString("0.000");
if (CameraSwap)
{
value += ", Change Camera";
}
if (TakeOff)
{
value += ", Take Off";
}
if (Land)
{
value += ", Land";
}
if (Hover)
{
value += ", Hover";
}
if (Emergency)
{
value += ", Emergency";
}
if (FlatTrim)
{
value += ", Flat Trim";
}
return(value);
}
