public void save(int ida, int ids) { StudentAcademy e = new StudentAcademy { AcademyId = ida, StudentId = ids }; StudentOrganiserDbContext ctxx = new StudentOrganiserDbContext(); ctxx.StudentAcademies.Add(e); // ctxx.SaveChanges(); try { ctxx.SaveChanges(); } catch (DbUpdateException dbu) { var exception = HandleDbUpdateException(dbu); throw exception; } }
public ActionResult Create(StudentCreate model) { if (ModelState.IsValid) { Student entity = new Student { FirstName = model.FirstName, LastName = model.LastName, Email = model.Email, PhoneNumber = model.PhoneNumber, Birthday = model.Birthday, Faculty = model.Faculty, FacultyStart = model.FacultyStart, Gender = model.Gender }; StudentOrganiserDbContext ctxx = new StudentOrganiserDbContext(); ctxx.Students.Add(entity); ctxx.SaveChanges(); save(model.academy, entity.StudentId); return(RedirectToAction("Index")); } return(View()); }
public ActionResult DeleteS(int id) { using (StudentOrganiserDbContext ctx = new StudentOrganiserDbContext()) { Student st = ctx.Students.Single(a => a.StudentId == id); ctx.Students.Remove(st); ctx.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult Edit(Student model) { StudentOrganiserDbContext ctx = new StudentOrganiserDbContext(); Student s = ctx.Students.Single(x => x.StudentId == model.StudentId); s.FirstName = model.FirstName; s.LastName = model.LastName; s.Birthday = model.Birthday; s.Email = model.Email; s.Faculty = model.Faculty; s.FacultyStart = model.FacultyStart; s.PhoneNumber = model.PhoneNumber; s.Gender = model.Gender; if (ModelState.IsValid) { ctx.SaveChanges(); return(RedirectToAction("Index")); } return(View()); }