public ActionResult ChangeExpert([Bind(Exclude = "OrcaUserName,FirstName,LastName,Email,PhoneNumber", Include = "OrcaUserID,UserType,IsActive,IsAccountDeactivated")] ChangeExpert expToChange) { if (ModelState.IsValid) { OrcaContext db = new OrcaContext(); int oid = expToChange.OrcaUserID; OrcaUser changeUser = db.OrcaUsers.Find(oid); changeUser.UserType = expToChange.UserType; changeUser.IsAccountDeactivated = expToChange.IsAccountDeactivated; db.Entry(changeUser).State = EntityState.Modified; db.SaveChanges(); ExpertConsultant expCon = db.ExpertConsultants.Find(oid); expCon.IsActive = expToChange.IsActive; db.Entry(expCon).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("CurrentExperts")); } return(View()); }
public ActionResult CurrentExperts() { OrcaContext db = new OrcaContext(); List <ChangeExpert> experts = new List <ChangeExpert>(); List <OrcaUser> expertUsers = db.OrcaUsers.Where(x => x.UserType == OrcaUserType.Consultant).ToList(); foreach (OrcaUser exp in expertUsers) { int oid = exp.OrcaUserID; ExpertConsultant expCon = db.ExpertConsultants.Find(oid); ChangeExpert expToChange = new ChangeExpert(); expToChange.OrcaUserID = oid; expToChange.OrcaUserName = exp.OrcaUserName; expToChange.IsActive = expCon.IsActive; expToChange.IsAccountDeactivated = exp.IsAccountDeactivated; expToChange.FirstName = exp.FirstName; expToChange.LastName = exp.LastName; expToChange.Email = exp.Email; expToChange.PhoneNumber = exp.PhoneNumber; experts.Add(expToChange); } return(View(experts)); }
public ActionResult ChangeExpert(int OrcaUserID) { OrcaContext db = new OrcaContext(); OrcaUser exp = db.OrcaUsers.Find(OrcaUserID); ChangeExpert expToChange = new ChangeExpert(); int oid = (int)OrcaUserID; expToChange.OrcaUserID = oid; expToChange.OrcaUserName = exp.OrcaUserName; expToChange.UserType = exp.UserType; string boolStrng = db.ExpertConsultants.Find(oid).IsActive.ToString().ToLower().Trim(); if (boolStrng == "true") { expToChange.IsActive = true; } else { expToChange.IsActive = false; } boolStrng = exp.IsAccountDeactivated.ToString().ToLower().Trim(); if (boolStrng == "true") { expToChange.IsAccountDeactivated = true; } else { expToChange.IsAccountDeactivated = false; } expToChange.FirstName = exp.FirstName; expToChange.LastName = exp.LastName; expToChange.Email = exp.Email; expToChange.PhoneNumber = exp.PhoneNumber; return(View(expToChange)); }