private static ActivityNecessity ActivityNessityMapper(IDataReader reader)
{
ActivityNecessity activity = new ActivityNecessity();
int startingIndex = 0;
activity.Id = reader.GetInt32(startingIndex++);
activity.IsActive = reader.GetSafeBool(startingIndex++);
activity.DateStart = reader.GetSafeDateTime(startingIndex++);
activity.DateEnd = reader.GetSafeDateTime(startingIndex++);
activity.Value = reader.GetSafeString(startingIndex++);
activity.TimeElapsed = reader.GetSafeInt32(startingIndex++);
activity.PointsEarned = reader.GetSafeInt32(startingIndex++);
activity.Notes = reader.GetSafeString(startingIndex++);
activity.PhotoUrl = reader.GetSafeString(startingIndex++);
activity.ActivityTitle = reader.GetSafeString(startingIndex++);
activity.ChallengeName = reader.GetSafeString(startingIndex++);
activity.PetName = reader.GetSafeString(startingIndex++);
activity.PetPhoto = reader.GetSafeString(startingIndex++);
activity.UserName = reader.GetSafeString(startingIndex++);
activity.DogMoodBefore = reader.GetSafeString(startingIndex++);
activity.DogMoodAfter = reader.GetSafeString(startingIndex++);
activity.ActivityTypeId = reader.GetSafeInt32(startingIndex++);
activity.ChallengeId = reader.GetSafeInt32(startingIndex++);
activity.UserId = reader.GetSafeInt32(startingIndex++);
activity.PetId = reader.GetSafeInt32(startingIndex++);
activity.SurveyId = reader.GetSafeInt32(startingIndex++);
return(activity);
}
public Paged <ActivityNecessity> GetNecessityPage(int pageIndex, int pageSize)
{
List <ActivityNecessity> list = null;
int totalCount = 0;
String procName = "[dbo].[ActivityEntries_GetNecessityPage]";
_dataProvider.ExecuteCmd(procName
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@PageIndex", pageIndex);
paramCollection.AddWithValue("@PageSize", pageSize);
}
, singleRecordMapper : delegate(IDataReader reader, short set)
{
ActivityNecessity activity = ActivityNessityMapper(reader);
if (totalCount == 0)
{
totalCount = reader.GetInt32(21);
}
if (list == null)
{
list = new List <ActivityNecessity>();
}
list.Add(activity);
}
);
Paged <ActivityNecessity> page = null;
if (list != null)
{
page = new Paged <ActivityNecessity>(list, pageIndex, pageSize, totalCount);
}
return(page);
}
public List <ActivityNecessity> GetNecessity()
{
List <ActivityNecessity> list = null;
string procName = "[dbo].[ActivityEntries_GetAllNecessities]";
_dataProvider.ExecuteCmd(procName
, inputParamMapper : delegate(SqlParameterCollection parameterCollection)
{
}
, singleRecordMapper : delegate(IDataReader reader, short set)
{
ActivityNecessity activity = ActivityNessityMapper(reader);
if (list == null)
{
list = new List <ActivityNecessity>();
}
list.Add(activity);
}
);
return(list);
}
