private void UpdateLists(string condition)
{
Global.customers.Clear();
Global.games.Clear();
Global.reviews.Clear();
Global.managers.Clear();
Global.publishers.Clear();
Global.designers.Clear();
Global.genres.Clear();
List <object[]> customersRaw = SQL.GetOutput("SELECT * FROM Customer");
List <object[]> gamesRaw = SQL.GetOutput("SELECT * FROM Boardgame");
List <object[]> reviewsRaw = SQL.GetOutput("SELECT * FROM Review");
List <object[]> managersRaw = SQL.GetOutput("SELECT * FROM Manager");
List <object[]> publishersRaw = SQL.GetOutput("SELECT * FROM Publisher");
List <object[]> designersRaw = SQL.GetOutput("SELECT * FROM Designer");
List <object[]> genresRaw = SQL.GetOutput("SELECT * FROM Genre");
foreach (object[] values in customersRaw)
{
Customer.AddFromSql(values);
}
foreach (object[] values in gamesRaw)
{
Game.AddFromSql(values);
}
foreach (object[] values in reviewsRaw)
{
Review.AddFromSql(values);
}
foreach (object[] values in managersRaw)
{
Manager.AddFromSql(values);
}
foreach (object[] values in publishersRaw)
{
Publisher.AddFromSql(values);
}
foreach (object[] values in designersRaw)
{
Designer.AddFromSql(values);
}
foreach (object[] values in genresRaw)
{
Genre.AddFromSql(values);
}
searchedGames.Clear();
foreach (Game game in Global.games)
{
searchedGames.Add(game);
}
if (condition != "")
{
for (int i = 0; i < searchedGames.Count; i++)
{
if (!searchedGames[i].ToString().ToLower().Contains(condition))
{
searchedGames.RemoveAt(i--);
}
}
}
}
private void UpdateLists(string condition)
{
Global.customers.Clear();
Global.games.Clear();
Global.reviews.Clear();
Global.managers.Clear();
Global.publishers.Clear();
Global.designers.Clear();
Global.genres.Clear();
List <object[]> customersRaw = SQL.GetOutput("SELECT * FROM Customer");
List <object[]> gamesRaw = SQL.GetOutput("SELECT * FROM Boardgame");
List <object[]> reviewsRaw = SQL.GetOutput("SELECT * FROM Review");
List <object[]> managersRaw = SQL.GetOutput("SELECT * FROM Manager");
List <object[]> publishersRaw = SQL.GetOutput("SELECT * FROM Publisher");
List <object[]> designersRaw = SQL.GetOutput("SELECT * FROM Designer");
List <object[]> genresRaw = SQL.GetOutput("SELECT * FROM Genre");
foreach (object[] values in customersRaw)
{
Customer.AddFromSql(values);
}
foreach (object[] values in gamesRaw)
{
Game.AddFromSql(values);
}
foreach (object[] values in reviewsRaw)
{
Review.AddFromSql(values);
}
foreach (object[] values in managersRaw)
{
Manager.AddFromSql(values);
}
foreach (object[] values in publishersRaw)
{
Publisher.AddFromSql(values);
}
foreach (object[] values in designersRaw)
{
Designer.AddFromSql(values);
}
foreach (object[] values in genresRaw)
{
Genre.AddFromSql(values);
}
searchedCustomers.Clear();
searchedGames.Clear();
searchedReviews.Clear();
searchedManagers.Clear();
foreach (Customer customer in Global.customers)
{
searchedCustomers.Add(customer);
}
foreach (Game game in Global.games)
{
searchedGames.Add(game);
}
foreach (Review review in Global.reviews)
{
searchedReviews.Add(review);
}
foreach (Manager manager in Global.managers)
{
searchedManagers.Add(manager);
}
if (condition != "")
{
if (ButtonMainAction.Content == CUST_BUTTON_TEXT)
{
for (int i = 0; i < searchedCustomers.Count; i++)
{
if (!searchedCustomers[i].ToString().ToLower().Contains(condition))
{
searchedCustomers.RemoveAt(i--);
}
}
}
else if (ButtonMainAction.Content == GAME_BUTTON_TEXT)
{
for (int i = 0; i < searchedGames.Count; i++)
{
if (!searchedGames[i].ToString().ToLower().Contains(condition))
{
searchedGames.RemoveAt(i--);
}
}
}
else if (ButtonMainAction.Content == REVIEW_BUTTON_TEXT)
{
for (int i = 0; i < searchedReviews.Count; i++)
{
if (!searchedReviews[i].ToString().ToLower().Contains(condition))
{
searchedReviews.RemoveAt(i--);
}
}
}
else
{
for (int i = 0; i < searchedManagers.Count; i++)
{
if (!searchedManagers[i].ToString().ToLower().Contains(condition))
{
searchedManagers.RemoveAt(i--);
}
}
}
}
}
