private void QueriesToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem toolStripMenuItem = sender as ToolStripMenuItem;
            string            queryString       = null;

            /* check menu item and call report page*/
            if (toolStripMenuItem == confirmedQueriesToolStripMenuItem)
            {
                queryString = "SELECT * FROM queries where querycurrentstate > " + Properties.Resources.queryStageRejected + " ORDER BY queryno";
            }
            else if (toolStripMenuItem == notConfirmedQueriesToolStripMenuItem)
            {
                queryString = "SELECT * FROM queries where querycurrentstate <= " + Properties.Resources.queryStageRejected + " ORDER BY queryno";
            }
            else
            {
                MessageBox.Show("Error in menu");
                return;
            }
            Close_Opened_Form();
            reportsViewerPage             = new FrmReportsViewerPage(queryString);
            reportsViewerPage.WindowState = FormWindowState.Maximized;
            reportsViewerPage.MdiParent   = this;
            reportsViewerPage.Show();
        }
Beispiel #2
0
        private void BtnHotelReport_Click(object sender, EventArgs e)
        {
            FrmReportsViewerPage reportsViewerPage = null;
            string queryString = "SELECT " +
                                 "`T1`.hotelarea AS `AREA`, " +
                                 "`T1`.hotelcity AS `CITY`, " +
                                 "`T1`.hotelrating AS `RATING`, " +
                                 "`T1`.hotelname AS `HOTEL`, " +
                                 "`T2`.roomtype AS `ROOM TYPE`, " +
                                 "`T2`.seasontype AS `SEASON`, " +
                                 "`T2`.mealepaipricesingle AS `EPAI SNGL`, " +
                                 "`T2`.mealepaipricedouble AS `EPAI DBL`, " +
                                 "`T2`.mealepaipriceextbed AS `EPAI TRPL`, " +
                                 "`T2`.mealcpaipricesingle AS `CPAI SNGL`, " +
                                 "`T2`.mealcpaipricedouble AS `CPAI DBL`, " +
                                 "`T2`.mealcpaipriceextbed AS `CPAI TRPL`, " +
                                 "`T2`.mealmapaipricesingle AS `MAPAI SNGL`, " +
                                 "`T2`.mealmapaipricedouble AS `MAPAI DBL`, " +
                                 "`T2`.mealmapaipriceextbed AS `MAPAI TRPL`, " +
                                 "`T2`.mealapaipricesingle AS `APAI SNGL`, " +
                                 "`T2`.mealapaipricedouble AS `APAI DBL`, " +
                                 "`T2`.mealapaipriceextbed AS `APAI TRPL` " +
                                 "FROM `hotelinfo` AS `T1` INNER JOIN `hotelrates` AS `T2` ON `T1`.`idhotelinfo` = `T2`.`idhotelinfo` " +
                                 "WHERE `seasonyear` > 0 " +
                                 "ORDER BY `AREA`, `CITY`, `RATING`, `HOTEL`";

            reportsViewerPage = new FrmReportsViewerPage(queryString);
            Hide();
            reportsViewerPage.WindowState = FormWindowState.Maximized;
            reportsViewerPage.ShowDialog();
            Show();
        }
        private void All_ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem toolStripMenuItem = sender as ToolStripMenuItem;
            string            queryString       = null;

            /* check menu item and call report page*/
            if (toolStripMenuItem == allLedgerToolStripMenuItem)
            {
                queryString = "SELECT * FROM ledger ORDER BY idledger";
            }
            else if (toolStripMenuItem == allAgentsToolStripMenuItem)
            {
                queryString = "SELECT * FROM agents ORDER BY agentid";
            }
            else if (toolStripMenuItem == allUsersToolStripMenuItem)
            {
                queryString = "SELECT * FROM appusers ORDER BY userid";
            }
            else if (toolStripMenuItem == allQueriesToolStripMenuItem)
            {
                queryString = "SELECT * FROM queries ORDER BY queryno";
            }
            else if (toolStripMenuItem == allHotelsToolStripMenuItem)
            {
                queryString = "SELECT " +
                              "`T1`.hotelarea AS `AREA`, " +
                              "`T1`.hotelcity AS `CITY`, " +
                              "`T1`.hotelrating AS `RATING`, " +
                              "`T1`.hotelname AS `HOTEL`, " +
                              "`T2`.roomtype AS `ROOM TYPE`, " +
                              "`T2`.seasontype AS `SEASON`, " +
                              "`T2`.mealepaipricesingle AS `EPAI SNGL`, " +
                              "`T2`.mealepaipricedouble AS `EPAI DBL`, " +
                              "`T2`.mealepaipriceextbed AS `EPAI TRPL`, " +
                              "`T2`.mealcpaipricesingle AS `CPAI SNGL`, " +
                              "`T2`.mealcpaipricedouble AS `CPAI DBL`, " +
                              "`T2`.mealcpaipriceextbed AS `CPAI TRPL`, " +
                              "`T2`.mealmapaipricesingle AS `MAPAI SNGL`, " +
                              "`T2`.mealmapaipricedouble AS `MAPAI DBL`, " +
                              "`T2`.mealmapaipriceextbed AS `MAPAI TRPL`, " +
                              "`T2`.mealapaipricesingle AS `APAI SNGL`, " +
                              "`T2`.mealapaipricedouble AS `APAI DBL`, " +
                              "`T2`.mealapaipriceextbed AS `APAI TRPL` " +
                              "FROM `hotelinfo` AS `T1` INNER JOIN `hotelrates` AS `T2` ON `T1`.`idhotelinfo` = `T2`.`idhotelinfo` " +
                              "WHERE `seasonyear` > 0 " +
                              "ORDER BY `AREA`, `CITY`, `RATING`, `HOTEL`";
            }
            else
            {
                MessageBox.Show("Error in menu");
                return;
            }
            Close_Opened_Form();
            reportsViewerPage             = new FrmReportsViewerPage(queryString);
            reportsViewerPage.WindowState = FormWindowState.Maximized;
            reportsViewerPage.MdiParent   = this;
            reportsViewerPage.Show();
        }
        private void LedgerToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem toolStripMenuItem = sender as ToolStripMenuItem;
            string            queryString       = null;

            /* check menu item and call report page*/
            if (toolStripMenuItem == perQueriesLedgerToolStripMenuItem)
            {
                queryString = "select `T2`.queryid AS `QUERYID`, `T1`.totalcost as `TRIP COST`, SUM(`T2`.transactionamount) AS `AMOUNT DEPOSITED` from " +
                              "`finalizedqueries` as `T1` right join " +
                              "`ledger` as `T2` on " +
                              "`T1`.`queryid` = `T2`.`queryid` " +
                              "group by `T2`.`queryid`";
            }
            else if (toolStripMenuItem == pendingPaymentsLedgerToolStripMenuItem)
            {
                queryString = "select queryid as `QUERYID`, tripcost as `TRIP COST`, deposited as `AMOUNT DEPOSITED` from " +
                              "(select `T2`.queryid as queryid, " +
                              "`T1`.totalcost as tripcost, " +
                              "SUM(`T2`.transactionamount) as deposited " +
                              "from `finalizedqueries` as `T1` " +
                              "right join `ledger` as `T2` " +
                              "on `T1`.`queryid` = `T2`.`queryid` " +
                              "group by `T2`.`queryid`) as tablejoined " +
                              "where tripcost is not null and tripcost >" +
                              " deposited";
            }
            else if (toolStripMenuItem == advancePaymentsLedgerToolStripMenuItem)
            {
                queryString = "select queryid as `QUERYID`, tripcost as `TRIP COST`, deposited as `AMOUNT DEPOSITED` from " +
                              "(select `T2`.queryid as queryid, " +
                              "`T1`.totalcost as tripcost, " +
                              "SUM(`T2`.transactionamount) as deposited " +
                              "from `finalizedqueries` as `T1` " +
                              "right join `ledger` as `T2` " +
                              "on `T1`.`queryid` = `T2`.`queryid` " +
                              "group by `T2`.`queryid`) as tablejoined " +
                              "where tripcost is null or tripcost < deposited";
            }
            else if (toolStripMenuItem == completedPaymentsLedgerToolStripMenuItem)
            {
                queryString = "select queryid as `QUERYID`, tripcost as `TRIP COST`, deposited as `AMOUNT DEPOSITED` from " +
                              "(select `T2`.queryid as queryid, " +
                              "`T1`.totalcost as tripcost, " +
                              "SUM(`T2`.transactionamount) as deposited " +
                              "from `finalizedqueries` as `T1` " +
                              "right join `ledger` as `T2` " +
                              "on `T1`.`queryid` = `T2`.`queryid` " +
                              "group by `T2`.`queryid`) as tablejoined " +
                              "where tripcost is not null and tripcost = deposited";
            }
            else
            {
                MessageBox.Show("Error in menu");
                return;
            }
            Close_Opened_Form();
            reportsViewerPage             = new FrmReportsViewerPage(queryString);
            reportsViewerPage.WindowState = FormWindowState.Maximized;
            reportsViewerPage.MdiParent   = this;
            reportsViewerPage.Show();
        }