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