public static bool LoadDepartments()
{
try
{
string connection = ConnectionStr(); bool rst = false;
using (OracleConnection con = new OracleConnection(connection))
{
con.Open();
string sql = "select distinct unit, directorate from amcon_master_all order by unit";
OracleCommand cmd = new OracleCommand(sql);
cmd.Connection = con;
OracleDataReader reader = cmd.ExecuteReader();
List <Department> DeptList = new List <Department>();
if (reader.HasRows)
{
while (reader.Read())
{
Department dp = new Department();
dp.Name = reader["unit"].ToString();
dp.Directorate = reader["directorate"].ToString();
DepartmentBLL.AddDepartment(dp);
rst = true;
//DeptList.Add(dp);
}
}
return(rst);
}
}
catch (Exception ex)
{
throw ex;
}
}
