public List <PollTableModel> Search(PollQueryModel query)
{
var result = new List <PollTableModel>();
using (var command = Context.Connection.GenerateCommand(
"ais.search_questionnaire",
new
{
languageid = query.LanguageId,
statusid = query.Status,
}))
{
using (var reader = command.ExecuteReaderSafety())
{
while (reader.Read())
{
result.Add(
new PollTableModel
{
Id = reader.GetFieldValue <Guid?>("id"),
Title = reader.GetFieldValue <string>("title"),
Description = reader.GetFieldValue <string>("description"),
Status = new Nomenclature
{
Id = reader.GetFieldValue <Guid>("statusid"),
Name = reader.GetFieldValue <string>("statusname")
},
ValidFrom = reader.GetFieldValue <DateTime?>("validfrom"),
ValidTo = reader.GetFieldValue <DateTime?>("validto"),
RegDate = reader.GetFieldValue <DateTime?>("regdate"),
Author = reader.GetFieldValue <string>("regusername")
});
}
}
}
return(result);
}
public List <PollTableModel> Search(PollQueryModel query)
{
query.LanguageId = RequestData.LanguageId;
return(pollRepository.Search(query));
}
