public IActionResult Index(Programi_po_KanaluViewModel?model) { ISession session = SessionManager.GetSession(); List <Kanal> kanali = new List <Kanal>(); if (session == null) { return(View()); } var data = session.Execute("SELECT * FROM \"Kanal\""); foreach (var ch in data) { Kanal kanal = new Kanal(); kanal.kanalId = ch["kanalId"] != null ? ch["kanalId"].ToString() : string.Empty; kanal.naziv = ch["naziv"] != null ? ch["naziv"].ToString() : string.Empty; kanali.Add(kanal); } model.Kanali = kanali; Programi_po_KanaluViewModel viewModel = new Programi_po_KanaluViewModel() { Kanali = kanali }; List <string> datumi = new List <string>(); DateTime startOfWeek = DateTime.Today.AddDays(-1 * (int)(DateTime.Today.DayOfWeek) + 1); datumi.Add(startOfWeek.Date.ToShortDateString()); while (datumi.Count < 7) { startOfWeek = startOfWeek.AddDays(1); datumi.Add(startOfWeek.Date.ToShortDateString()); } model.Datumi = datumi; return(View(model)); }
public ActionResult SearchByChannel(Programi_po_KanaluViewModel model) { ISession session = SessionManager.GetSession(); List <Programme> programi = new List <Programme>(); if (session == null) { return(View()); } //var data = session.Execute("SELECT * FROM \"Programi_po_Kanalu\" WHERE \"kanalId\" = '" + model.KanalId + "' AND datum = '" + // model.Datum + "'"); var data = session.Execute("SELECT * FROM \"Programi_po_Kanalu\" WHERE \"kanalId\" = '" + model.KanalId + "' AND datum = '" + model.Datum + "' ORDER BY vreme"); foreach (var prog in data) { Programme program = new Programme(); program.kanalId = prog["kanalId"] != null ? prog["kanalId"].ToString() : string.Empty; program.datum = prog["datum"] != null ? prog["datum"].ToString() : string.Empty; program.vreme = prog["vreme"] != null ? prog["vreme"].ToString() : string.Empty; program.naziv = prog["naziv"] != null ? prog["naziv"].ToString() : string.Empty; program.opis = prog["opis"] != null ? prog["opis"].ToString() : string.Empty; program.tip = prog["tip"] != null ? prog["tip"].ToString() : string.Empty; programi.Add(program); } model.Programi = programi; List <Kanal> kanali = new List <Kanal>(); if (session == null) { return(View()); } var kanalData = session.Execute("SELECT * FROM \"Kanal\""); foreach (var ch in kanalData) { Kanal kanal = new Kanal(); kanal.kanalId = ch["kanalId"] != null ? ch["kanalId"].ToString() : string.Empty; kanal.naziv = ch["naziv"] != null ? ch["naziv"].ToString() : string.Empty; kanali.Add(kanal); } model.Kanali = kanali; List <string> datumi = new List <string>(); DateTime startOfWeek = DateTime.Today.AddDays(-1 * (int)(DateTime.Today.DayOfWeek) + 1); datumi.Add(startOfWeek.Date.ToShortDateString()); while (datumi.Count < 7) { startOfWeek = startOfWeek.AddDays(1); datumi.Add(startOfWeek.Date.ToShortDateString()); } model.Datumi = datumi; return(View("Index", model)); }