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));
}
