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