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