public InstructorEdit GetInstructorByName(string name)
{
var model = new InstructorEdit();
using (var ctx = new ApplicationDbContext())
{
var entity = _context.Instructors.FirstOrDefault(i => i.FullName == name);
model.FullName = entity.FullName;
model.ProgramId = entity.ProgramId;
model.AcademyId = entity.AcademyId;
}
return(model);
}
public bool UpdateInstructor(InstructorEdit model)
{
using (var ctx = new ApplicationDbContext())
{
var entity =
ctx.Instructors
.Single(e => e.InstructorID == model.InstructorID);
entity.InstructorName = model.InstructorName;
entity.LocationID = model.LocationID;
return(ctx.SaveChanges() > 0);
}
}
public bool UpdateInstructor(InstructorEdit model)
{
using (var ctx = new ApplicationDbContext())
{
var entity = ctx.Instructors.Single(p => p.FullName == model.FullName);
var academyId = ctx.Academies.Single(a => a.Name == model.AcademyName).AcademyId;
var programId = ctx.Programs.Single(a => a.Name == model.ProgramName).ProgramId;
entity.FullName = model.FullName;
entity.ProgramId = academyId;
entity.AcademyId = programId;
return(ctx.SaveChanges() == 1);
}
}
public InstructorEdit GetInstructorById(int id)
{
var model = new InstructorEdit();
using (var ctx = new ApplicationDbContext())
{
var entity = ctx.Instructors.FirstOrDefault(a => a.InstructorId == id);
model.InstructorId = id;
model.FullName = entity.FullName;
model.ProgramId = entity.ProgramId;
model.ProgramName = entity.ProgramName;
model.AcademyId = entity.AcademyId;
model.AcademyName = entity.AcademyName;
}
return(model);
}
public IHttpActionResult UpdateInstructor([FromBody] InstructorEdit model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var svc = new InstructorService();
if (!svc.UpdateInstructor(model))
{
return(InternalServerError());
}
return(Ok("Instructor successfully updated."));
}
public ActionResult EditIntructor(InstructorEdit model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
var service = GetBrowsingService();
if (service.UpdateInstructor(model))
{
return(RedirectToAction("Index"));
}
ModelState.AddModelError("", "Instructor couldn't be updated.");
return(View(model));
}
public ActionResult Edit(int id)
{
var service = GetInstructorService();
var model = service.GetInstructorById(id);
//int academyId = model.AcademyId;
//int programId = model.ProgramId;
//string academyName = service.GetAcademyNameById(academyId);
//string programName = service.GetProgramNameById(programId);
var newModel = new InstructorEdit();
{
newModel.InstructorId = model.InstructorId;
newModel.FullName = model.FullName;
newModel.ProgramId = model.ProgramId;
newModel.ProgramName = model.ProgramName;
newModel.AcademyId = model.AcademyId;
newModel.AcademyName = model.AcademyName;
};
return(View(model));
}