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)); }