/// <summary> /// Loads a <see cref="UserList"/> collection from the database, based on given criteria. /// </summary> /// <param name="crit">The fetch criteria.</param> protected void DataPortal_Fetch(FilteredCriteria crit) { using (var ctx = ConnectionManager <SqlConnection> .GetManager(Database.DocStoreConnection, false)) { using (var cmd = new SqlCommand("GetUserList", ctx.Connection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", crit.Name == null ? (object)DBNull.Value : crit.Name).DbType = DbType.String; cmd.Parameters.AddWithValue("@Login", crit.Login == null ? (object)DBNull.Value : crit.Login).DbType = DbType.String; cmd.Parameters.AddWithValue("@Email", crit.Email == null ? (object)DBNull.Value : crit.Email).DbType = DbType.String; cmd.Parameters.AddWithValue("@IsActive", crit.IsActive == null ? (object)DBNull.Value : crit.IsActive.Value).DbType = DbType.Boolean; var args = new DataPortalHookArgs(cmd, crit); OnFetchPre(args); LoadCollection(cmd); OnFetchPost(args); } } }
/// <summary> /// Loads a <see cref="FolderList"/> collection from the database, based on given criteria. /// </summary> /// <param name="crit">The fetch criteria.</param> protected void DataPortal_Fetch(FilteredCriteria crit) { using (var ctx = ConnectionManager <SqlConnection> .GetManager(Database.DocStoreConnection, false)) { using (var cmd = new SqlCommand("GetFolderList", ctx.Connection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@FolderTypeID", crit.FolderTypeID == null ? (object)DBNull.Value : crit.FolderTypeID.Value).DbType = DbType.Int32; cmd.Parameters.AddWithValue("@FolderRef", crit.FolderRef == null ? (object)DBNull.Value : crit.FolderRef).DbType = DbType.String; cmd.Parameters.AddWithValue("@Year", crit.Year == null ? (object)DBNull.Value : crit.Year.Value).DbType = DbType.Int32; cmd.Parameters.AddWithValue("@Subject", crit.Subject == null ? (object)DBNull.Value : crit.Subject).DbType = DbType.String; cmd.Parameters.AddWithValue("@FolderStatusID", crit.FolderStatusID == null ? (object)DBNull.Value : crit.FolderStatusID.Value).DbType = DbType.Int32; cmd.Parameters.AddWithValue("@CreateDate", crit.CreateDate == null ? (object)DBNull.Value : crit.CreateDate.DBValue).DbType = DbType.DateTime2; cmd.Parameters.AddWithValue("@CreateUserID", crit.CreateUserID == null ? (object)DBNull.Value : crit.CreateUserID.Value).DbType = DbType.Int32; cmd.Parameters.AddWithValue("@ChangeDate", crit.ChangeDate == null ? (object)DBNull.Value : crit.ChangeDate.DBValue).DbType = DbType.DateTime2; cmd.Parameters.AddWithValue("@ChangeUserID", crit.ChangeUserID == null ? (object)DBNull.Value : crit.ChangeUserID.Value).DbType = DbType.Int32; var args = new DataPortalHookArgs(cmd, crit); OnFetchPre(args); LoadCollection(cmd); OnFetchPost(args); } } }