public AnonUserUrls SelectUrlsByIdAndEmail(AnonUserChangeRequest model)
{
AnonUserUrls singleItem = null;
DataProvider.ExecuteCmd("AnonUrl_SelectByIdAndEmail"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Email", model.Email);
paramCollection.AddWithValue("@Url", model.Website);
}
, singleRecordMapper : delegate(IDataReader reader, short set)
{
singleItem = new AnonUserUrls();
int startingIndex = 0; //startingOrdinal
singleItem.Url = reader.GetSafeString(startingIndex++);
});
return(singleItem);
}
public List <AnonUserUrls> SelectUrlsByUser(AnonUserChangeRequest model)
{
List <AnonUserUrls> list = new List <AnonUserUrls>();
DataProvider.ExecuteCmd("dbo.AnonUrl_SelectByUser"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Email", model.Email);
}
, singleRecordMapper : delegate(IDataReader reader, short set)
{
AnonUserUrls singleItem = new AnonUserUrls();
int startingIndex = 0; //startingOrdinal
singleItem.Id = reader.GetSafeInt32(startingIndex++);
singleItem.IdOfEmail = reader.GetSafeInt32(startingIndex++);
singleItem.Url = reader.GetSafeString(startingIndex++);
singleItem.TimesGraded = reader.GetSafeInt32(startingIndex++);
singleItem.DateCreated = reader.GetSafeDateTime(startingIndex++);
singleItem.DateModified = reader.GetSafeDateTime(startingIndex++);
list.Add(singleItem);
});
return(list);
}
