public async Task <IActionResult> Delete(int Id)
{
LoadsServices ls = new LoadsServices(_Context);
bool x = await ls.DeleteLoad(Id);
return(RedirectToAction("Index"));
}
/* [HttpGet]
* public IActionResult PeakPerDay()
* {
* FactoryService fs = new FactoryService(_Context);
* ViewBag.factories = fs.GetAllFactoriesSimple();
* PrimarySourceSerivce ps = new PrimarySourceSerivce(_Context);
* ViewBag.Primary = ps.GetAllPrimarySources();
* LoadsServices ls = new LoadsServices(_Context);
* ViewBag.Loads = ls.GetAllLoads();
* return View();
* }
* [HttpPost]*/
public IActionResult PeakPerDay(DateTime date, int type = -1, int primId = -1, int loadId = -1)
{
FactoryService fs = new FactoryService(_Context);
ViewBag.factories = fs.GetAllFactoriesSimple();
PrimarySourceSerivce ps = new PrimarySourceSerivce(_Context);
ViewBag.Primary = ps.GetAllPrimarySources();
LoadsServices ls = new LoadsServices(_Context);
ViewBag.Loads = ls.GetAllLoads();
ReportService rs = new ReportService(_Context);
PowerPeakViewModel res = new PowerPeakViewModel();
if (type == 1)
{
res = rs.PowerPeakPerDay(date, type, primId);
}
else
{
res = rs.PowerPeakPerDay(date, type, loadId);
}
return(View(res));
}
public ActionResult Edit(LoadDataModel obj)
{
LoadsServices ld = new LoadsServices(_Context);
var load = ld.EditLoadAsyn(obj);
return(RedirectToAction("Index"));
}
public IActionResult Edit(int Id)
{
LoadsServices ld = new LoadsServices(_Context);
var load = ld.GetLoadById(Id);
ViewBag.Functions = ld.GetAllFunctions();
return(View(load));
}
public IActionResult HarmonicStat()
{
FactoryService fs = new FactoryService(_Context);
LoadsServices ls = new LoadsServices(_Context);
ViewBag.factories = fs.GetAllFactoriesSimple();
ViewBag.loads = ls.GetAllLoads();
ViewBag.functions = ls.GetAllFunctions();
return(View());
}
public IActionResult Instantaneous()
{
FactoryService fs = new FactoryService(_Context);
LoadsServices ls = new LoadsServices(_Context);
ViewBag.factories = fs.GetAllFactoriesSimple();
ViewBag.loads = ls.GetAllLoads();
return(View());
}
public IActionResult homeCreate(int Id)
{
FactoryService fs = new FactoryService(_Context);
LoadsServices ls = new LoadsServices(_Context);
ViewBag.factories = fs.GetAllFactoriesSimple();
ViewBag.Functions = ls.GetAllFunctions();
return(View());
}
public IActionResult HarmonicOrder(DateTime date, int HarmOrder = -1, int loadId = -1)
{
RushHourViewModel res = new RushHourViewModel();
ReportService rs = new ReportService(_Context);
LoadsServices ls = new LoadsServices(_Context);
ViewBag.loads = ls.GetAllLoads();
if (HarmOrder != -1)
{
res = rs.HaemonicOrderForLoadId(loadId, date, HarmOrder);
ViewBag.LoadName = (ls.GetLoadById(loadId)).name;
}
return(View(res));
}
public IActionResult Index(int facid = -1, int PrimOrSec = -1, int sourceid = -1)
{
FactoryService fs = new FactoryService(_Context);
ViewBag.factories = fs.GetAllFactoriesSimple();
LoadsServices ls = new LoadsServices(_Context);
List <LoadDataModel> ld = ls.GetAllLoads();
if (facid != -1)
{
if (sourceid != -1)
{
ld = ls.MappingToLsDM(_Context.Load.Where(s => s.SourceId == sourceid).ToList());
}
else
{
List <LoadDataModel> tmp = new List <LoadDataModel>();
foreach (var item in ld)
{
int fid = 0;
if (item.SourceId % 2 != 0)
{
fid = _Context.PrimarySource.SingleOrDefault(p => p.Code == Convert.ToString(item.SourceId)).FactoryId;
if (PrimOrSec == 1 && facid == fid)
{
tmp.Add(item);
}
}
if (item.SourceId % 2 == 0)
{
fid = _Context.secondarySource.SingleOrDefault(p => p.Code == Convert.ToString(item.SourceId)).Fac_Id;
if (PrimOrSec == 2 && facid == fid)
{
tmp.Add(item);
}
}
if (PrimOrSec == -1 && facid == fid)
{
tmp.Add(item);
}
}
ld = tmp;
}
}
return(View(ld));
}
public List <EnergyC> EnergyConsumedAjax(int id, int sort, string val, DateTime datefrom, DateTime dateto)
{
List <EnergyC> res = new List <EnergyC>();
List <EnergyC> results = new List <EnergyC>();
FactoryService fs = new FactoryService(_Context);
LoadsServices ls = new LoadsServices(_Context);
ReportService rs = new ReportService(_Context);
var i = 0;
ViewBag.functions = ls.GetAllFunctions();
if (sort == 1)
{
while (datefrom != dateto.AddDays(1))
{
res = rs.GetEnergies(id, sort, val, datefrom);
foreach (var item in res)
{
results.Add(item);
}
datefrom = datefrom.AddDays(1);
}
}
else
{
while (datefrom != dateto.AddDays(1))
{
var loads = _Context.Load.Where(l => l.Function == val).ToList();
foreach (var load in loads)
{
res = rs.GetEnergies(id, sort, Convert.ToString(load.Id), datefrom);
foreach (var item in res)
{
results.Add(item);
}
sort = 2;
}
datefrom = datefrom.AddDays(1);
i++;
}
}
return(results);
}
public async Task <IActionResult> homeCreate(LoadDataModel obj)
{
LoadsServices ls = new LoadsServices(_Context);
var y = ls.GetLoadByName(obj.name, obj.SourceId);
if (y != null)
{
FactoryService fs = new FactoryService(_Context);
ViewBag.factories = fs.GetAllFactoriesSimple();
ModelState.AddModelError("Name", "Name is already exist");
return(View("homecreate", obj));
}
bool ch = await ls.CreateLoadAsync(obj);
return(RedirectToAction("Index"));
}
//ABDO
public IActionResult powerpeak(int primId, int loadId, int type = -1) //type 1 -> prim , 2 -> load
{
ReportService rs = new ReportService(_Context);
PrimarySourceSerivce ps = new PrimarySourceSerivce(_Context);
ViewBag.Primary = ps.GetAllPrimarySources();
LoadsServices ls = new LoadsServices(_Context);
ViewBag.loads = ls.GetAllLoads();
PowerPeakViewModel res = new PowerPeakViewModel();
if (type == 1)
{
res = rs.PowerPeakBySourceID(primId, type);
}
else if (type == 2)
{
res = rs.PowerPeakBySourceID(loadId, type);
}
return(View(res));
}
public LoadDataModel GetLoadDetails(int Id)
{
LoadsServices ls = new LoadsServices(_Context);
return(ls.GetLoadById(Id));
}
