private static QuickQuestion MapQuickQuestion(IDataReader reader)
{
QuickQuestion qq = new QuickQuestion();
int startingIndex = 0;
qq.Id = reader.GetSafeInt32(startingIndex++);
qq.Question = reader.GetSafeString(startingIndex++);
qq.Status = reader.GetSafeInt32(startingIndex++);
qq.DateAdded = reader.GetSafeDateTime(startingIndex++);
qq.DateModified = reader.GetSafeDateTime(startingIndex++);
qq.LanguageCode = reader.GetSafeString(startingIndex++);
qq.CommentCount = reader.GetSafeInt32(startingIndex++);
qq.BeenConverted = reader.GetSafeBool(startingIndex++);
qq.ForumThreadId = reader.GetSafeInt32(startingIndex++);
return qq;
}
public QuickQuestion GetQuestionForNotification(int id, int ownerType)
{
QuickQuestion qq = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.QuickQuestions_SelectByQuestionId"
, inputParamMapper: delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
paramCollection.AddWithValue("@OwnerType", ownerType);
}
, map: delegate(IDataReader reader, short set)
{
qq = new QuickQuestion();
int startingIndex = 0;
qq.Id = reader.GetSafeInt32(startingIndex++);
int secondIndex = 9;
qq.UserId = reader.GetSafeString(secondIndex++);
}
);
return qq;
}