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