public List <EmployeeDirectory> GetEmployeesView(string lastname)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["mwd"].ConnectionString);
SqlCommand cmd = new SqlCommand("spEmployeeDirectoryViewDetail", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parameterLName = new SqlParameter("@LName", SqlDbType.VarChar, 50);
parameterLName.Value = lastname;
cmd.Parameters.Add(parameterLName);
List <EmployeeDirectory> employees = new List <EmployeeDirectory>();
try
{
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
EmployeeDirectory ed = new EmployeeDirectory();
ed.name = rdr["Name"].ToString();
ed.guid = new Guid(rdr["Guid"].ToString());
employees.Add(ed);
}
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
cmd.Dispose();
conn.Close();
}
return(employees);
}
