/// <summary>
/// Returns a <see cref="ApplicationUserList"/> object of the specified criteria.
/// </summary>
/// <param name="applicationUserID">No additional detail available.</param>
/// <returns>A <see cref="ApplicationUserList"/> object of the specified criteria.</returns>
public static ApplicationUserList GetByApplicationUserID(System.Int32 applicationUserID)
{
var criteria = new ApplicationUserCriteria {
ApplicationUserID = applicationUserID
};
return(new ApplicationUserList().DataPortal_Fetch(criteria));
}
private ApplicationUserList DataPortal_Fetch(ApplicationUserCriteria criteria)
{
bool cancel = false;
OnFetching(criteria, ref cancel);
if (cancel)
{
return(null);
}
//RaiseListChangedEvents = false;
// Fetch Child objects.
using (var connection = new SqlConnection(ADOHelper.ConnectionString))
{
connection.Open();
using (var command = new SqlCommand("[dbo].[spCFM_ApplicationUser_Select]", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddRange(ADOHelper.SqlParameters(criteria.StateBag));
command.Parameters.AddWithValue("@p_LastNameHasValue", criteria.LastNameHasValue);
command.Parameters.AddWithValue("@p_EmailAddressHasValue", criteria.EmailAddressHasValue);
command.Parameters.AddWithValue("@p_MobilePhoneHasValue", criteria.MobilePhoneHasValue);
command.Parameters.AddWithValue("@p_WorkPhoneHasValue", criteria.WorkPhoneHasValue);
command.Parameters.AddWithValue("@p_EmployeeNumberHasValue", criteria.EmployeeNumberHasValue);
command.Parameters.AddWithValue("@p_PasswordResetTokenHasValue", criteria.PasswordResetTokenHasValue);
command.Parameters.AddWithValue("@p_PasswordResetTokenExpiryHasValue", criteria.PasswordResetTokenExpiryHasValue);
command.Parameters.AddWithValue("@p_ApplicationRoleIDHasValue", criteria.ApplicationRoleIDHasValue);
command.Parameters.AddWithValue("@p_LastLoggedOnHasValue", criteria.LastLoggedOnHasValue);
command.Parameters.AddWithValue("@p_StatementDeliveryOptionIDHasValue", criteria.StatementDeliveryOptionIDHasValue);
command.Parameters.AddWithValue("@p_PhysicalAddressIDHasValue", criteria.PhysicalAddressIDHasValue);
command.Parameters.AddWithValue("@p_PostalAddressIDHasValue", criteria.PostalAddressIDHasValue);
command.Parameters.AddWithValue("@p_LastActiveCheckSentOnHasValue", criteria.LastActiveCheckSentOnHasValue);
command.Parameters.AddWithValue("@p_CreatedByHasValue", criteria.CreatedByHasValue);
command.Parameters.AddWithValue("@p_UpdatedByHasValue", criteria.UpdatedByHasValue);
command.Parameters.AddWithValue("@p_UpdatedOnHasValue", criteria.UpdatedOnHasValue);
command.Parameters.AddWithValue("@p_LastPasswordChangedOnHasValue", criteria.LastPasswordChangedOnHasValue);
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
var rowParser = reader.GetRowParser <CFMData.ApplicationUser>();
do
{
this.Add(CFMData.ApplicationUser.GetApplicationUser(rowParser, reader));
}while(reader.Read());
}
OnFetched();
return(this);
}
}
}
//RaiseListChangedEvents = true;
}
/// <summary>
/// Returns a <see cref="ApplicationUserList"/> object of the specified criteria.
/// </summary>
/// <param name="postalAddressID">No additional detail available.</param>
/// <returns>A <see cref="ApplicationUserList"/> object of the specified criteria.</returns>
public static ApplicationUserList GetByPostalAddressID(System.Int32?postalAddressID)
{
var criteria = new ApplicationUserCriteria {
};
if (postalAddressID.HasValue)
{
criteria.PostalAddressID = postalAddressID.Value;
}
return(new ApplicationUserList().DataPortal_Fetch(criteria));
}
/// <summary>
/// Returns a <see cref="ApplicationUserList"/> object of the specified criteria.
/// </summary>
/// <param name="statementDeliveryOptionID">No additional detail available.</param>
/// <returns>A <see cref="ApplicationUserList"/> object of the specified criteria.</returns>
public static ApplicationUserList GetByStatementDeliveryOptionID(System.Int32?statementDeliveryOptionID)
{
var criteria = new ApplicationUserCriteria {
};
if (statementDeliveryOptionID.HasValue)
{
criteria.StatementDeliveryOptionID = statementDeliveryOptionID.Value;
}
return(new ApplicationUserList().DataPortal_Fetch(criteria));
}
/// <summary>
/// Returns a <see cref="ApplicationUserList"/> object of the specified criteria.
/// </summary>
/// <param name="updatedBy">No additional detail available.</param>
/// <returns>A <see cref="ApplicationUserList"/> object of the specified criteria.</returns>
public static ApplicationUserList GetByUpdatedBy(System.Int32?updatedBy)
{
var criteria = new ApplicationUserCriteria {
};
if (updatedBy.HasValue)
{
criteria.UpdatedBy = updatedBy.Value;
}
return(new ApplicationUserList().DataPortal_Fetch(criteria));
}
/// <summary>
/// Returns a <see cref="ApplicationUserList"/> object of the specified criteria.
/// </summary>
/// <param name="applicationRoleID">No additional detail available.</param>
/// <returns>A <see cref="ApplicationUserList"/> object of the specified criteria.</returns>
public static ApplicationUserList GetByApplicationRoleID(System.Int32?applicationRoleID)
{
var criteria = new ApplicationUserCriteria {
};
if (applicationRoleID.HasValue)
{
criteria.ApplicationRoleID = applicationRoleID.Value;
}
return(new ApplicationUserList().DataPortal_Fetch(criteria));
}
/// <summary> /// CodeSmith generated stub method that is called when fetching the child <see cref="ApplicationUser"/> object. /// </summary> /// <param name="criteria"><see cref="ApplicationUserCriteria"/> object containing the criteria of the object to fetch.</param> /// <param name="cancel">Value returned from the method indicating whether the object fetching should proceed.</param> partial void OnFetching(ApplicationUserCriteria criteria, ref bool cancel);
public static ApplicationUserList GetByCriteria(ApplicationUserCriteria criteria)
{
return(new ApplicationUserList().DataPortal_Fetch(criteria));
// return DataPortal.Fetch<ApplicationUserList>(criteria);
}
