public IHttpActionResult Search(string tagName)
{
_tagsManager = TagsManagerFactory.Create();
try
{
var parameters = new TagsSearchParameters()
{
TagName = tagName
};
var result = _tagsManager.Search(parameters);
return(Ok(result.Payload));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public TResponse <List <Tags> > Search(TagsSearchParameters parameters)
{
var response = new TResponse <List <Tags> >()
{
Payload = Repo.Search(parameters).ToList()
};
if (!response.Payload.Any())
{
response.Success = false;
response.Message = "Query could not find any results";
}
else
{
response.Success = true;
}
return(response);
}
public List <Tags> Search(TagsSearchParameters parameters)
{
List <Tags> tags = new List <Tags>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
string query = "SELECT TOP 20 TagId, TagName FROM Tags ";
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
if (!string.IsNullOrEmpty(parameters.TagName))
{
query += "WHERE TagName LIKE @TagName ";
cmd.Parameters.AddWithValue("@TagName", parameters.TagName + '%');
}
query += "ORDER BY TagName ASC";
cmd.CommandText = query;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Tags row = new Tags();
row.TagId = (int)dr["TagId"];
row.TagName = dr["TagName"].ToString();
tags.Add(row);
}
}
}
return(tags);
}
public List <Tags> Search(TagsSearchParameters parameters)
{
return(tags);
}
