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