public IEnumerable <Provider> Search(ProviderQueryModel query)
{
var result = new List <Provider>();
var lang = query.LanguageId.ToString();
using (var command = Context.Connection.GenerateCommand(
"ais.search_supplier",
new
{
supplierstatusid = query.StatusId,
languageid = query.LanguageId,
id = query.Id
}))
{
using (var reader = command.ExecuteReaderSafety())
{
while (reader.Read())
{
result.Add(
new Provider
{
Id = reader.GetFieldValue <Guid?>("id"),
Status = new Nomenclature
{
Id = reader.GetFieldValue <Guid>("supplierstatusid"),
Name = reader.GetFieldValue <string>("supplierstatusname")
},
Names = new SortedDictionary <string, string>
{
{
lang, reader.GetFieldValue <string>("name")
}
},
Descriptions = new SortedDictionary <string, string>
{
{
lang, reader.GetFieldValue <string>("description")
}
},
Links = new SortedDictionary <string, string>
{
{
lang, reader.GetFieldValue <string>("link")
}
},
MainPicture = new Attachment
{
Url = reader.GetFieldValue <string>("picurl")
},
LanguageId = query.LanguageId
});
}
}
}
return(result);
}
public IEnumerable <Provider> Search(ProviderQueryModel query)
{
query.LanguageId = RequestData.LanguageId;
return(providerRepository.Search(query));
}
