public TableSelectControl(string[] tableNames)
{
InitializeComponent();
_tableSelectionCollection = new ObservableCollection <IsSelectedByTable>();
foreach (string tableName in tableNames)
{
IsSelectedByTable isSelectedByTable = new IsSelectedByTable()
{
TableName = tableName,
};
isSelectedByTable.OnSelectedChanged += IsSelectedByTable_OnSelectedChanged;
_tableSelectionCollection.Add(isSelectedByTable);
}
selectTableDataGrid.ItemsSource = _tableSelectionCollection;
}
private void SelectTableTabItem_OnShowTableChanged(object sender, IsSelectedByTable e)
{
string tableName = e.TableName;
if (e.IsSelected == true)
{
string[] tableNames = DatabaseOperations.GetTableNames();
TabItem tabItem = null;
if (tableNames.Contains(tableName))
{
tabItem = new TableTabItem(tableName, $"select * from {tableName}");
}
else if (tableName == CustomTableNames.InventoryGroupsJoin)
{
tabItem = new TableTabItem(CustomTableNames.InventoryGroupsJoin, DatabaseOperations.InventorySelectSql);
}
else if (tableName == CustomTableNames.InventoryGroupsJoin)
{
tabItem = new TableTabItem(CustomTableNames.InventoryGroupsJoin, DatabaseOperations.InventorySelectSql);
}
else if (tableName == CustomTableNames.Constraints)
{
tabItem = new TableTabItem(CustomTableNames.Constraints, "SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS");
}
else if (tableName == CustomTableNames.QuestionaireJoin)
{
string columnsToSelect = new string[]
{
$"{TableNames.QuestionaireAnswers}.id as QuestionaireId",
ColumnNames.FavoritePlacesToHangOutAroundTown,
ColumnNames.HowLikelyAreYouToRentAWeirdBike,
ColumnNames.WhyWouldYouOrWouldntYouBeInterested,
ColumnNames.AreOurPricesWithinYourBudget,
ColumnNames.WhatDoYouDislikeAboutOurWebsite,
ColumnNames.DeliverOrPickup,
ColumnNames.WhereWouldYouLikeToRide,
ColumnNames.HowManyHoursWouldYouLikeTheBike,
ColumnNames.EmailAddress,
ColumnNames.HowManyTimesAYearEmail,
"Name as BikeName",
"age0to1",
"age2to5",
"age6to10",
"age11to15",
"age16to20",
"age21to35",
"age36to50",
"ageover51"
}.Aggregate((i, j) => $"{i},{j}");
//columnsToSelect = "*";
string joinQuestionaireAnswersSql =
$"SELECT {columnsToSelect} FROM {TableNames.QuestionaireAnswers} left outer join { TableNames.QuestionaireBikePreferenceSelection} on " +
$"{ TableNames.QuestionaireBikePreferenceSelection}.{ColumnNames.QuestionaireId} = " +
$"{ TableNames.QuestionaireBikePreferenceSelection}.{ColumnNames.QuestionaireId}" +
$" inner join { TableNames.Bikes} b on b.id = { TableNames.QuestionaireBikePreferenceSelection}.bikeid " +
" left outer join " +
$"{TableNames.QuestionaireAgeSelection} a on {TableNames.QuestionaireAnswers}.{ColumnNames.Id}" +
$"= a.{ColumnNames.QuestionaireId} ";
tabItem = new TableTabItem(CustomTableNames.QuestionaireJoin, joinQuestionaireAnswersSql);
}
else if (tableName == CustomTableNames.AddOrUpdateBikePrices)
{
UpdateBikePriceTabItem addOrUpdateBikePriceTabItem
= new UpdateBikePriceTabItem();
addOrUpdateBikePriceTabItem.BikePriceUpdated += UpdateData;
tabItem = addOrUpdateBikePriceTabItem;
}
else if (tableName == CustomTableNames.UpdateInventory)
{
UpdateInventory updateInventoryPriceTabItem
= new UpdateInventory();
tabItem = updateInventoryPriceTabItem;
}
else if (tableName == CustomTableNames.AppointmentsJoin)
{
string joinQuestionaireAnswersSql =
$"SELECT bb.appointmentid, b.name, a.dayPart, a.date, a.dropofflocation, a.email, a.phone, a.name FROM {TableNames.Appointments} a inner join " +
$"{TableNames.Bikebookings} bb on a.{ColumnNames.Id} = bb.appointmentid" +
$" inner join {TableNames.Bikes} b on b.id = bb.bikeid order by bb.appointmentid";
tabItem = new TableTabItem(CustomTableNames.AppointmentsJoin, joinQuestionaireAnswersSql);
}
else if (tableName == CustomTableNames.RemoveQuestionaire)
{
tabItem = new RemoveQuestionaireResultTableItem();
}
mainWindowTabControl.Items.Add(tabItem);
}
else
{
TabItem item = mainWindowTabControl.Items.Cast <TabItem>().Single(tab => tab.Header.ToString() == e.TableName);
mainWindowTabControl.Items.Remove(item);
}
}
private void TableSelectControl_OnShowTableChanged(object sender, IsSelectedByTable e)
{
OnShowTableChanged(this, e);
}