public static List <Common.Models.Matters.MatterTag> Search(
string text,
IDbConnection conn = null,
bool closeConnection = true)
{
List <Common.Models.Matters.MatterTag> list = new List <Common.Models.Matters.MatterTag>();
List <DBOs.Matters.MatterTag> dbo = null;
conn = DataHelper.OpenIfNeeded(conn);
dbo = conn.Query <DBOs.Matters.MatterTag>(
"SELECT * FROM \"matter_tag\" WHERE LOWER(\"tag\") LIKE '%' || @Query || '%'",
new { Query = text }).ToList();
dbo.ForEach(x =>
{
Common.Models.Matters.MatterTag mt = Mapper.Map <Common.Models.Matters.MatterTag>(x);
mt.TagCategory = Tagging.TagCategory.Get(mt.TagCategory.Id, conn, closeConnection);
mt.Matter = Matter.Get(mt.Matter.Id.Value, conn, closeConnection);
list.Add(mt);
});
DataHelper.Close(conn, closeConnection);
return(list);
}
public static List <Common.Models.Matters.MatterTag> Search(string text)
{
List <Common.Models.Matters.MatterTag> list = new List <Common.Models.Matters.MatterTag>();
List <DBOs.Matters.MatterTag> dbo = null;
using (IDbConnection conn = Database.Instance.GetConnection())
{
dbo = conn.Query <DBOs.Matters.MatterTag>(
"SELECT * FROM \"matter_tag\" WHERE LOWER(\"tag\") LIKE '%' || @Query || '%'",
new { Query = text }).ToList();
}
dbo.ForEach(x =>
{
Common.Models.Matters.MatterTag mt = Mapper.Map <Common.Models.Matters.MatterTag>(x);
mt.TagCategory = Tagging.TagCategory.Get(mt.TagCategory.Id);
mt.Matter = Matter.Get(mt.Matter.Id.Value);
list.Add(mt);
});
return(list);
}
