/// <summary> /// Populate business object from data reader /// </summary> /// <param name="businessObject">business object</param> /// <param name="dataReader">data reader</param> internal void PopulateBusinessObjectFromReader(TBL_TAIKHOAN_CHUCNANG businessObject, IDataReader dataReader) { if (dataReader.GetSchemaTable().Rows.OfType <DataRow>().Any(row => row["ColumnName"].ToString() == "TaiKhoan_ID")) { int ordinal = dataReader.GetOrdinal(TBL_TAIKHOAN_CHUCNANG.TBL_TAIKHOAN_CHUCNANG_Fields.TaiKhoan_ID.ToString()); if (!dataReader.IsDBNull(ordinal)) { businessObject.TaiKhoan_ID = dataReader.GetInt32(ordinal); } } if (dataReader.GetSchemaTable().Rows.OfType <DataRow>().Any(row => row["ColumnName"].ToString() == "ChucNang_ID")) { int ordinal = dataReader.GetOrdinal(TBL_TAIKHOAN_CHUCNANG.TBL_TAIKHOAN_CHUCNANG_Fields.ChucNang_ID.ToString()); if (!dataReader.IsDBNull(ordinal)) { businessObject.ChucNang_ID = dataReader.GetInt32(ordinal); } } if (dataReader.GetSchemaTable().Rows.OfType <DataRow>().Any(row => row["ColumnName"].ToString() == "ChucNang_Ma")) { int ordinal = dataReader.GetOrdinal(TBL_TAIKHOAN_CHUCNANG.TBL_TAIKHOAN_CHUCNANG_Fields.ChucNang_Ma.ToString()); if (!dataReader.IsDBNull(ordinal)) { businessObject.ChucNang_Ma = dataReader.GetString(ordinal); } } }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of TBCF_EMPLOYEES</returns> internal List <TBL_TAIKHOAN_CHUCNANG> PopulateObjectsFromReader(IDataReader dataReader) { List <TBL_TAIKHOAN_CHUCNANG> list = new List <TBL_TAIKHOAN_CHUCNANG>(); while (dataReader.Read()) { TBL_TAIKHOAN_CHUCNANG businessObject = new TBL_TAIKHOAN_CHUCNANG(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }