public ActionResult Update(int id) { MedicalStaffDirectory selectedmember = db.MedicalStaffDirectories.SqlQuery("Select * from MedicalStaffDirectories where MedicalStaffDirectoryId=@id", new SqlParameter("@id", id)).FirstOrDefault(); List <Department> Departments = db.Departments.SqlQuery("Select * from Departments").ToList(); List <ApplicationUser> Users = db.Users.ToList(); AddUpdateMedicalStaffDirectory AddMedicalStaffDirectory = new AddUpdateMedicalStaffDirectory(); AddMedicalStaffDirectory.MedicalStaffDirectory = selectedmember; AddMedicalStaffDirectory.Departments = Departments; AddMedicalStaffDirectory.Users = Users; return(View(AddMedicalStaffDirectory)); }
public ActionResult Add() { List <Department> Departments = db.Departments.SqlQuery("Select * from Departments").ToList(); List <ApplicationUser> Users = db.Users.ToList(); //Debug.WriteLine(users); AddUpdateMedicalStaffDirectory AddMedicalStaffDirectory = new AddUpdateMedicalStaffDirectory(); AddMedicalStaffDirectory.Departments = Departments; AddMedicalStaffDirectory.Users = Users; return(View(AddMedicalStaffDirectory)); }