// chiama la stored procedure InsertStudentGrade
public int InsertStudentGrade(VotoStudente vs)
{
using (var context = new SchoolEntities()) {
var sg = MySingleton.GetAutoMapperInstance().Map <StudentGrade>(vs);
context.StudentGrades.Add(sg);
context.SaveChanges();
return(sg.EnrollmentID);
}
}
public ActionResult Cancella()
{
var repo = new StudentGradeRepository();
var vs = new VotoStudente();
vs.IdStudente = 3;
vs.IdCorso = 3;
repo.DeleteStudentGrade(vs);
return(RedirectToAction("Visualizza"));
}
public ActionResult Modifica(EditGradeViewModel vm)
{
var repo = new StudentGradeRepository();
var vs = new VotoStudente();
vs.IdStudente = vm.IdStudente;
vs.IdCorso = vm.IdCorso;
vs.Voto = vm.Voto;
repo.EditStudentGrade(vs);
return(RedirectToAction("Visualizza"));
}
public ActionResult Modifica(int id)
{
var repo = new StudentGradeRepository();
var vs = new VotoStudente();
vs = repo.GetVotoStudenteForEdit(id);
var vmedit = new EditGradeViewModel();
vmedit = MySingleton.GetAutoMapperInstance().Map <EditGradeViewModel>(vs);
return(View(vmedit));
}
// chiama la stored procedure DeleteStudentGrade
public void DeleteStudentGrade(VotoStudente vs)
{
using (var context = new SchoolEntities()) {
StudentGrade studentGrade = new StudentGrade();
var sg = MySingleton.GetAutoMapperInstance().Map <StudentGrade>(vs);
// per cancellare un'entità dobbiamo prima "materializzarla" nel contesto EF
var studentGradeToDelete = context.StudentGrades.Where(x => x.CourseID == sg.CourseID && x.StudentID == sg.StudentID).FirstOrDefault();
if (studentGradeToDelete != null)
{
context.StudentGrades.Remove(studentGradeToDelete);
}
context.SaveChanges();
}
}
