// d)
public Lautsprecher(string Id, string Bennenung, Kanal Kanal, double Lautstaerke)
{
this.Id = Id;
this.Bennenung = Bennenung;
this.Kanal = Kanal;
this.lautstaerke = Lautstaerke;
}
public ActionResult SubsribeConfirmation(int idKan, string Lozinka, bool Evaluation)
{
Kanal kanal = db.Kanals.Find(idKan);
Parametri parametri = db.Parametris.FirstOrDefault <Parametri>();
if (Lozinka != kanal.Lozinka)
{
ModelState.AddModelError(string.Empty, "Pogresna lozinka!");
ViewBag.E = parametri.E;
ViewBag.ChannelName = kanal.Naziv;
return(View());
}
Korisnik korisnik = getKorisnik();
if (Evaluation == true && korisnik.BrTokena < parametri.E)
{
ModelState.AddModelError(string.Empty, "Nedovoljno tokena!");
ViewBag.E = parametri.E;
ViewBag.ChannelName = kanal.Naziv;
return(View());
}
Prati prati = new Prati();
prati.IdKan = idKan;
prati.IdKor = korisnik.IdKor;
prati.Evaluacija = Evaluation;
db.Pratis.Add(prati);
db.SaveChanges();
return(RedirectToAction("ChannelsStudent"));
}
public ActionResult DeleteConfirmed(int id)
{
Kanal kanal = db.Kanals.Find(id);
db.Kanals.Remove(kanal);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "IdKan,IdKor,Naziv,VrOtvaranja,VrZatvaranja,Lozinka,Status,VrOgranicen,IntervalTrajanja")] Kanal kanal)
{
if (ModelState.IsValid)
{
db.Entry(kanal).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IdKor = new SelectList(db.Korisniks, "IdKor", "Ime", kanal.IdKor);
return(View(kanal));
}
public override int GetHashCode()
{
unchecked
{
var hashCode = CountRoom;
hashCode = (hashCode * 397) ^ (Place != null ? Place.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Woter != null ? Woter.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Plita != null ? Plita.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Kanal != null ? Kanal.GetHashCode() : 0);
hashCode = (hashCode * 397) ^ (Otopl != null ? Otopl.GetHashCode() : 0);
return(hashCode);
}
}
public ActionResult PublishList(int id)
{
if (Session["uloga"] == null || Session["uloga"].ToString() != "profesor")
{
return(RedirectToAction("UnauthorizedAccess"));
}
CloseChannels();
Korisnik korisnik = getKorisnik();
var pitanjes = db.Pitanjes.Where(p => p.IdKor == korisnik.IdKor).Where(p => p.Zakljucano == true).Include(p => p.Korisnik);
Kanal channel = db.Kanals.Find(id);
ViewBag.ChannelName = channel.Naziv;
ViewBag.ChannelId = id;
ViewBag.UserId = korisnik.IdKor;
return(View(pitanjes.ToList()));
}
public ActionResult Publish(int id, int?IdPit)
{
Pitanje pitanje = db.Pitanjes.Find(IdPit);
Kanal kanal = db.Kanals.Find(id);
Klon klon = new Klon();
klon.IdPit = pitanje.IdPit;
klon.Naslov = pitanje.Naslov;
klon.Tekst = pitanje.Tekst;
klon.Slika = pitanje.Slika;
klon.ImageToUpload = pitanje.ImageToUpload;
klon.VrPravljenja = pitanje.VrPravljenja;
klon.VrPoslZaklj = pitanje.VrPoslZaklj;
klon.Zakljucano = pitanje.Zakljucano;
klon.IdKan = id;
db.Klons.Add(klon);
db.SaveChanges();
var ponudjeniOdgs = db.PonudjeniOdgs.Where(p => p.IdPit == pitanje.IdPit).ToList();
string stringPonudjeni = "";
foreach (var ponudjeni in ponudjeniOdgs)
{
KlonPonudjeniOdg klonPonudjeni = new KlonPonudjeniOdg();
klonPonudjeni.Sadrzaj = ponudjeni.Sadrzaj;
klonPonudjeni.RedniBr = ponudjeni.RedniBr;
klonPonudjeni.Tacan = ponudjeni.Tacan;
klonPonudjeni.IdKlo = klon.IdKlo;
stringPonudjeni += klonPonudjeni.Sadrzaj + ";";
db.KlonPonudjeniOdgs.Add(klonPonudjeni);
}
db.SaveChanges();
//SignalR
var context = GlobalHost.ConnectionManager.GetHubContext <PushHub>();
context.Clients.Group("Channel " + id).addNewQuestion(klon.Naslov, klon.Tekst, stringPonudjeni, klon.IdKlo, kanal.Naziv);
return(RedirectToAction("PublishList"));
}
// GET: Kanals/Details/5
public ActionResult Details(int?id)
{
if (Session["uloga"] == null || Session["uloga"].ToString() != "profesor")
{
return(RedirectToAction("UnauthorizedAccess"));
}
CloseChannels();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Kanal kanal = db.Kanals.Find(id);
if (kanal == null)
{
return(HttpNotFound());
}
return(View(kanal));
}
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 Create([Bind(Include = "IdKan,Naziv,Lozinka,Status,VrOgranicen,IntervalTrajanja")] Kanal kanal)
{
if (ModelState.IsValid)
{
Korisnik korisnik = getKorisnik();
kanal.VrOtvaranja = DateTime.Now;
kanal.IdKor = korisnik.IdKor;
if (kanal.Status == "Zatvoren")
{
kanal.VrZatvaranja = DateTime.Now;
}
db.Kanals.Add(kanal);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Status = new SelectList(new List <string> {
"Na cekanju", "Otvoren", "Zatvoren"
});
ViewBag.IdKor = new SelectList(db.Korisniks, "IdKor", "Ime", kanal.IdKor);
return(View(kanal));
}
// GET: Kanals/Edit/5
public ActionResult Edit(int?id)
{
if (Session["uloga"] == null || Session["uloga"].ToString() != "profesor")
{
return(RedirectToAction("UnauthorizedAccess"));
}
CloseChannels();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Kanal kanal = db.Kanals.Find(id);
if (kanal == null)
{
return(HttpNotFound());
}
ViewBag.IdKor = new SelectList(db.Korisniks, "IdKor", "Ime", kanal.IdKor);
ViewBag.Status = new SelectList(new List <string> {
"Na cekanju", "Otvoren", "Zatvoren"
}, kanal.Status);
return(View(kanal));
}
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));
}
public static string Serialize(this Kanal kanal)
{
return($"Ilsoc subów : {kanal.IloscSubskrypcji}, Id Kanalu: {kanal.Id}, Ilosc wyswietlen wszyskich filmów: {kanal.LicznikWyswietlen}");
}
public void AddKanal(Kanal kanal)
{
Kanal = kanal;
}
