public ActionResult Index(string pretraga, int?page, string sortBy)
{
StudentDBHandle dbhandle = new StudentDBHandle();
IspitDBHandle ispitH = new IspitDBHandle();
ModelState.Clear();
ViewBag.datum_rodjenja = String.IsNullOrEmpty(sortBy) ? "datum_rodjenja desc" : "";
var studenti = (dbhandle.VratiStudente().ToPagedList(page ?? 1, 5));
if (!string.IsNullOrEmpty(pretraga))
{
studenti = dbhandle.VratiStudente().Where(x => x.Ime_i_prezime.StartsWith(pretraga, StringComparison.InvariantCultureIgnoreCase)).ToPagedList(page ?? 1, 5);
}
switch (sortBy)
{
case "datum_rodjenja desc":
//studenti = dbhandle.VratiStudente().GroupBy(s => s.grupa_id).Select(s => s.OrderBy(x => x.datum_rodjenja).FirstOrDefault()).ToPagedList(page ?? 1, 5);
studenti = dbhandle.VratiStudente().OrderBy(x => x.datum_rodjenja).ToPagedList(page ?? 1, 5);
break;
}
return(View(studenti));
}
public ActionResult Edit(int bi, Student student)
{
try
{
StudentDBHandle sdb = new StudentDBHandle();
sdb.UpdateStudenta(student);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
// 4. ************* Brisanje studenta ******************
// GET: Student/Delete/5
public ActionResult Delete(int bi)
{
try
{
StudentDBHandle sdb = new StudentDBHandle();
if (sdb.BrisanjeStudenta(bi))
{
ViewBag.AlertMsg = "Uspesno obrisan student.";
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(Student student)
{
try
{
if (ModelState.IsValid)
{
StudentDBHandle sdb = new StudentDBHandle();
if (sdb.DodajStudenta(student))
{
ViewBag.Message = "Uspesno ste dodali studenta.";
ModelState.Clear();
}
}
return(View());
}
catch
{
return(View());
}
}
// 3. ************* Izmeni studenta ******************
// GET: Student/Edit/5
public ActionResult Edit(int bi)
{
StudentDBHandle sdb = new StudentDBHandle();
return(View(sdb.VratiStudente().Find(student => student.bi == bi)));
}