// GET: Home
public ActionResult Index()
{
/*Model veritabani = new Model();
*
* veritabani.anatablo.Add(new anatablo
* {
* parkid = 1,
* aracplakasi = "14 ZXC 34",
* cihazid = 5,
* giriszamani = new DateTime(2018, 07, 19, 6, 00, 0),
* cikiszamani = new DateTime(2018, 07, 19, 8, 35, 0),
* kullaniciid = "Ankabeta",
* firmaid = 1
* });
*
* veritabani.SaveChanges();*/
DateTime simdi = new DateTime(2018, 07, 19, 11, 00, 0);
DateTime gununBaslangici = new DateTime(2018, 07, 19, 0, 00, 0);
int gecenSaniye = (int)simdi.Subtract(gununBaslangici).TotalSeconds;
int bugunkuAracSayisi = GrafikVeriOlusturucu.dilimdeGirmisAraclar(1, 'f', gununBaslangici, simdi).Count();
double toplamParkSuresi = GrafikVeriOlusturucu.listedekilerinHarcadigiToplamZaman(GrafikVeriOlusturucu.dilimdeGirmisAraclar(1, 'f', gununBaslangici, simdi)
, gununBaslangici, simdi);
double anlikDoluluk = GrafikVeriOlusturucu.HerhangiBirAndaDolulukOranı(1, 'f', simdi);
ViewBag.bugunkuAracSayisi = bugunkuAracSayisi;
ViewBag.toplamParkSuresi = toplamParkSuresi;
ViewBag.anlikDoluluk = anlikDoluluk;
return(View());
}
public ActionResult Double(int id)
{
return(View(new ZamanAraligiVerisi {
Baslangic = new DateTime(2018, 7, 19, 0, 0, 0),
Bitis = new DateTime(2018, 7, 19, 20, 10, 0),
Deger = GrafikVeriOlusturucu.listedekilerinHarcadigiToplamZaman
(GrafikVeriOlusturucu.dilimdeBulunmusAraclar(id, 'p', new DateTime(2018, 7, 19, 0, 0, 0), new DateTime(2018, 7, 19, 20, 10, 0))
, new DateTime(2018, 7, 19, 0, 0, 0), new DateTime(2018, 7, 19, 20, 10, 0))
}));
}
public ActionResult GrafikForm(string Giris, string Cikis)
{
DateTime girisZamani = DateTime.ParseExact(Giris, "dd/MM/yyyy HH:mm", null);
DateTime cikisZamani = DateTime.ParseExact(Cikis, "dd/MM/yyyy HH:mm", null);
List <int> arabaSayisi = new List <int>();
List <string> etiketler = new List <string>();
foreach (var i in GrafikVeriOlusturucu.GunlereGoreGirenArac(7, 'p', girisZamani, cikisZamani))
{
arabaSayisi.Add((int)(i.Deger));
etiketler.Add(GrafikVeriOlusturucu.GrafikVeriEtiketiOlustur(i, "dd/MM", false));
}
ViewBag.Etiketler = etiketler;
return(View("GrafikCiz", arabaSayisi));
}
public ActionResult AylikOrtalama(int id)
{
return(View(GrafikVeriOlusturucu.AyIcindeOrtalamaBul(GrafikVeriOlusturucu.GunlereGoreGirenArac(id, 'p', new DateTime(2018, 4, 01, 0, 0, 0), new DateTime(2018, 6, 30, 23, 59, 59)))));
}
public ActionResult SaatlikOrtalama(int id)
{
return(View(GrafikVeriOlusturucu.OrtalamaBul(24, GrafikVeriOlusturucu.SaatlereGoreGirenArac(id, 'p', new DateTime(2018, 1, 01, 0, 0, 0), new DateTime(2018, 8, 5, 23, 59, 0)))));
}
public ActionResult Saatlik(int id)
{
return(View(GrafikVeriOlusturucu.SaatlereGoreGirenArac(id, 'p', new DateTime(2018, 7, 01, 0, 0, 0), new DateTime(2018, 7, 5, 23, 59, 0))));
}
public ActionResult Yillik(int id)
{
return(View(GrafikVeriOlusturucu.YillaraGoreGirenArac(id, 'p', new DateTime(2016, 1, 01, 0, 0, 0), new DateTime(2018, 12, 31, 23, 59, 0))));
}
public ActionResult Haftalik(int id)
{
return(View(GrafikVeriOlusturucu.HaftalaraGoreGirenArac(id, 'p', new DateTime(2018, 1, 01, 0, 0, 0), new DateTime(2018, 8, 5, 23, 59, 0))));
}
public ActionResult Gunluk(int id)
{
return(View(GrafikVeriOlusturucu.GunlereGoreGirenArac(id, 'p', new DateTime(2018, 4, 01, 0, 0, 0), new DateTime(2018, 6, 30, 23, 59, 59))));
}
public ActionResult AnlikDoluluk(int id)
{
return(View(GrafikVeriOlusturucu.HerhangiBirAndaDolulukOranı(id, 'p', new DateTime(2018, 7, 19, 11, 0, 0))));
}
public ActionResult Aylik(int id)
{
return(View(GrafikVeriOlusturucu.AylaraGoreGirenArac(id, 'p', new DateTime(2018, 1, 01, 0, 0, 0), new DateTime(2018, 6, 30, 23, 59, 59))));
}
// GET: Home
public ActionResult Index()
{
return(View(GrafikVeriOlusturucu.AylaraGoreGirenArac(24, 'c', new DateTime(2016, 12, 01, 0, 30, 0), new DateTime(2018, 12, 31, 0, 30, 0))));
}
