public List <FaqIndexModel> Get()
{
List <FaqIndexModel> list = new List <FaqIndexModel>();
this.DataProvider.ExecuteCmd("dbo.Faq_GetAllJoined"
, inputParamMapper : null
, singleRecordMapper : delegate(IDataReader reader, short set)
{
FaqIndexModel singleItem = MapperFaqIndexModel(reader);
list.Add(singleItem);
});
return(list);
}
private FaqIndexModel MapperFaqIndexModel(IDataReader reader)
{
FaqIndexModel singleItem = new FaqIndexModel();
int startingIndex = 0; //startingOrdinal
singleItem.Id = reader.GetSafeInt32(startingIndex++);
singleItem.Title = reader.GetSafeString(startingIndex++);
singleItem.Description = reader.GetSafeString(startingIndex++);
singleItem.displayOrder = reader.GetSafeInt32(startingIndex++);
singleItem.displayName = reader.GetSafeString(startingIndex++);
singleItem.CreatedDate = reader.GetSafeDateTime(startingIndex++);
singleItem.ModifiedDate = reader.GetSafeDateTime(startingIndex++);
singleItem.ModifiedBy = reader.GetSafeString(startingIndex++);
return(singleItem);
}
public IActionResult Index()
{
var faq = _faqService.GetAll().Select(f => new FaqDetailModel
{
Id = f.Id,
Question = f.Question,
Answer = f.Answer
});
FaqIndexModel model = new FaqIndexModel()
{
Faqs = faq
};
return(View(model));
}
