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 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 Add(int id)
{
using (StudentOrganiserDbContext ctx = new StudentOrganiserDbContext())
{
List <Academy> academies = ctx.Academies.ToList();
return(View(academies));
}
}
public ActionResult Details(int id)
{
using (StudentOrganiserDbContext ctx = new StudentOrganiserDbContext())
{
Student st = ctx.Students.Single(a => a.StudentId == id);
return(View(st));
}
}
public ActionResult Index()
{
using (StudentOrganiserDbContext ctx = new StudentOrganiserDbContext())
{
var students = ctx.Students.ToList();
return(View(students));
}
}
public ActionResult Create()
{
using (StudentOrganiserDbContext ctx = new StudentOrganiserDbContext())
{
List <Academy> academies = ctx.Academies.ToList();
ViewBag.Academies = academies;
}
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(int id)
{
using (StudentOrganiserDbContext ctx = new StudentOrganiserDbContext())
{
var student = ctx.Students.Where(s => s.StudentId == id).ToList();
Student st = student[0];
return(View(st));
}
//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());
}
