list model DAL

   public List<sys_User> GetUserList(int pageIndex, int pageSize, ref int recordCount)
        {
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetStoredProcCommand("dbo.[GetUserList]");
            db.AddInParameter(dbCommand, "@PageIndex", DbType.Int32, pageIndex);
            db.AddInParameter(dbCommand, "@PageSize", DbType.Int32, pageSize);
            db.AddOutParameter(dbCommand, "@RecordCount", DbType.Int32, recordCount);
            List<sys_User> list = new List<sys_User>();
            using (IDataReader dataReader = db.ExecuteReader(dbCommand))
            {
                while (dataReader.Read())
                {
                    list.Add(ReaderBind(dataReader));
                }
            }
            recordCount = (int)dbCommand.Parameters["@RecordCount"].Value;
            return list;
        }

 private sys_User ReaderBind(IDataReader dataReader)
        {
            sys_User u = new sys_User();
            u.UserID = Convert.ToInt32(dataReader["UserID"]);
            u.UserName = dataReader["UserName"].ToString();
            u.LoginName = dataReader["LoginName"].ToString();
            u.Gender = Convert.ToInt32(dataReader["Gender"]);
            u.MobelTel = dataReader["MobelTel"].ToString();
            u.InterTel = dataReader["InterTel"].ToString();
            u.OfficeTel = dataReader["OfficeTel"].ToString();
            u.EmailAddress = dataReader["EmailAddress"].ToString();
            object ojb;
            ojb = dataReader["SoldToUser"];
            if (ojb != null && ojb != DBNull.Value)
            {
                u.IsSoldToUser = Convert.ToBoolean(ojb);
            }
            u.CustomerCode = dataReader["CustomerCode"].ToString();
            u.ReceiverCode = dataReader["ReceiverCode"].ToString();
            return u;
        }

*****************************************************************************

      

  public List<sys_User> GetUserListByRoleAllocation(int roleID)
        {
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetStoredProcCommand("dbo.[GetUserListByRoleAllocation]");
            db.AddInParameter(dbCommand, "@RoleID", DbType.Int32, roleID);
            List<sys_User> list = new List<sys_User>();
            using (IDataReader dataReader = db.ExecuteReader(dbCommand))
            {
                while (dataReader.Read())
                {
                    sys_User u = new sys_User();
                    u.UserID = Convert.ToInt32(dataReader["UserID"]);
                    u.UserName = dataReader["UserName"].ToString();
                    list.Add(u);
                }
            }
            return list;
        }

********************************************************************************

        public DataTable GetOrderProductList(int orderID)
        {
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetStoredProcCommand("dbo.[GetOrderProductList]");
            db.AddInParameter(dbCommand, "@OrderID", DbType.Int32, orderID);
            DataSet ds = db.ExecuteDataSet(dbCommand);
            DataTable dt = ds.Tables[0];
            return dt;
        }