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());
}
