public List<SubArea> GetEmployeeAreas(string adLoginID)
{
List<SubArea> subAreas = new List<SubArea>();
List<System.Data.SqlClient.SqlParameter> parameters = new List<System.Data.SqlClient.SqlParameter>();
string storedProcedure = "selEmployeeAreas";
FinalBuild.DataAccess ado = new FinalBuild.DataAccess(System.Configuration.ConfigurationManager.ConnectionStrings["PersonnelContext"].ConnectionString);
parameters.Add(new System.Data.SqlClient.SqlParameter("@ADLoginID", adLoginID));
System.Data.DataTable dtResults = ado.GetDataTable(storedProcedure, "EmployeeAreas", parameters.ToArray());
for (int index = 0; index < dtResults.Rows.Count; index++)
{
subAreas.Add(new SubArea { ID = (int)dtResults.Rows[index]["SubAreaID"],
PrimaryAreaID = (int)dtResults.Rows[index]["PrimaryAreaID"],
Name = dtResults.Rows[index]["AreaName"].ToString()
});
}
return subAreas;
}
