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