private List<SubArea> GetSubAreas()
{
List<SubArea> subAreas = new List<SubArea>();
System.Data.DataSet dsAreas = null;
FinalBuild.DataAccess objADO = new FinalBuild.DataAccess(Database.Connection.ConnectionString);
string storedProcedure = "selAreaInformation";
dsAreas = objADO.GetDataSet(storedProcedure, null);
return subAreas;
}
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;
}
public bool RemoveEmployeeArea(string adLoginID, int subAreaID)
{
List<System.Data.SqlClient.SqlParameter> parameters = new List<System.Data.SqlClient.SqlParameter>();
string storedProcedure = "delEmployeeArea";
int rowsAffected = 0;
FinalBuild.DataAccess ado = new FinalBuild.DataAccess(System.Configuration.ConfigurationManager.ConnectionStrings["PersonnelContext"].ConnectionString);
parameters.Add(new System.Data.SqlClient.SqlParameter("@ADLoginID", adLoginID));
parameters.Add(new System.Data.SqlClient.SqlParameter("@SubAreaID", subAreaID));
rowsAffected = ado.ExecuteSQL(storedProcedure, parameters.ToArray());
return (rowsAffected > 0);
}
private System.Data.DataSet GetReportData(string storedProcedure)
{
System.Data.DataSet dsData = null;
FinalBuild.DataAccess objADO = new FinalBuild.DataAccess();
dsData = objADO.GetDataSet(storedProcedure, null);
return dsData;
}
