public List <TagModel> ItemTags(string ItemId)
{
if (!String.IsNullOrEmpty(ItemId) && !ItemId.Equals("*"))
{
ItemId = " where Item_ID = \'" + ItemId + "\'";
}
else
{
ItemId = "";
}
Console.WriteLine("Select * from dbo.TagAssoc" + ItemId);
List <TagModel> MyList = new List <TagModel>();
TagModel curr;
sqlConnection.Open();
var arg = "Select * from dbo.TagAssoc" + ItemId;
using (var command = new SqlCommand(arg, sqlConnection))
{
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
string itemid = reader["Tag_ID"] as string;
curr = TagRepo.GetInstance().GetById(itemid);
MyList.Add(curr);
}
}
}
sqlConnection.Close();
return(MyList);
}
public static void SetInstance(string ConnectionString)
{
if (Instance == null)
{
Instance = new TagRepo(ConnectionString);
}
}
