public ActionResult Select() { minStaff model = new minStaff(); Dictionary <int, string> EmployeeList = new Dictionary <int, string>(); var connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"]. ConnectionString; string queryString = "SELECT Employee_ID, First_Name, Last_Name " + "FROM dbo.Employee " + "WHERE dbo.Employee.First_Name IS NOT NULL "; using (var connection = new SqlConnection(connectionString)) { var command = new SqlCommand(queryString, connection); connection.Open(); using (var reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { string fullName = (string)reader[1] + " " + (string)reader[2]; EmployeeList.Add((int)reader[0], fullName); } } } connection.Close(); } ViewData["EmployeeList"] = EmployeeList; return(View()); }
// GET: lmSubordinateViewHistory public ActionResult Index() { var connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; string queryString = "Select Employee_ID, First_Name, Last_Name FROM dbo.Employee"; using (var connection = new SqlConnection(connectionString)) { var command = new SqlCommand(queryString, connection); connection.Open(); using (var reader = command.ExecuteReader()) { int iter = 0; while (reader.Read()) { minStaff newEmployee = new minStaff(); newEmployee.empID = (int)reader[0]; newEmployee.empName = (string)reader[1] + " " + (string)reader[2]; staffMembers.Add(newEmployee); iter++; } } } return(View(staffMembers)); }
public ActionResult Select(minStaff empMod) { if (empMod.empIDAsString != null) { TempData["EmpID"] = empMod.empIDAsString; return(RedirectToAction("Index")); } return(Select()); }