/// <summary>
/// Populate database
/// </summary>
/// <returns>Task bool: True if success, false otherwise</returns>
public async Task <bool> LoadAsync(int amount)
{
try
{
var subjects = mitComputerScience.Select(s => new Predmet {
Tema = s
});
var rand = new Random(Environment.TickCount);
var studentsResult = from name in names
from surname in surnames
select new Student
{
Ime = name,
Prezime = surname,
Grad = cities[rand.Next(cities.Length)]
};
var students = studentsResult.OrderBy(a => Guid.NewGuid()).Take(amount).Select(s => new Student
{
Ime = s.Ime,
Prezime = s.Prezime,
Grad = s.Grad,
Adresa = "Adresa od " + s.Grad
}).ToList();
db.Predmets.AddRange(subjects);
db.Students.AddRange(students);
foreach (var student in students)
{
foreach (var subject in subjects)
{
var scoreLevel = levels[rand.Next(levels.Length)];
var grade = ((scoreLevel == Level.Bad) ?
rand.Next(5, 7) :
(
(scoreLevel == Level.Good) ?
rand.Next(7, 9) : rand.Next(9, 11)
)
);
var exam = new Ispit {
Predmet = subject, Ocena = grade
};
db.Ispits.Add(exam);
var studentIspit = new StudentIspit {
Student = student, Ispit = exam
};
db.StudentIspits.Add(studentIspit);
}
}
int returnValue = await db.SaveChangesAsync();
return(returnValue > 0);
}
catch (Exception)
{
return(false);
}
}
public IActionResult Dodaj(DodajVM model)
{
var ispit = new Ispit
{
AngazovanId = model.AngazovanId,
Datum = model.Datum,
Zakljucano = false,
Napomena = model.Napomena
};
_context.Add(ispit);
_context.SaveChanges();
var studentiKojiSlusajuPredmet = _context.SlusaPredmet
.Where(s => s.AngazovanId == ispit.AngazovanId)
.ToList();
foreach (var s in studentiKojiSlusajuPredmet)
{
var stavka = new StudentIspit
{
Ispit = ispit,
Ocjena = -1,
PristupioIspitu = false,
SlusaPredmetId = s.Id
};
_context.Add(stavka);
}
_context.SaveChanges();
return(RedirectToAction(nameof(Predmet), new { predmetId = model.AngazovanId }));
}
public ActionResult DeleteConfirmed(int idStudent, int idExam)
{
StudentIspit studentIspit = db.StudentIspits.Find(idStudent, idExam);
db.StudentIspits.Remove(studentIspit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "StudentId,IspitId")] StudentIspit studentIspit)
{
if (ModelState.IsValid)
{
db.Entry(studentIspit).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IspitId = new SelectList(db.Ispits, "BI", "Ime", studentIspit.IspitId);
ViewBag.StudentId = new SelectList(db.Students, "BI", "Ime", studentIspit.StudentId);
return(View(studentIspit));
}
public ActionResult Create([Bind(Include = "StudentId,IspitId")] StudentIspit studentIspit)
{
if (ModelState.IsValid)
{
db.StudentIspits.Add(studentIspit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IspitId = new SelectList(db.Ispits, "BI", "Ime", studentIspit.IspitId);
ViewBag.StudentId = new SelectList(db.Students, "BI", "Ime", studentIspit.StudentId);
return(View(studentIspit));
}
// GET: StudentIspits/Details/5
public ActionResult Details(int?idStudent, int?idExam)
{
if (idStudent == null || idExam == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StudentIspit studentIspit = db.StudentIspits.Find(idStudent, idExam);
if (studentIspit == null)
{
return(HttpNotFound());
}
return(View(studentIspit));
}
// GET: StudentIspits/Edit/5
public ActionResult Edit(int?idStudent, int?idExam)
{
if (idStudent == null || idExam == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StudentIspit studentIspit = db.StudentIspits.Find(idStudent, idExam);
if (studentIspit == null)
{
return(HttpNotFound());
}
ViewBag.IspitId = new SelectList(db.Ispits, "BI", "Ime", studentIspit.IspitId);
ViewBag.StudentId = new SelectList(db.Students, "BI", "Ime", studentIspit.StudentId);
return(View(studentIspit));
}
