public ActionResult DateView(int?Rok, int?Mesic, int?Den, int?Region) { if (Rok == null) { Rok = System.DateTime.Now.Year; } if (Mesic == null) { Mesic = System.DateTime.Now.Month; } if (Den == null) { Mesic = System.DateTime.Now.Day; } List <Revize> list = new List <Revize>(); list = Revize.GetByDate(Mesic.Value, Rok.Value, Den.Value, Region.Value); list = Revize.LoopRevizeAndUpdateBatery(list); ViewBag.Region = Region; return(View(list)); }
public ActionResult List(int?Skupina, DateTime?DateFrom, DateTime?DateTo, int?Zakaznik, int?Status, bool send) { Session["List_Skupina"] = Skupina; Session["List_DateFrom"] = DateFrom.ToString(); Session["List_DateTo"] = DateTo.ToString(); Session["List_Status"] = Status; //string abc = Session["Test"].ToString(); RevizeListInput rl = new RevizeListInput(); //Create a list of select list items - this will be returned as your select list List <SelectListItem> newList = new List <SelectListItem> { new SelectListItem() { Value = "0", Text = "Vše" }, new SelectListItem() { Value = "1", Text = "Česká Republika" }, new SelectListItem() { Value = "2", Text = "Polsko" }, new SelectListItem() { Value = "3", Text = "Slovensko a Maďarsko" }, new SelectListItem() { Value = "4", Text = "Ostatní" } }; //Add select list item to list of selectlistitems rl.DateFrom = DateFrom; rl.DateTo = DateTo; //Return the list of selectlistitems as a selectlist ViewBag.Skupina = new SelectList(newList, "Value", "Text", Skupina); ViewBag.Zakaznik = new SelectList(db.Zakaznik.ToList(), "Id", "NazevZakaznika", Zakaznik); ViewBag.Status = new SelectList(db.StatusRevize.ToList(), "Id", "NazevStatusuRevize", Status); var x = db.Revize .Include(r => r.Provoz) .Include(r => r.RevizeSC) .Include(r => r.StatusRevize) .Include(r => r.Umisteni); if (DateFrom != null) { x = x.Where(r => r.DatumRevize >= DateFrom); } if (DateTo != null) { x = x.Where(r => r.DatumRevize <= DateTo); } if (Zakaznik != null) { x = x.Where(r => r.Provoz.ZakaznikId == Zakaznik); } if (Status != null) { x = x.Where(r => r.StatusRevizeId == Status); } if (Skupina != null && Skupina != 0) { x = x.Where(r => r.Provoz.Zakaznik.Region.Skupina == Skupina); } // var listrevizi = x.ToList(); listrevizi = Revize.LoopRevizeAndUpdateBatery(listrevizi); rl.Revize = listrevizi; ViewBag.ListDateFrom = DateFrom; ViewBag.ListDateTo = DateTo; ViewBag.ListStatus = db.StatusRevize.Where(r => r.Id == Status).Select(r => r.NazevStatusuRevize).FirstOrDefault(); if (Skupina == 0) { ViewBag.ListRegion = "Vše"; } if (Skupina == 1) { ViewBag.ListRegion = "Česká Republika"; } if (Skupina == 2) { ViewBag.ListRegion = "Polsko"; } if (Skupina == 3) { ViewBag.ListRegion = "Slovensko a Maďarsko"; } if (Skupina == 4) { ViewBag.ListRegion = "Ostatní"; } return(View(rl)); }
public ActionResult List(int?Skupina, DateTime?DateFrom, DateTime?DateTo, int?Zakaznik, int?Status) { string ListRegion = null; DateTime?ListDateFrom = null; DateTime?ListDateTo = null; string ListStatus = null; try { ListRegion = Session["List_Skupina"].ToString(); } catch (Exception ex) { log.Debug("List - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { var xListDateFrom = Session["List_DateFrom"].ToString(); DateTime xx = Convert.ToDateTime(xListDateFrom); ListDateFrom = xx; } catch (Exception ex) { log.Debug("List - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { var ListDateTox = Session["List_DateTo"].ToString(); DateTime xx = Convert.ToDateTime(ListDateTox); ListDateTo = xx; } catch (Exception ex) { log.Debug("List - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { ListStatus = Session["List_Status"].ToString(); } catch (Exception ex) { log.Debug("List - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } RevizeListInput rl = new RevizeListInput(); //Create a list of select list items - this will be returned as your select list List <SelectListItem> newList = new List <SelectListItem> { new SelectListItem() { Value = "0", Text = "Vše" }, new SelectListItem() { Value = "1", Text = "Česká Republika" }, new SelectListItem() { Value = "2", Text = "Polsko" }, new SelectListItem() { Value = "3", Text = "Slovensko a Maďarsko" }, new SelectListItem() { Value = "4", Text = "Ostatní" } }; //Return the list of selectlistitems as a selectlist if (ListRegion != null) { ViewBag.Skupina = new SelectList(newList, "Value", "Text", ListRegion); } else { ViewBag.Skupina = new SelectList(newList, "Value", "Text", null); } if (ListStatus != null) { ViewBag.Status = new SelectList(db.StatusRevize.ToList(), "Id", "NazevStatusuRevize", ListStatus); } else { ViewBag.Status = new SelectList(db.StatusRevize.ToList(), "Id", "NazevStatusuRevize", null); } var x = db.Revize .Include(r => r.Provoz) .Include(r => r.RevizeSC) .Include(r => r.StatusRevize) .Include(r => r.Umisteni); //.Include(r => r.); if (DateFrom != null) { x = x.Where(r => r.DatumRevize >= DateFrom); } else { if (ListDateFrom != null) { x = x.Where(r => r.DatumRevize >= ListDateFrom); } } if (DateTo != null) { x = x.Where(r => r.DatumRevize <= DateTo); } else { if (ListDateTo != null) { x = x.Where(r => r.DatumRevize >= ListDateTo); } } if (Zakaznik != null) { x = x.Where(r => r.Provoz.ZakaznikId == Zakaznik); } if (Status != null) { x = x.Where(r => r.StatusRevizeId == Status); } if (Skupina != null && Skupina != 0) { x = x.Where(r => r.Provoz.Zakaznik.Region.Skupina == Skupina); } var listrevizi = x.ToList(); listrevizi = Revize.LoopRevizeAndUpdateBatery(listrevizi); rl.Revize = listrevizi; if (DateFrom != null) { ViewBag.ListDateFrom = DateFrom; rl.DateFrom = DateFrom; } else { if (ListDateFrom != null) { ViewBag.ListDateFrom = ListDateFrom; rl.DateFrom = ListDateFrom; } } if (DateTo != null) { ViewBag.ListDateTo = DateTo; rl.DateTo = DateTo; } else { if (ListDateTo != null) { ViewBag.ListDateTo = ListDateTo; rl.DateTo = ListDateTo; } } ViewBag.ListStatus = db.StatusRevize.Where(r => r.Id == Status).Select(r => r.NazevStatusuRevize).FirstOrDefault(); if (ListRegion == "0") { ViewBag.Region = "Vše"; } if (ListRegion == "1") { ViewBag.Region = "Česká Republika"; } if (ListRegion == "2") { ViewBag.Region = "Polsko"; } if (ListRegion == "3") { ViewBag.Region = "Slovensko a Maďarsko"; } if (ListRegion == "4") { ViewBag.Region = "Ostatní"; } return(View(rl)); }