Exemple #1
0
        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;
        }
Exemple #2
0
        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);
 }