private void DataGrdVuUserQueries_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { if (DataGrdVuUserQueries.Rows.Count > 0) { /* Open new Form of Working and pass queryId to the working */ /* MessageBox.Show("Data Row selected : \n" + * DataGrdVuUserQueries.SelectedRows[0].Cells["AssignedDate"].Value.ToString() + "\n" + * DataGrdVuUserQueries.SelectedRows[0].Cells["QueryId"].Value.ToString() + "\n" + * DataGrdVuUserQueries.SelectedRows[0].Cells["Location"].Value.ToString() + "\n" + * DataGrdVuUserQueries.SelectedRows[0].Cells["fromDate"].Value.ToString() + "\n" + * DataGrdVuUserQueries.SelectedRows[0].Cells["toDate"].Value.ToString() + "\n" );*/ if (openWorkingPage) { FrmQueryWorkingPage frmQueryWorkingPage = new FrmQueryWorkingPage(DataGrdVuUserQueries.SelectedRows[0].Cells["QueryId"].Value.ToString()); Hide(); frmQueryWorkingPage.ShowDialog(); Show(); } } else { MessageBox.Show("Please load Queries First", "Load Queries", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void DataGrdVuUserQueries_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { if (DataGrdVuUserQueries.Rows.Count > 0) { /* Open new Form of Working and pass queryId to the working */ try { Debug.WriteLine("Data Row selected For Working Itinerary: \n" + DataGrdVuUserQueries.SelectedRows[0].Cells["AssignedDate"].Value.ToString() + "\n" + DataGrdVuUserQueries.SelectedRows[0].Cells["QueryId"].Value.ToString() + "\n" + DataGrdVuUserQueries.SelectedRows[0].Cells["Location"].Value.ToString() + "\n" + DataGrdVuUserQueries.SelectedRows[0].Cells["fromDate"].Value.ToString() + "\n" + DataGrdVuUserQueries.SelectedRows[0].Cells["toDate"].Value.ToString() + "\n"); } catch (Exception errSelection) { Debug.WriteLine("Error in selecting rows. Err Msg = " + errSelection.Message); return; } if (radioButtonWorkingItinary.Checked) { FrmQueryWorkingPage frmQueryWorkingPage = new FrmQueryWorkingPage(DataGrdVuUserQueries.SelectedRows[0].Cells["QueryId"].Value.ToString()); Hide(); frmQueryWorkingPage.ShowDialog(); Show(); } else if (radioButtonWorkingVouchers.Checked) //else if (radioButtonCompletedItinerary.Checked)/* this line needs to be deleted after testing */ { FrmVouchersWorkingOptionPage frmVouchersWorkingOptionPage = new FrmVouchersWorkingOptionPage(DataGrdVuUserQueries.SelectedRows[0].Cells["QueryId"].Value.ToString()); Hide(); frmVouchersWorkingOptionPage.ShowDialog(); Show(); } else { Debug.WriteLine("Usefull radio button not selected. thus not doing anything\n"); } DataGrdVuUserQueriesLoad(); } else { MessageBox.Show("Please load Queries First", "Load Queries", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void DataGrdVuAdminQueries_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (DataGrdVuAdminQueries.Rows.Count > 0) { /* Open new Form of Working and pass queryId to the working */ if (openVoucherPage) { MessageBox.Show("Generating VOUCHERS FOR : \n" + DataGrdVuAdminQueries.SelectedRows[0].Cells["AssignedDate"].Value.ToString() + "\n" + DataGrdVuAdminQueries.SelectedRows[0].Cells["QueryId"].Value.ToString() + "\n" + DataGrdVuAdminQueries.SelectedRows[0].Cells["Location"].Value.ToString() + "\n" + DataGrdVuAdminQueries.SelectedRows[0].Cells["fromDate"].Value.ToString() + "\n" + DataGrdVuAdminQueries.SelectedRows[0].Cells["toDate"].Value.ToString() + "\n"); FrmQueryWorkingPage frmQueryWorkingPage = new FrmQueryWorkingPage(DataGrdVuAdminQueries.SelectedRows[0].Cells["QueryId"].Value.ToString()); Hide(); frmQueryWorkingPage.ShowDialog(); Show(); } else { //MessageBox.Show("Generating ITINERARY FOR : \n" + //DataGrdVuAdminQueries.SelectedRows[0].Cells["AssignedDate"].Value.ToString() + "\n" + //DataGrdVuAdminQueries.SelectedRows[0].Cells["QueryId"].Value.ToString() + "\n" + //DataGrdVuAdminQueries.SelectedRows[0].Cells["Location"].Value.ToString() + "\n" + //DataGrdVuAdminQueries.SelectedRows[0].Cells["fromDate"].Value.ToString() + "\n" + //DataGrdVuAdminQueries.SelectedRows[0].Cells["toDate"].Value.ToString() + "\n"); if (saveFileDialogItinerary.ShowDialog() == DialogResult.OK) { /* file selected */ Debug.WriteLine("OUT FILE SELECTED : " + saveFileDialogItinerary.FileName); } else { Debug.WriteLine("File not selected thus returning"); return; } /* get all information from database regarding this queryid*/ string mysqlQueryString = "SELECT * FROM `queries` WHERE `queryid` = " + DataGrdVuAdminQueries.SelectedRows[0].Cells["QueryId"].Value.ToString(); try { frmMysqlConnection.Open(); } catch (Exception errConnOpen) { MessageBox.Show("Error in opening mysql connection because : " + errConnOpen.Message); return; } DataSet queryDataset = new DataSet(); MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(mysqlQueryString, frmMysqlConnection); mySqlDataAdapter.Fill(queryDataset, "SELECTED_QUERY"); mysqlQueryString = "SELECT * FROM `queryworkinghotel` WHERE `queryid` = " + DataGrdVuAdminQueries.SelectedRows[0].Cells["QueryId"].Value.ToString(); mySqlDataAdapter.SelectCommand.CommandText = mysqlQueryString; mySqlDataAdapter.Fill(queryDataset, "QUERY_HOTEL_INFO"); /* Generate pdf file for ITINERARY */ Int32 yCordinateUtilized = 0; PdfDocument pdfDocument = new PdfDocument(); PdfPage pdfPage = pdfDocument.AddPage(); XGraphics xGraphics = XGraphics.FromPdfPage(pdfPage); XFont xFontBody = new XFont("Times New Roman", 11, XFontStyle.Regular); XFont xFontHeader = new XFont("Times New Roman", 15, XFontStyle.Bold); XTextFormatter xTextFormatter = new XTextFormatter(xGraphics); XImage image = Properties.Resources.imageExcursionHolidaysLetterHead; xGraphics.DrawImage(image, 0, 0, 605, 95); yCordinateUtilized += 100; string fileContent; double noOfnights = (DateTime.Parse(DataGrdVuAdminQueries.SelectedRows[0].Cells["toDate"].Value.ToString()) - DateTime.Parse(DataGrdVuAdminQueries.SelectedRows[0].Cells["fromDate"].Value.ToString())).TotalDays; fileContent = DataGrdVuAdminQueries.SelectedRows[0].Cells["Location"].Value.ToString() + " Tour\r\n" + noOfnights.ToString() + " Nights and " + (noOfnights + 1).ToString() + " Days"; XRect xRect = new XRect(40, yCordinateUtilized, 560, 40); yCordinateUtilized += 40; xGraphics.DrawRectangle(XBrushes.White, xRect); xTextFormatter.Alignment = XParagraphAlignment.Center; xTextFormatter.DrawString(fileContent, xFontHeader, XBrushes.Black, xRect, XStringFormat.TopLeft); foreach (DataRow item in queryDataset.Tables["QUERY_HOTEL_INFO"].Rows) { fileContent = "For Day " + item["dayno"].ToString() + " Hotel selected in city " + item["city"].ToString() + " is " + item["hotel"].ToString(); fileContent += " room " + item["roomno"].ToString() + " with meal plan " + item["mealplan"].ToString() + " having " + item["extrabed"].ToString(); fileContent += " extra bed and " + item["extrameal"].ToString() + " extra meal is at rate " + item["price"].ToString(); xRect = new XRect(40, yCordinateUtilized, 560, 40); yCordinateUtilized += 40; xGraphics.DrawRectangle(XBrushes.White, xRect); xTextFormatter.Alignment = XParagraphAlignment.Left; xTextFormatter.DrawString(fileContent, xFontBody, XBrushes.Black, xRect, XStringFormat.TopLeft); } try { /* try to save file */ pdfDocument.Save(saveFileDialogItinerary.FileName); } catch (Exception errSave) { MessageBox.Show("Error in saving file " + saveFileDialogItinerary.FileName + " because " + errSave.Message); Debug.WriteLine("Error in saving file " + saveFileDialogItinerary.FileName + " because " + errSave.Message); } finally { pdfDocument.Close(); } MySqlCommand mySqlCommand = frmMysqlConnection.CreateCommand(); MySqlTransaction mySqlTransaction = frmMysqlConnection.BeginTransaction(); mySqlCommand.Connection = frmMysqlConnection; mySqlCommand.Transaction = mySqlTransaction; mySqlCommand.CommandType = CommandType.Text; mySqlCommand.CommandText = "UPDATE `queries` SET " + "`querylastupdatetime` = NOW(), " + "`querycurrentstate` = " + Properties.Resources.queryStageMailed + " " + "WHERE " + "queryid = " + DataGrdVuAdminQueries.SelectedRows[0].Cells["QueryId"].Value.ToString(); mySqlCommand.Prepare(); try { mySqlCommand.ExecuteNonQuery(); mySqlTransaction.Commit(); } catch (Exception errquery) { MessageBox.Show("Error while executing insert query because:\n" + errquery.Message); } try { frmMysqlConnection.Close(); } catch (Exception errConnClose) { MessageBox.Show("Error in Closing mysql connection because : " + errConnClose.Message); } } } else { MessageBox.Show("Please load Queries First", "Load Queries", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }