public ActionResult Create([Bind(Include = "Id_Level,Stage")] Level level)
{
if (ModelState.IsValid)
{
db.tblLevel.Add(level);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(level));
}
public ActionResult Create([Bind(Include = "DNI,NameStudent,DateInput,DateOutput")] Student student)
{
if (ModelState.IsValid)
{
db.tblStudent.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
public ActionResult Create([Bind(Include = "DNI,NameTeacher")] Teacher teacher)
{
if (ModelState.IsValid)
{
db.tblTeacher.Add(teacher);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(teacher));
}
public ActionResult Create([Bind(Include = "Id_Score,Score1,Score2,Score3")] StudentSubject studentSubject)
{
if (ModelState.IsValid)
{
db.tblScores.Add(studentSubject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(studentSubject));
}
public ActionResult Create([Bind(Include = "Id_Subject,Description,Credits")] Subject subject)
{
if (ModelState.IsValid)
{
db.tblSubject.Add(subject);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(subject));
}
public void SaveTeacherSubject(Teacher teacher)
{
try
{
using (SDBcontext db = new SDBcontext())
{
db.Database.ExecuteSqlCommand("DELETE FROM TeacherSubjects WHERE Teacher_DNI=@id",
new SqlParameter("id", teacher.DNI));
db.SaveChanges();
foreach (var subject in teacher.Subjects)
{
db.Database.ExecuteSqlCommand("INSERT INTO TeacherSubjects VALUES(@dni,@di)",
new SqlParameter("dni", teacher.DNI),
new SqlParameter("di", subject.Id_Subject));
db.SaveChanges();
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
