public void UpdateInstructor(InstructorModel model)
{
var instructor = DataContext.Instructors.FirstOrDefault(s => s.InstructorNumber == model.InstructorNumber);
if (instructor != null)
{
instructor.FirstName = model.FirstName;
instructor.LastName = model.LastName;
instructor.Gender = model.Gender.ToString();
instructor.Mobile = model.Mobile;
instructor.Phone = model.Phone;
instructor.Status = model.Status;
instructor.Modified_Date = DateTime.Now;
instructor.Modified_By = model.CreatedUser;
//instructor.Areas = model.AreaIds;
var instructorAddress = DataContext.Addresses.FirstOrDefault(s => s.AddressId == instructor.AddressId);
if (instructorAddress != null)
{
instructorAddress.Address1 = model.AddressLine1;
instructorAddress.AddressLine2 = model.AddressLine2;
instructorAddress.Phone = model.Phone;
instructorAddress.Mobile = model.Mobile;
instructorAddress.PostCode = Convert.ToInt32(model.PostalCode);
instructorAddress.ModifiedDate = DateTime.Now;
instructorAddress.SuburbID = model.SuburbId;
instructorAddress.ModifiedBy = model.CreatedUser;
}
var instructorAreas =
DataContext.InstructorAreas.Where(v => v.InstructorID == instructor.InstructorId).ToList();
SaveInDatabase();
var instructorareas = model.AreaNames.Split(',');
foreach (var area in instructorAreas)
{
if (instructorareas.FirstOrDefault(s => s == area.AreaId.ToString()) == null)
{
DataContext.InstructorAreas.Remove(area);
DataContext.SaveChanges();
}
}
foreach (var area in instructorareas)
{
if (instructorAreas.SingleOrDefault(s => s.AreaId == Convert.ToInt32(area)) == null)
{
DataContext.InstructorAreas.Add(new InstructorArea {AreaId = Convert.ToInt32(area),InstructorID = instructor.InstructorId});
SaveInDatabase();
}
}
}
}
public ActionResult Edit(InstructorModel model)
{
bool status = false;
if (ModelState.IsValid)
{
if (!string.IsNullOrEmpty(model.Password))
{
var user = _userManager.FindByEmail(model.Email);
var provider = Startup.DataProtectionProvider;
_userManager.UserTokenProvider =
new DataProtectorTokenProvider<ApplicationUser>(provider.Create("ASP.NET Identity"))
{
TokenLifespan = TimeSpan.FromHours(1)
};
string code = _userManager.GeneratePasswordResetToken(user.Id);
_userManager.ResetPassword(user.Id, code, model.Password);
}
model.CreatedUser = User.Identity.GetUserId();
string[] addressInfo = model.SuburbName.Split(',');
var suburb = _postalRepo.GetSuburb(addressInfo[0]);
model.PostalCode = addressInfo[2];
if (suburb != null)
{
model.SuburbId = suburb.SuburbId;
}
_instructorRepo.UpdateInstructor(model);
status = true;
}
model = _instructorRepo.GetInstructorModelByNumber(model.InstructorNumber);
model.GendersList = new SelectList(_autogearRepo.GenderListItems(), "Value", "Text");
model.Areas = new SelectList(_instructorRepo.GetAreasList(), "Value", "Text");
model.SaveStatus = status;
return View(model);
}
public InstructorModel GetInstructorModelByNumber(string instructorNumber)
{
var instructor = TblInstructors.FirstOrDefault(s => s.InstructorNumber == instructorNumber);
var model = new InstructorModel();
if (instructor != null)
{
model.InstructorId = instructor.InstructorId;
model.FirstName = instructor.FirstName;
model.LastName = instructor.LastName;
model.InstructorNumber = instructor.InstructorNumber;
model.Email = instructor.Email;
model.Mobile = instructor.Mobile;
model.Phone = instructor.Phone;
model.Status = instructor.Status;
//model.AreaIds = instructor.AreaIds();
model.AreaNames = instructor.AreaIds;
if (!string.IsNullOrEmpty(instructor.Gender))
model.Gender = Convert.ToInt32(instructor.Gender);
var instructorAddress = TblAddresses.FirstOrDefault(s => s.AddressId == instructor.AddressId);
if (instructorAddress != null)
{
model.AddressLine1 = instructorAddress.AddressLine1;
model.AddressLine2 = instructorAddress.AddressLine2;
model.PostalCode = instructorAddress.PostalCode.ToString();
model.SuburbId = instructorAddress.SuburbId;
}
}
return model;
}