public string[] GetAllUserInPurchaseHistory()
{
LinkedList <string> users = new LinkedList <string>();
using (var dbReader = dbConnection.SelectFromTable("PurchaseHistory", "UserName"))
{
while (dbReader.Read())
{
users.AddLast(dbReader.GetString(0));
}
}
return(users.ToArray());
}
public SqlDataReader SelectFromTable(string table, string toSelect)
{
try
{
return(realMarketDB.SelectFromTable(table, toSelect));
}
catch (InvalidOperationException e)
{
if (!IsConnected(e.Message) || MarketDB.ToDisable)
{
throw new DataException();
}
throw;
}
catch (SqlException e)
{
if (!IsConnected(e.Message) || MarketDB.ToDisable)
{
throw new DataException();
}
throw;
}
}
public string[] GetAllStoresIDs()
{
LinkedList <string> ids = new LinkedList <string>();
using (var dbReader = dbConnection.SelectFromTable("Store", "SystemID"))
{
while (dbReader.Read())
{
ids.AddLast(dbReader.GetString(0));
}
}
return(ids.ToArray());
}
public int[] GetAllSystemIDs()
{
var ids = new List <int>();
using (var dbReader = dbConnection.SelectFromTable("Users", "SystemID"))
{
while (dbReader.Read())
{
if (dbReader.GetValue(0) != null)
{
ids.Add(dbReader.GetInt32(0));
}
}
}
return(ids.ToArray());
}
public List <Order> GetAllOrders()
{
List <Order> orders = new List <Order>();
using (var dbReader = dbConnection.SelectFromTable("Orders", "*"))
{
while (dbReader.Read())
{
if (dbReader.GetValue(0) != null)
{
orders.Add(new Order(dbReader.GetInt32(0), dbReader.GetString(1), dbReader.GetString(2), dbReader.GetDouble(3)
, dbReader.GetString(4), GetAllItems(dbReader.GetInt32(0))));
}
}
}
return(orders);
}
