public static void SetInstance(string ConnectionString)
{
if (Instance == null)
{
Instance = new TagAssocRepo(ConnectionString);
}
}
private IEnumerable <ItemModel> ItemCondition(string condition)
{
if (!String.IsNullOrEmpty(condition) && !condition.Equals("*"))
{
condition = " where " + condition;
}
else
{
condition = "";
}
Console.WriteLine("Select * from dbo.Items" + condition);
List <ItemModel> MyList = new List <ItemModel>();
ItemModel curr;
sqlConnection.Open();
var arg = "Select * from dbo.Items" + condition;
using (var command = new SqlCommand(arg, sqlConnection))
{
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
curr = new ItemModel();
curr.ID = reader["ID"] as string;
curr.Name = reader["Name"] as string;
curr.Description = reader["Description"] as string;
string owner = reader["OwnerId"] as string;
curr.OwnerId = TraderRepo.GetInstance().GetById(owner);
string price = reader["Price"] + "";
curr.Price = Int32.Parse(price);
curr.Photo = reader["Photo"] as byte[];
curr.Tags = TagAssocRepo.GetInstance().ItemTags(curr.ID);
MyList.Add(curr);
}
}
}
sqlConnection.Close();
return(MyList);
}