public List <RegisterInviteDomainModel> SelectAllP(int pageNumber, int rowsToDisplay)
{
List <RegisterInviteDomainModel> result = new List <RegisterInviteDomainModel>();
this._dataProvider.ExecuteCmd(
"RegisterInvite_SelectByPage",
inputParamMapper : delegate(SqlParameterCollection paramList)
{
SqlParameter param = new SqlParameter
{
ParameterName = "@Id",
SqlDbType = SqlDbType.Int,
Direction = ParameterDirection.Output
};
paramList.AddWithValue("@PageNumber", pageNumber);
paramList.AddWithValue("@rowsToDisplay", rowsToDisplay);
},
singleRecordMapper : delegate(IDataReader reader, short set)
{
RegisterInviteDomainModel model = new RegisterInviteDomainModel();
int index = 0;
model = MapRegisterInvite(reader, index);
index++;
result.Add(model);
});
return(result);
}
public static RegisterInviteDomainModel MapRegisterInvite(IDataReader reader, int index)
{
RegisterInviteDomainModel model = new RegisterInviteDomainModel();
model.Id = reader.GetSafeInt32(index++);
model.FirstName = reader.GetSafeString(index++);
model.MiddleInitial = reader.GetSafeString(index++);
model.LastName = reader.GetSafeString(index++);
model.Email = reader.GetSafeString(index++);
model.Token = reader.GetSafeString(index++);
model.Expiration = reader.GetSafeDateTime(index++);
model.CreatedDate = reader.GetSafeDateTime(index++);
model.ModifiedDate = reader.GetSafeDateTime(index++);
model.ModifiedBy = reader.GetSafeString(index++);
return(model);
}
public List <RegisterInviteDomainModel> SelectAll()
{
List <RegisterInviteDomainModel> result = new List <RegisterInviteDomainModel>();
this._dataProvider.ExecuteCmd(
"RegisterInvite_SelectAll",
inputParamMapper : null,
singleRecordMapper : delegate(IDataReader reader, short set)
{
RegisterInviteDomainModel model = new RegisterInviteDomainModel();
int index = 0;
model = MapRegisterInvite(reader, index);
index++;
result.Add(model);
});
return(result);
}
public RegisterInviteDomainModel SelectByEmail(string email)
{
RegisterInviteDomainModel model = new RegisterInviteDomainModel();
this._dataProvider.ExecuteCmd(
"RegisterInvite_Role",
inputParamMapper : delegate(SqlParameterCollection paramList)
{
paramList.AddWithValue("@Email", email);
},
singleRecordMapper : delegate(IDataReader reader, short set)
{
int index = 0;
model = MapRoleRegisterInvite(reader, index);
});
return(model);
}