public ActionResult GetVideoPCSala(int id) { List <Sala> sali = new List <Sala>(_db.Sali.ToList()); List <Curs> _cursuri = new List <Curs>(_db.Cursuri.ToList()); Curs curs = _cursuri.Find(x => x.CursId == id); List <InscriereCursuri> inscrieri = new List <InscriereCursuri>(_db.InscriereCursuri.ToList()); List <SelectListItem> items = new List <SelectListItem>(); var inscrieri_ = inscrieri.GroupBy(x => x) .Where(g => g.Count() > 1) .ToDictionary(x => x.Key, y => y.Count()); if (inscrieri.Count() == 0) { var data = sali .Where(x => x.Libera == true && x.Echipament_Video == true && x.PC == true) .Select(l => new { Value = l.Id.ToString(), Text = l.Nume }); return(Json(data, JsonRequestBehavior.AllowGet)); } else { InscriereCursuri insc = inscrieri.Find(x => x.ClassId == curs.CursId); inscrieri_.TryGetValue(insc, out int number); var data = sali.Where(x => x.Capacitate >= number && x.Libera == true && x.Echipament_Video == true && x.PC == true).Select(l => new { Value = l.Id.ToString(), Text = l.Nume }); return(Json(data, JsonRequestBehavior.AllowGet)); } }
public ActionResult Create([Bind(Exclude = "Id")] InscriereCursuri inscriere) { try { _db.InscriereCursuri.Add(inscriere); _db.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
// GET: InscriereCursuri/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } InscriereCursuri inscriere = _db.InscriereCursuri.Find(id); if (inscriere == null) { return(HttpNotFound()); } return(View(inscriere)); }
public ActionResult Delete(int id) { try { InscriereCursuri inscriere = _db.InscriereCursuri.Find(id); _db.InscriereCursuri.Remove(inscriere); _db.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit(InscriereCursuri inscriere) { try { if (ModelState.IsValid) { _db.Entry(inscriere).State = EntityState.Modified; _db.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View(inscriere)); } }
public ActionResult GetSala(int id) { List <Sala> sali = new List <Sala>(_db.Sali.ToList()); List <Curs> _cursuri = new List <Curs>(_db.Cursuri.ToList()); Curs curs = _cursuri.Find(x => x.CursId == id); List <InscriereCursuri> inscrieri = new List <InscriereCursuri>(_db.InscriereCursuri.ToList()); List <SelectListItem> items = new List <SelectListItem>(); var inscrieri_ = inscrieri.GroupBy(x => x) .Where(g => g.Count() > 1) .ToDictionary(x => x.Key, y => y.Count()); if (inscrieri.Count() == 0) { foreach (Sala sala in sali) { if (sala.Libera == true) { items.Add(new SelectListItem() { Text = sala.Nume, Value = sala.Id.ToString() }); } } } else { InscriereCursuri insc = inscrieri.Find(x => x.ClassId == curs.CursId); inscrieri_.TryGetValue(insc, out int number); List <Sala> saliFiltrate = sali.FindAll(x => x.Capacitate >= number && x.Libera == true); foreach (Sala sala in saliFiltrate) { items.Add(new SelectListItem() { Text = sala.Nume, Value = sala.Id.ToString() }); } } return(Json(items, JsonRequestBehavior.AllowGet)); }