/// <summary>
/// Method to Get List of Departments
/// </summary>
/// <param name="argEn">Department Entity as an Inputs.</param>
/// <returns>Returns List of Department</returns>
public List <DepartmentEn> GetDepartmentList(DepartmentEn argEn)
{
//declaration
List <DepartmentEn> depEnList = new List <DepartmentEn>();
string SqlStatement = null;
try
{
// Build Sql Statement
SqlStatement = "SELECT * FROM SAS_Department";
if (!FormHelp.IsBlank(SqlStatement))
{
using (IDataReader _IDataReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, SqlStatement).CreateDataReader())
{
while (_IDataReader.Read())
{
DepartmentEn _DepartmentEn = LoadObject(_IDataReader);
depEnList.Add(_DepartmentEn);
}
_IDataReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
//return data set
return(depEnList);
}
private DepartmentEn LoadObject(IDataReader argReader)
{
DepartmentEn _DepartmentEn = new DepartmentEn();
_DepartmentEn.AutoID = GetValue <int>(argReader, "AutoId");
_DepartmentEn.DepartmentID = GetValue <string>(argReader, "DepartmentID");
_DepartmentEn.Department = GetValue <string>(argReader, "Department");
_DepartmentEn.Status = GetValue <bool>(argReader, "Status");
_DepartmentEn.CreatedBy = GetValue <string>(argReader, "CreatedBy");
_DepartmentEn.CreateDate = GetValue <DateTime>(argReader, "CreateDate");
_DepartmentEn.ModifiedBy = GetValue <string>(argReader, "ModifiedBy");
_DepartmentEn.ModifiedDate = GetValue <DateTime>(argReader, "ModifiedDate");
return(_DepartmentEn);
}
