void GetPayRef() { string values = string.Empty; lblSelect.Text = string.Empty; int j = 0; temTable.Clear(); for (int i = 0; i < selection.SelectedCount; i++) { temTable.Rows.Add(new object[] { String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["EReceipts"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["PaymentRefNumber"]), Program.UserID }); values += String.Format("'{0}'", (selection.GetSelectedRow(i) as DataRowView)["PaymentRefNumber"]); if (j + 1 < selection.SelectedCount) { values += ","; } ++j; } Program.IsReprint = false; try { SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); if (!isReprint) { //using (WaitDialogForm form = new WaitDialogForm("Application Working...,Please Wait...", "Processing Your Request")) //{ using (SqlConnection connect = new SqlConnection(Logic.ConnectionString)) { connect.Open(); _command = new SqlCommand("InserttblReceipt", connect) { CommandType = CommandType.StoredProcedure }; _command.Parameters.Add(new SqlParameter("@tblCollectionReport_Temp", SqlDbType.Structured)).Value = temTable; _command.Parameters.Add(new SqlParameter("@type", SqlDbType.VarChar)).Value = "Edit"; _command.Parameters.Add(new SqlParameter("@userid", SqlDbType.VarChar)).Value = Program.UserID; System.Data.DataSet response = new System.Data.DataSet(); response.Clear(); adp = new SqlDataAdapter(_command); adp.Fill(response); connect.Close(); if (String.Compare(response.Tables[0].Rows[0]["returnCode"].ToString(), "00", false) == 0) { //do something load the report page using (SqlConnection db = new SqlConnection(Logic.ConnectionString)) { SqlTransaction transaction; db.Open(); transaction = db.BeginTransaction(); try { using (System.Data.DataSet dds = new System.Data.DataSet("DsCollectionReport")) { SqlDataAdapter ada; string strFormat = null; query = string.Format("SELECT [ID] , [Provider] , [Channel] , tblCollectionReport.PaymentRefNumber , [DepositSlipNumber] ,CONVERT(VARCHAR, CONVERT(DATE, [PaymentDate])) AS PaymentDate , [PayerID] , UPPER([PayerName]) AS [PayerName] , [Amount] , [PaymentMethod] ,[ChequeNumber] , [ChequeValueDate] , [ChequeStatus] ,[DateChequeReturned] ,[TelephoneNumber] , [ReceiptNo] , [ReceiptDate] , UPPER([PayerAddress]) AS [PayerAddress] ,[User] , [RevenueCode] , tblCollectionReport.Description , [ChequeBankCode] ,[ChequeBankName] , [AgencyName] , [AgencyCode] , [BankCode] , [BankName] , [BranchCode] ,[BranchName] , [ZoneCode] , [ZoneName] , [Username] ,[AmountWords] , [EReceipts] , [EReceiptsDate] ,[GeneratedBy] ,[StationCode] ,ControlNumber ,ControlNumberDate , ( SELECT TOP 1 StationName FROM Receipt.tblStation WHERE tblStation.StationCode = Collection.tblCollectionReport.[StationCode]) AS StationName, Symbol , Surfix , tblCurrency.Description AS prefix FROM Collection.tblCollectionReport LEFT JOIN Receipt.tblReprintedReceipts ON tblCollectionReport.PaymentRefNumber = tblReprintedReceipts.PaymentRefNumber inner JOIN Reconciliation.tblCurrency ON tblCurrency.CurrencyCode = tblCollectionReport.CurrencyCode WHERE tblCollectionReport.PaymentRefNumber IN ({0}) ORDER BY Collection.tblCollectionReport.StationCode , Collection.tblCollectionReport.AgencyCode ,Collection.tblCollectionReport.RevenueCode,Collection.tblCollectionReport.EReceipts", values); DataTable Dt = dds.Tables.Add("CollectionReportTable"); ada = new SqlDataAdapter(query, Logic.ConnectionString); ada.Fill(dds, "CollectionReportTable"); Logic.ProcessDataTable(Dt);; //strCollectionReportID = strFormat; //XRepReceipt recportRec = new XRepReceipt { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; //recportRec.ShowPreviewDialog(); switch (Program.intCode) { case 13: //Akwa Ibom state XtraRepReceiptAkwa akwa = new XtraRepReceiptAkwa { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; akwa.ShowPreviewDialog(); break; case 20: //detla state XtraRepReceiptDelta delta = new XtraRepReceiptDelta { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; //delta.PrintingSystem.StartPrint += PrintingSystem_StartPrint; //if (Program.stateCode == "20") //{ // if (Convert.ToInt32(radioGroup1.EditValue) != 1) // { // delta.xrLabel19.Visible = true; // //delta.xrLabel13.Visible = true; // } //} //delta.Watermark.Text = "DUPLICATE"; ////delta.Watermark.TextDirection = DirectionMode.Clockwise; //delta.Watermark.Font = new Font(delta.Watermark.Font.FontFamily, 40); //delta.Watermark.ForeColor = Color.DodgerBlue; //delta.Watermark.TextTransparency = 150; //delta.Watermark.ShowBehind = false; delta.logoPath = Logic.singaturepth; delta.Imagepath = Logic.logopth; //report.Watermark.Text = "DUPLICATE"; delta.xrLabel3.Visible = true; //delta.Imagepath = Logic.; delta.Watermark.Text = "DUPLICATE"; delta.ShowPreviewDialog(); //delta.Print(); break; case 37: //ogun state XRepReceipt recportRec = new XRepReceipt { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; //recportRec.logoPath = Logic.singaturepth; recportRec.logoPath = Logic.singaturepth; recportRec.ShowPreviewDialog(); break; case 40: //oyo state XRepReceiptoyo recportRecs = new XRepReceiptoyo { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; recportRecs.ShowPreviewDialog(); break; //case 32://kogi state // XRepReceiptkogi recportRecko = new XRepReceiptkogi { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; // recportRecko.ShowPreviewDialog(); // break; default: break; } //selection.ClearSelection(); dds.Clear(); } } catch (SqlException sqlError) { //transaction.Rollback(); Tripous.Sys.ErrorBox(sqlError); } catch (Exception ex) { Tripous.Sys.ErrorBox(ex); } db.Close(); } } else { if (String.Compare(response.Tables[0].Rows[0]["returnCode"].ToString(), "-1", false) == 0) { using (Frmcontrol frmcontrol = new Frmcontrol()) { frmcontrol.gridControl1.DataSource = response.Tables[1]; frmcontrol.gridView1.BestFitColumns(); frmcontrol.label1.Text = "Payment Ref. Number Already been used"; frmcontrol.Text = "Payment Ref. Number Already been used"; frmcontrol.ShowDialog(); } } else { Common.setMessageBox(response.Tables[0].Rows[0]["returnMessage"].ToString(), "", 2); return; } } } } else { using (SqlConnection db = new SqlConnection(Logic.ConnectionString)) { SqlTransaction transaction; db.Open(); transaction = db.BeginTransaction(); using (System.Data.DataSet dds = new System.Data.DataSet("DsCollectionReport")) { SqlDataAdapter ada; using (WaitDialogForm form = new WaitDialogForm()) { string strFormat = null; query = string.Format("SELECT [ID] , [Provider] , [Channel] , tblCollectionReport.PaymentRefNumber , [DepositSlipNumber] ,CONVERT(VARCHAR, CONVERT(DATE, [PaymentDate])) AS PaymentDate , [PayerID] , UPPER([PayerName]) AS [PayerName] , [Amount] , [PaymentMethod] ,[ChequeNumber] , [ChequeValueDate] , [ChequeStatus] ,[DateChequeReturned] ,[TelephoneNumber] , [ReceiptNo] , [ReceiptDate] , UPPER([PayerAddress]) AS [PayerAddress] ,[User] , [RevenueCode] , tblCollectionReport.Description , [ChequeBankCode] ,[ChequeBankName] , [AgencyName] , [AgencyCode] , [BankCode] , [BankName] , [BranchCode] ,[BranchName] , [ZoneCode] , [ZoneName] , [Username] ,[AmountWords] , [EReceipts] , [EReceiptsDate] ,[GeneratedBy] ,[StationCode] ,ControlNumber ,ControlNumberDate , ( SELECT TOP 1 StationName FROM Receipt.tblStation WHERE tblStation.StationCode = Collection.tblCollectionReport.[StationCode]) AS StationName, Symbol , Surfix , tblCurrency.Description AS prefix FROM Collection.tblCollectionReport INNER JOIN Reconciliation.tblCurrency ON tblCurrency.CurrencyCode = tblCollectionReport.CurrencyCode LEFT JOIN Receipt.tblReprintedReceipts ON tblCollectionReport.PaymentRefNumber = tblReprintedReceipts.PaymentRefNumber WHERE tblCollectionReport.PaymentRefNumber IN ({0}) ORDER BY Collection.tblCollectionReport.EReceipts", values); DataTable Dt = dds.Tables.Add("CollectionReportTable"); ada = new SqlDataAdapter(query, Logic.ConnectionString); ada.Fill(dds, "CollectionReportTable"); Logic.ProcessDataTable(Dt);; //strCollectionReportID = strFormat; } //XRepReceipt recportRec = new XRepReceipt { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; //recportRec.ShowPreviewDialog(); //selection.ClearSelection(); dds.Clear(); switch (Program.intCode) { case 13: //Akwa Ibom state XtraRepReceiptAkwa akwa = new XtraRepReceiptAkwa { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; akwa.ShowPreviewDialog(); break; case 37: //ogun state XRepReceipt recportRec = new XRepReceipt { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; recportRec.logoPath = Logic.singaturepth; recportRec.ShowPreviewDialog(); break; case 20: //detla state XtraRepReceiptDelta delta = new XtraRepReceiptDelta { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; //delta.PrintingSystem.StartPrint += PrintingSystem_StartPrint; //if (Program.stateCode == "20") //{ // if (Convert.ToInt32(radioGroup1.EditValue) != 1) // { // delta.xrLabel19.Visible = true; // //delta.xrLabel13.Visible = true; // } //} //delta.Watermark.Text = "DUPLICATE"; ////delta.Watermark.TextDirection = DirectionMode.Clockwise; //delta.Watermark.Font = new Font(delta.Watermark.Font.FontFamily, 40); //delta.Watermark.ForeColor = Color.DodgerBlue; //delta.Watermark.TextTransparency = 150; //delta.Watermark.ShowBehind = false; delta.logoPath = Logic.singaturepth; delta.Imagepath = Logic.logopth; //report.Watermark.Text = "DUPLICATE"; delta.xrLabel3.Visible = true; delta.logoPath = Logic.singaturepth; delta.Watermark.Text = "DUPLICATE"; delta.ShowPreviewDialog(); //delta.Print(); break; case 40: //oyo state XRepReceiptoyo recportRecs = new XRepReceiptoyo { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; recportRecs.ShowPreviewDialog(); break; //case 32://kogi state // XRepReceiptkogi recportRecko = new XRepReceiptkogi { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; // recportRecko.ShowPreviewDialog(); // break; default: break; } } } } } finally { SplashScreenManager.CloseForm(false); } //return values; }
void GetPayRef() { //string values = string.Empty; lblSelect.Text = string.Empty; int j = 0; for (int i = 0; i < selection.SelectedCount; i++) { values += String.Format("'{0}'", (selection.GetSelectedRow(i) as DataRowView)["PaymentRefNumber"]); if (j + 1 < selection.SelectedCount) { values += ","; } ++j; temTable.Rows.Add(new object[] { String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["PaymentRefNumber"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["EReceipts"]), Program.UserID }); } //new line here using (System.Data.DataSet dds = new System.Data.DataSet("DsCollectionReport")) { SqlDataAdapter ada; using (WaitDialogForm form = new WaitDialogForm()) { string strFormat = null; string query = string.Empty; switch (Program.intCode) { case 20: //detla state query = string.Format("SELECT [ID] , [Provider] , [Channel] ,Collection.tblCollectionReport.[PaymentRefNumber] , [DepositSlipNumber] , CONVERT(VARCHAR,CONVERT(DATE,[PaymentDate])) AS PaymentDate,[PayerID] , UPPER([PayerName]) AS [PayerName], [Amount] ,[PaymentMethod] ,[ChequeNumber] ,[ChequeValueDate] ,[ChequeStatus] ,[DateChequeReturned] ,[TelephoneNumber] ,[ReceiptNo] as [EReceipts],Collection.tblCollectionReport.ReceiptDate ,UPPER([PayerAddress]) as [PayerAddress] ,[User] ,[RevenueCode] ,[Description] , [ChequeBankCode] ,[ChequeBankName] ,[AgencyName] ,[AgencyCode] ,[BankCode] ,[BankName] ,[BranchCode] ,[BranchName] ,[ZoneCode] ,[ZoneName] ,[Username] ,[AmountWords] ,Collection.tblCollectionReport.[EReceiptsDate] ,[GeneratedBy] ,Collection.tblCollectionReport.[StationCode] ,(SELECT TOP 1 StationName FROM Receipt.tblStation WHERE tblStation.StationCode = Collection.tblCollectionReport.[StationCode]) AS StationName,ControlNumber,ControlNumberBy,ControlNumberDate,IsPrintedDate,PrintedBY from Collection.tblCollectionReport INNER JOIN Receipt.tblCollectionReceipt ON Receipt.tblCollectionReceipt.PaymentRefNumber = Collection.tblCollectionReport.PaymentRefNumber INNER JOIN Receipt.tblReceiptoption ON Receipt.tblReceiptoption.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.PaymentRefNumber IN ({0}) AND Receipt.tblReceiptoption.IsPrinted=1 AND Receipt.tblReceiptoption.OptionVal={1} ORDER BY Collection.tblCollectionReport.AgencyName ,Collection.tblCollectionReport.Description,Collection.tblCollectionReport.EReceipts", values, (ival - 1)); break; default: query = string.Format("SELECT [ID] , [Provider] , [Channel] ,Collection.tblCollectionReport.[PaymentRefNumber] , [DepositSlipNumber] , CONVERT(VARCHAR,CONVERT(DATE,[PaymentDate])) AS PaymentDate,[PayerID] , UPPER([PayerName]) AS [PayerName], [Amount] ,[PaymentMethod] ,[ChequeNumber] ,[ChequeValueDate] ,[ChequeStatus] ,[DateChequeReturned] ,[TelephoneNumber] ,[ReceiptNo] ,Collection.tblCollectionReport.ReceiptDate ,UPPER([PayerAddress]) as [PayerAddress] ,[User] ,[RevenueCode] ,tblCollectionReport.Description , [ChequeBankCode] ,[ChequeBankName] ,[AgencyName] ,[AgencyCode] ,[BankCode] ,[BankName] ,[BranchCode] ,[BranchName] ,[ZoneCode] ,[ZoneName] ,[Username] ,[AmountWords] ,Collection.tblCollectionReport.[EReceipts] ,Collection.tblCollectionReport.[EReceiptsDate] ,[GeneratedBy] ,Collection.tblCollectionReport.[StationCode] ,(SELECT TOP 1 StationName FROM Receipt.tblStation WHERE tblStation.StationCode = Collection.tblCollectionReport.[StationCode]) AS StationName,ControlNumber,ControlNumberBy,ControlNumberDate,IsPrintedDate,PrintedBY, Symbol , Surfix , tblCurrency.Description AS prefix from Collection.tblCollectionReport JOIN Reconciliation.tblCurrency ON tblCurrency.CurrencyCode = tblCollectionReport.CurrencyCode INNER JOIN Receipt.tblCollectionReceipt ON Receipt.tblCollectionReceipt.PaymentRefNumber = Collection.tblCollectionReport.PaymentRefNumber INNER JOIN Receipt.tblReceiptoption ON Receipt.tblReceiptoption.PaymentRefNumber = Receipt.tblCollectionReceipt.PaymentRefNumber WHERE Collection.tblCollectionReport.PaymentRefNumber IN ({0}) AND Receipt.tblReceiptoption.IsPrinted=1 AND Receipt.tblReceiptoption.OptionVal={1} ORDER BY Collection.tblCollectionReport.AgencyName ,Collection.tblCollectionReport.Description,Collection.tblCollectionReport.EReceipts", values, (ival - 1)); break; } DataTable Dt = dds.Tables.Add("CollectionReportTable"); ada = new SqlDataAdapter(query, Logic.ConnectionString); ada.Fill(dds, "CollectionReportTable"); Logic.ProcessDataTable(Dt);; //strCollectionReportID = strFormat; } switch (Program.intCode) { case 13: //Akwa Ibom state XtraRepReceiptAkwa akwa = new XtraRepReceiptAkwa { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; akwa.ShowPreviewDialog(); break; case 20: //detla state XtraRepReceiptDelta delta = new XtraRepReceiptDelta { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; delta.xrLabel19.Visible = true; //delta.xrLabel13.Visible = true; delta.logoPath = Logic.singaturepth; delta.ShowPreviewDialog(); break; case 37: //ogun state XRepReceipt recportRec = new XRepReceipt { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; recportRec.logoPath = Logic.singaturepth; recportRec.ShowPreviewDialog(); break; case 40: //oyo state XRepReceiptoyo recportRecs = new XRepReceiptoyo { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; recportRecs.ShowPreviewDialog(); break; default: break; } } DialogResult result = MessageBox.Show(" Is Receipt Printing Successful ?", Program.ApplicationName, MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { try { SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); bttnMain.Visible = true; label1.Visible = true; bttnMain.Enabled = true; using (SqlConnection connect = new SqlConnection(Logic.ConnectionString)) { connect.Open(); _command = new SqlCommand("doReceiptOptionother", connect) { CommandType = CommandType.StoredProcedure }; _command.Parameters.Add(new SqlParameter("@userid", SqlDbType.VarChar)).Value = Program.UserID; _command.Parameters.Add(new SqlParameter("@Receop", SqlDbType.VarChar)).Value = ival; _command.Parameters.Add(new SqlParameter("@tempTable", SqlDbType.Structured)).Value = temTable; System.Data.DataSet response = new System.Data.DataSet(); adp = new SqlDataAdapter(_command); adp.Fill(response); connect.Close(); if (response.Tables[0].Rows[0]["returnCode"].ToString() != "00") { Tripous.Sys.ErrorBox(response.Tables[0].Rows[0]["returnMessage"].ToString()); return; } else { Common.setMessageBox("Receipt Printed Successfully", Program.ApplicationName, 1); //selection.ClearSelection(); this.Close(); return; } } } catch (Exception ex) { Tripous.Sys.ErrorBox(ex); return; } finally { SplashScreenManager.CloseForm(false); } //using (FrmMainFest frmMainFest = new FrmMainFest(strCollectionReportID, values, criteria2, false) { IDList = strCollectionReportID }) //{ // frmMainFest.ShowDialog(); //} } else { return; } #region old //using (SqlConnection connect = new SqlConnection(Logic.ConnectionString)) //{ // connect.Open(); // _command = new SqlCommand("InserttblReceipt", connect) { CommandType = CommandType.StoredProcedure }; // _command.Parameters.Add(new SqlParameter("@tblCollectionReport_Temp", SqlDbType.Structured)).Value = temTable; // _command.Parameters.Add(new SqlParameter("@type", SqlDbType.VarChar)).Value = "New"; // _command.Parameters.Add(new SqlParameter("@userid", SqlDbType.VarChar)).Value = Program.UserID; // System.Data.DataSet response = new System.Data.DataSet(); // response.Clear(); // adp = new SqlDataAdapter(_command); // adp.Fill(response); // connect.Close(); // if (String.Compare(response.Tables[0].Rows[0]["returnCode"].ToString(), "00", false) == 0) // { // //do something load the report page // using (SqlConnection db = new SqlConnection(Logic.ConnectionString)) // { // SqlTransaction transaction; // db.Open(); // transaction = db.BeginTransaction(); // try // { // using (System.Data.DataSet dds = new System.Data.DataSet("DsCollectionReport")) // { // SqlDataAdapter ada; // using (WaitDialogForm form = new WaitDialogForm()) // { // string strFormat = null; // string query = string.Format("SELECT [ID] , [Provider] , [Channel] ,Collection.tblCollectionReport.[PaymentRefNumber] , [DepositSlipNumber] , CONVERT(VARCHAR,CONVERT(DATE,[PaymentDate])) AS PaymentDate,[PayerID] , UPPER([PayerName]) AS [PayerName], [Amount] ,[PaymentMethod] ,[ChequeNumber] ,[ChequeValueDate] ,[ChequeStatus] ,[DateChequeReturned] ,[TelephoneNumber] ,[ReceiptNo] ,[ReceiptDate] ,UPPER([PayerAddress]) as [PayerAddress] ,[User] ,[RevenueCode] ,[Description] , [ChequeBankCode] ,[ChequeBankName] ,[AgencyName] ,[AgencyCode] ,[BankCode] ,[BankName] ,[BranchCode] ,[BranchName] ,[ZoneCode] ,[ZoneName] ,[Username] ,[AmountWords] ,Collection.tblCollectionReport.[EReceipts] ,Collection.tblCollectionReport.[EReceiptsDate] ,[GeneratedBy] ,Collection.tblCollectionReport.[StationCode] ,(SELECT TOP 1 StationName FROM Receipt.tblStation WHERE tblStation.StationCode = Collection.tblCollectionReport.[StationCode]) AS StationName,ControlNumber from Collection.tblCollectionReport INNER JOIN Receipt.tblCollectionReceipt ON Receipt.tblCollectionReceipt.PaymentRefNumber = Collection.tblCollectionReport.PaymentRefNumber WHERE PaymentRefNumber IN ({0}) ORDER BY Collection.tblCollectionReport.AgencyName ,Collection.tblCollectionReport.Description,Collection.tblCollectionReport.EReceipts", values); // DataTable Dt = dds.Tables.Add("CollectionReportTable"); // ada = new SqlDataAdapter(query, Logic.ConnectionString); // ada.Fill(dds, "CollectionReportTable"); // Logic.ProcessDataTable(Dt);; // //strCollectionReportID = strFormat; // } // //XRepReceipt recportRec = new XRepReceipt { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; // //recportRec.ShowPreviewDialog(); // ////selection.ClearSelection(); // //dds.Clear(); // switch (Program.intCode) // { // case 13://Akwa Ibom state // XtraRepReceiptAkwa akwa = new XtraRepReceiptAkwa { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; // akwa.ShowPreviewDialog(); // break; // case 20://detla state // XtraRepReceiptDelta delta = new XtraRepReceiptDelta { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; // delta.ShowPreviewDialog(); // break; // case 37://ogun state // XRepReceipt recportRec = new XRepReceipt { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; // recportRec.ShowPreviewDialog(); // break; // case 40://oyo state // XRepReceiptoyo recportRecs = new XRepReceiptoyo { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; // recportRecs.ShowPreviewDialog(); // break; // //case 32://kogi state // // XRepReceiptkogi recportRecko = new XRepReceiptkogi { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; // // recportRecko.ShowPreviewDialog(); // // break; // default: // break; // } // } // //dds.Clear(); // DialogResult result = MessageBox.Show(" Is Receipt Printing Successful ?", Program.ApplicationName, MessageBoxButtons.YesNo); // if (result == DialogResult.Yes) // { // try // { // SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); // //update the collection table by seting the isprinted to true // using (SqlConnection dbs = new SqlConnection(Logic.ConnectionString)) // { // SqlTransaction transactions; // dbs.Open(); // //transaction = db.BeginTransaction(); // transactions = dbs.BeginTransaction(); // try // { // string query1 = String.Format("UPDATE tblCollectionReport SET isPrinted=1,IsPrintedDate= '{0:MM/dd/yyyy HH:mm:ss tt}',PrintedBY='{1}' ,StationCode='{2}' WHERE PaymentRefNumber IN ({3})", DateTime.Now, Program.UserID, Program.stationCode, values); // //string query1 = String.Format("UPDATE Receipt.tblCollectionReceipt SET isPrinted=1,IsPrintedDate= '{0:MM/dd/yyyy HH:mm:ss tt}',PrintedBY='{1}',StationCode='{2}' WHERE PaymentRefNumber IN (SELECT PaymentRefNumber FROM Receipt.tblReceipt WHERE SentBy='{1}')", DateTime.Now, Program.UserID, Program.stationCode); // using (SqlCommand sqlCommand = new SqlCommand(query1, db, transaction)) // { // sqlCommand.ExecuteNonQuery(); // } // } // catch (Exception ex) // { // transaction.Rollback(); // Tripous.Sys.ErrorBox(ex); // return; // } // transaction.Commit(); // db.Close(); // } // bttnMain.Visible = true; label1.Visible = true; // bttnMain.Enabled = true; // } // finally // { // SplashScreenManager.CloseForm(false); // } // //using (FrmMainFest frmMainFest = new FrmMainFest(strCollectionReportID, values, criteria2, false) { IDList = strCollectionReportID }) // //{ // // frmMainFest.ShowDialog(); // //} // } // else // return; // } // catch (SqlException sqlError) // { // //transaction.Rollback(); // Tripous.Sys.ErrorBox(sqlError); // } // catch (Exception ex) // { // Tripous.Sys.ErrorBox(ex); // } // db.Close(); // } // } // else // { // if (String.Compare(response.Tables[0].Rows[0]["returnCode"].ToString(), "-1", false) == 0) // { // using (Frmcontrol frmcontrol = new Frmcontrol()) // { // frmcontrol.gridControl1.DataSource = response.Tables[1]; // frmcontrol.gridView1.BestFitColumns(); // frmcontrol.label1.Text = "Payment Ref. Number Receipt printing in Process"; // frmcontrol.Text = "Payment Ref. Number Receipt printing in Process"; // frmcontrol.ShowDialog(); // } // DialogResult result = MessageBox.Show("Do you wish to continue to Print the Receipts?", Program.ApplicationName, MessageBoxButtons.YesNo); // if (result == DialogResult.Yes) // { // using (SqlConnection db = new SqlConnection(Logic.ConnectionString)) // { // SqlTransaction transaction; // db.Open(); // transaction = db.BeginTransaction(); // try // { // using (System.Data.DataSet dds = new System.Data.DataSet("DsCollectionReport")) // { // SqlDataAdapter ada; // using (WaitDialogForm form = new WaitDialogForm()) // { // string strFormat = null; // string query = string.Format("SELECT [ID] , [Provider] , [Channel] ,[PaymentRefNumber] , [DepositSlipNumber] , CONVERT(VARCHAR,CONVERT(DATE,[PaymentDate])) AS PaymentDate,[PayerID] , UPPER([PayerName]) AS [PayerName], [Amount] ,[PaymentMethod] ,[ChequeNumber] ,[ChequeValueDate] ,[ChequeStatus] ,[DateChequeReturned] ,[TelephoneNumber] ,[ReceiptNo] ,[ReceiptDate] ,UPPER([PayerAddress]) as [PayerAddress] ,[User] ,[RevenueCode] ,[Description] , [ChequeBankCode] ,[ChequeBankName] ,[AgencyName] ,[AgencyCode] ,[BankCode] ,[BankName] ,[BranchCode] ,[BranchName] ,[ZoneCode] ,[ZoneName] ,[Username] ,[AmountWords] ,[EReceipts] ,[EReceiptsDate] ,[GeneratedBy] ,[StationCode] ,(SELECT TOP 1 StationName FROM Receipt.tblStation WHERE tblStation.StationCode = Collection.tblCollectionReport.[StationCode]) AS StationName from Collection.tblCollectionReport WHERE PaymentRefNumber IN ({0}) ORDER BY Collection.tblCollectionReport.AgencyName ,Collection.tblCollectionReport.Description,Collection.tblCollectionReport.EReceipts", values); // DataTable Dt = dds.Tables.Add("CollectionReportTable"); // ada = new SqlDataAdapter(query, Logic.ConnectionString); // ada.Fill(dds, "CollectionReportTable"); // Logic.ProcessDataTable(Dt);; // //strCollectionReportID = strFormat; // } // //XRepReceipt recportRec = new XRepReceipt { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; // //recportRec.ShowPreviewDialog(); // switch (Program.intCode) // { // case 13://Akwa Ibom state // XtraRepReceiptAkwa akwa = new XtraRepReceiptAkwa { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; // akwa.ShowPreviewDialog(); // break; // case 20://detla state // XtraRepReceiptDelta delta = new XtraRepReceiptDelta { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; // delta.ShowPreviewDialog(); // break; // case 37://ogun state // XRepReceipt recportRec = new XRepReceipt { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; // recportRec.ShowPreviewDialog(); // break; // case 40://oyo state // XRepReceiptoyo recportRecs = new XRepReceiptoyo { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; // recportRecs.ShowPreviewDialog(); // break; // //case 32://kogi state // // XRepReceiptkogi recportRecko = new XRepReceiptkogi { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; // // recportRecko.ShowPreviewDialog(); // // break; // default: // break; // } // //selection.ClearSelection(); // dds.Clear(); // } // DialogResult results = MessageBox.Show(" Is Receipt Printing Successful ?", Program.ApplicationName, MessageBoxButtons.YesNo); // if (results == DialogResult.Yes) // { // try // { // SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); // //update the collection table by seting the isprinted to true // using (SqlConnection dbs = new SqlConnection(Logic.ConnectionString)) // { // SqlTransaction transactions; // dbs.Open(); // //transaction = db.BeginTransaction(); // transactions = dbs.BeginTransaction(); // try // { // string query1 = String.Format("UPDATE Receipt.tblCollectionReceipt SET isPrinted=1,IsPrintedDate= '{0:MM/dd/yyyy HH:mm:ss tt}',PrintedBY='{1}' ,StationCode='{2}' WHERE PaymentRefNumber IN ({3})", DateTime.Now, Program.UserID, Program.stationCode, values); // //string query1 = String.Format("UPDATE Receipt.tblCollectionReceipt SET isPrinted=1,IsPrintedDate= '{0:MM/dd/yyyy HH:mm:ss tt}',PrintedBY='{1}',StationCode='{2}' WHERE PaymentRefNumber IN (SELECT PaymentRefNumber FROM Receipt.tblReceipt WHERE SentBy='{1}')", DateTime.Now, Program.UserID, Program.stationCode); // using (SqlCommand sqlCommand = new SqlCommand(query1, db, transaction)) // { // sqlCommand.ExecuteNonQuery(); // } // } // catch (Exception ex) // { // transaction.Rollback(); // Tripous.Sys.ErrorBox(ex); // return; // } // transaction.Commit(); // db.Close(); // } // bttnMain.Visible = true; label1.Visible = true; // bttnMain.Enabled = true; // } // finally // { // SplashScreenManager.CloseForm(false); // } // //using (FrmMainFest frmMainFest = new FrmMainFest(strCollectionReportID, values, criteria2, false) { IDList = strCollectionReportID }) // //{ // // this.Close(); // // frmMainFest.ShowDialog(); // //} // } // else // return; // } // catch (SqlException sqlError) // { // //transaction.Rollback(); // Tripous.Sys.ErrorBox(sqlError); // } // catch (Exception ex) // { // Tripous.Sys.ErrorBox(ex); // } // db.Close(); // } // } // else // return; // } // else // { // Common.setMessageBox(response.Tables[0].Rows[0]["returnMessage"].ToString(), "", 2); // return; // } // } //} #endregion }
void ReceiptCall() { XRepReceipt recportRec = new XRepReceipt(); recportRec.ShowPreviewDialog(); }
void bttn(object sender, EventArgs e) { if (sender == btnConfirm) { //loop the TableLayoutCellPaintEventArgs if reason is empty foreach (DataRow row in dtget.Rows) { if ((row["Reasons"] is DBNull) || (row["Reasons"] == "") || (string.IsNullOrEmpty(Convert.ToString(row["Reasons"])))) { isEmpty = true; Common.setMessageBox("Reason Can't be Empty", "Request Sending", 2); break; } else { using (WaitDialogForm form = new WaitDialogForm("Application Working...,Please Wait...", "Sending Request")) { try { using (var receiptsserv = new ReceiptService()) { dsreturn = receiptsserv.LogReceiptsReprintRequest((string)row["ReceiptNo"], (string)row["PaymentRefNumber"], string.Empty, Program.UserID, (string)row["Reasons"], "NONE", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, Program.stationCode); } isEmpty = false; } catch (Exception ex) { Common.setMessageBox(string.Format("{0}----{1}..Sending Request Reprint of Receipt Failed", ex.Message, ex.StackTrace), Program.ApplicationName, 3); return; } } } } if (!isEmpty) { //get return message from online if (dsreturn.Tables[0].Rows[0]["returnmessage"].ToString() == "-1") { Common.setMessageBox(dsreturn.Tables[0].Rows[0]["returnmessage1"].ToString(), Program.ApplicationName, 1); return; } else { using (SqlConnection connect = new SqlConnection(Logic.ConnectionString)) { connect.Open(); _command = new SqlCommand("UpdateRequestSent", connect) { CommandType = CommandType.StoredProcedure }; _command.Parameters.Add(new SqlParameter("@status", SqlDbType.VarChar)).Value = "Sent"; _command.Parameters.Add(new SqlParameter("@tblCollectionReport_Temp", SqlDbType.Structured)).Value = dtget; System.Data.DataSet response = new System.Data.DataSet(); adp = new SqlDataAdapter(_command); adp.Fill(response); connect.Close(); if (response.Tables[0].Rows[0]["returnCode"].ToString() != "00") { Common.setMessageBox(response.Tables[0].Rows[0]["returnMessage"].ToString(), "Manifest", 2); return; } else { Common.setMessageBox("Request Sent for Approval..", Program.ApplicationName, 1); Common.setMessageBox("Call your Admin Office for Record Aproval..,Click on Get Record Approval to get Record", Program.ApplicationName, 1); } } return; } } } else if (sender == btnMain) { using (FrmMainFest frmMainFest = new FrmMainFest(strCollectionReportID, criteria3, criteria2, true) { IDList = strCollectionReportID }) { frmMainFest.ShowDialog(); } } else if (sender == btnPrint) { if (selection.SelectedCount == 0) { Common.setMessageBox("No Selection Made for Printing of Receipts", Program.ApplicationName, 3); return; } else { //criteria3 = GetPayRef(); using (SqlConnection db = new SqlConnection(Logic.ConnectionString)) { SqlTransaction transaction; db.Open(); transaction = db.BeginTransaction(); try { using (System.Data.DataSet dds = new System.Data.DataSet("DsCollectionReport")) { SqlDataAdapter ada; using (WaitDialogForm form = new WaitDialogForm()) { string strFormat = null; query = string.Format("SELECT [ID] , [Provider] , [Channel] ,[PaymentRefNumber] , [DepositSlipNumber] , CONVERT(VARCHAR,CONVERT(DATETime,[PaymentDate])) AS PaymentDate,[PayerID] , UPPER([PayerName]) AS [PayerName], [Amount] ,[PaymentMethod] ,[ChequeNumber] ,[ChequeValueDate] ,[ChequeStatus] ,[DateChequeReturned] ,[TelephoneNumber] ,[ReceiptNo] ,[ReceiptDate] ,UPPER([PayerAddress]) as [PayerAddress] ,[Status] ,[User] ,[RevenueCode] ,[Description] , [ChequeBankCode] ,[ChequeBankName] ,[AgencyName] ,[AgencyCode] ,[BankCode] ,[BankName] ,[BranchCode] ,[BranchName] ,[ZoneCode] ,[ZoneName] ,[Username] ,[State] ,[AmountWords] ,[URL] ,[EReceipts] ,[EReceiptsDate] ,[GeneratedBy] ,[DateValidatedAgainst] ,[DateDiff] ,[UploadStatus] ,[PrintedBY] ,[DatePrinted] ,[ControlNumber] ,[BatchNumber] ,[StationCode] ,(Select StationName from tblStation2 WHERE tblStation2.StationCode = tblCollectionReport.[StationCode]) AS StationName from tblCollectionReport WHERE RevenueCode NOT IN (SELECT RevenueCode FROM [tblPrintingRevenueCode]) AND PaymentRefNumber IN (SELECT PaymentRefNumber FROM [tblReceipt] where sentby ='{0}' AND Isprinted=0) AND EReceipts IN (SELECT ReceiptNo FROM [tblReceipt]) ORDER BY tblCollectionReport.StationCode , tblCollectionReport.AgencyCode ,tblCollectionReport.RevenueCode,tblCollectionReport.EReceipts", Program.UserID); DataTable Dt = dds.Tables.Add("CollectionReportTable"); ada = new SqlDataAdapter(query, Logic.ConnectionString); ada.Fill(dds, "CollectionReportTable"); Logic.ProcessDataTable(Dt);; strCollectionReportID = strFormat; } XRepReceipt recportRec = new XRepReceipt { DataSource = dds /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; recportRec.logoPath = Logic.singaturepth; recportRec.ShowPreviewDialog(); } } catch (SqlException sqlError) { //transaction.Rollback(); Tripous.Sys.ErrorBox(sqlError); } catch (Exception ex) { Tripous.Sys.ErrorBox(ex); } db.Close(); } btnMain.Enabled = true; btnPrint.Enabled = false; //btnSearch.Enabled = false; gridControl4.Enabled = false; //Common.setMessageBox(convert.tostring(DateTime.Now), Program.ApplicationName, 1); //ask if the print was sucessfull DialogResult result = MessageBox.Show(" Is Receipt Printing Successful ?", Program.ApplicationName, MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { //update the collection table by seting the isprinted to true using (SqlConnection db = new SqlConnection(Logic.ConnectionString)) { SqlTransaction transaction; db.Open(); transaction = db.BeginTransaction(); try { string query1 = String.Format("UPDATE tblCollectionReport SET isPrinted=1,IsPrintedDate= '{0:MM/dd/yyyy HH:mm:ss tt}',PrintedBY='{1}' WHERE PaymentRefNumber IN (SELECT PaymentRefNumber FROM [tblReceipt] where SentBy='{1}')", DateTime.Now, Program.UserID); using (SqlCommand sqlCommand = new SqlCommand(query1, db, transaction)) { sqlCommand.ExecuteNonQuery(); } } catch (Exception ex) { transaction.Rollback(); Tripous.Sys.ErrorBox(ex); return; } transaction.Commit(); db.Close(); } } // //} // //else // //{ // // return; // //} } //else // return; } else if (sender == btnGet) { try { using (var receiptsserv = new ReceiptService()) { dsGetapp = receiptsserv.GetReceiptReprintApproved(Program.stationCode); } } catch (Exception ex) { Common.setMessageBox(ex.StackTrace + ex.Message.ToString(), "Error", 3); return; } if (dsGetapp.Tables[0].Rows[0]["returnmessage"].ToString() == "-1") { Common.setMessageBox(dsGetapp.Tables[0].Rows[0]["returnmessage1"].ToString(), Program.ApplicationName, 1); return; } else { if (dsGetapp.Tables.Count == 0 || dsGetapp.Tables[0].Rows.Count < 1) { Common.setMessageBox("No records have been approval yet", "Get Approval Record", 1); return; } else { using (WaitDialogForm form = new WaitDialogForm("Application Working...,Please Wait...", "Getting Approval Records")) { //insert record into collection dstretval = InsertData(dsGetapp); //send return data online for update try { using (var receiptsserv = new ReceiptService()) { dsGetappup = receiptsserv.UpdateReceiptReprintApproved(dstretval); } } catch (Exception ex) { } if (dsGetappup.Tables[0].Rows[0]["returnCode"].ToString() == "00") { iTransType = TransactionTypeCode.Edit; voidgetRec(dstretval); OnFormLoad(null, null); return; } else { Common.setMessageBox(string.Format("Error Updating Approval Record, {0}...", dsGetappup.Tables[0].Rows[0]["returnMessage"]), Program.ApplicationName, 3); return; } } } } } }
void btnPrint_Click(object sender, EventArgs e) { values = string.Empty; lblSelect.Text = string.Empty; int j = 0; if (selection.SelectedCount == 0) { Common.setMessageBox("No Selection Made for Printing of Receipts", Program.ApplicationName, 3); return; } else { temTable.Clear(); for (int i = 0; i < selection.SelectedCount; i++) { temTable.Rows.Add(new object[] { String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["EReceipts"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["PaymentRefNumber"]), Program.UserID }); values += String.Format("'{0}'", (selection.GetSelectedRow(i) as DataRowView)["PaymentRefNumber"]); if (j + 1 < selection.SelectedCount) { values += ","; } ++j; } using (SqlConnection connect = new SqlConnection(Logic.ConnectionString)) { connect.Open(); _command = new SqlCommand("InserttblReceipt", connect) { CommandType = CommandType.StoredProcedure }; _command.Parameters.Add(new SqlParameter("@tblCollectionReport_Temp", SqlDbType.Structured)).Value = temTable; _command.Parameters.Add(new SqlParameter("@type", SqlDbType.VarChar)).Value = "New"; _command.Parameters.Add(new SqlParameter("@userid", SqlDbType.VarChar)).Value = Program.UserID; System.Data.DataSet response = new System.Data.DataSet(); response.Clear(); adp = new SqlDataAdapter(_command); adp.Fill(response); connect.Close(); if (String.Compare(response.Tables[0].Rows[0]["returnCode"].ToString(), "00", false) == 0) { //do something load the report page using (SqlConnection db = new SqlConnection(Logic.ConnectionString)) { SqlTransaction transaction; db.Open(); transaction = db.BeginTransaction(); try { using (System.Data.DataSet dds = new System.Data.DataSet("DsCollectionReport")) { SqlDataAdapter ada; using (WaitDialogForm form = new WaitDialogForm()) { string strFormat = null; query = string.Format("SELECT [ID] , [Provider] , [Channel] ,[PaymentRefNumber] , [DepositSlipNumber] , CONVERT(VARCHAR,CONVERT(DATETime,[PaymentDate])) AS PaymentDate,[PayerID] , UPPER([PayerName]) AS [PayerName], [Amount] ,[PaymentMethod] ,[ChequeNumber] ,[ChequeValueDate] ,[ChequeStatus] ,[DateChequeReturned] ,[TelephoneNumber] ,[ReceiptNo] ,[ReceiptDate] ,UPPER([PayerAddress]) as [PayerAddress] ,[User] ,[RevenueCode] , tblCollectionReport.Description , [ChequeBankCode] ,[ChequeBankName] ,[AgencyName] ,[AgencyCode] ,[BankCode] ,[BankName] ,[BranchCode] ,[BranchName] ,[ZoneCode] ,[ZoneName] ,[Username] ,[AmountWords] ,[EReceipts] ,[EReceiptsDate] ,[GeneratedBy] ,[StationCode] ,(SELECT StationName FROM Receipt.tblStation WHERE tblStation.StationCode = Collection.tblCollectionReport.[StationCode]) AS StationName, Symbol , Surfix , tblCurrency.Description AS prefix from Collection.tblCollectionReport JOIN Reconciliation.tblCurrency ON tblCurrency.CurrencyCode = tblCollectionReport.CurrencyCode WHERE PaymentRefNumber IN ({0}) ORDER BY Collection.tblCollectionReport.StationCode , Collection.tblCollectionReport.AgencyCode ,Collection.tblCollectionReport.RevenueCode,Collection.tblCollectionReport.EReceipts", values); DataTable Dt = dds.Tables.Add("CollectionReportTable"); ada = new SqlDataAdapter(query, Logic.ConnectionString); ada.Fill(dds, "CollectionReportTable"); Logic.ProcessDataTable(Dt);; //strCollectionReportID = strFormat; } //XRepReceipt recportRec = new XRepReceipt { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; //recportRec.ShowPreviewDialog(); //selection.ClearSelection(); dds.Clear(); switch (Program.intCode) { case 13: //Akwa Ibom state XtraRepReceiptAkwa akwa = new XtraRepReceiptAkwa { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; akwa.ShowPreviewDialog(); break; case 20: //detla state XtraRepReceiptDelta delta = new XtraRepReceiptDelta { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; //XRepReceipto/*yo delta = new XRepReceiptoyo { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" };*/ ////delta.PrintingSystem.StartPrint += PrintingSystem_StartPrint; delta.logoPath = Logic.singaturepth; delta.ShowPreviewDialog(); break; case 37: //ogun state XRepReceipt recportRec = new XRepReceipt { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; recportRec.logoPath = Logic.singaturepth; recportRec.ShowPreviewDialog(); break; case 40: //oyo state XRepReceiptoyo recportRecs = new XRepReceiptoyo { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; recportRecs.ShowPreviewDialog(); break; //case 32://kogi state // XRepReceiptkogi recportRecko = new XRepReceiptkogi { DataSource = dds.Tables[0] /*recportRec.DataAdapter = ada;*/, DataMember = "CollectionReportTable" }; // recportRecko.ShowPreviewDialog(); // break; default: break; } } } catch (SqlException sqlError) { //transaction.Rollback(); Tripous.Sys.ErrorBox(sqlError); } catch (Exception ex) { Tripous.Sys.ErrorBox(ex); } db.Close(); } // //ask if the print was sucessfull DialogResult result = MessageBox.Show(" Is Receipt Printing Successful ?", Program.ApplicationName, MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { try { SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); //update the collection table by seting the isprinted to true using (SqlConnection db = new SqlConnection(Logic.ConnectionString)) { SqlTransaction transaction; db.Open(); transaction = db.BeginTransaction(); try { string query1 = String.Format("UPDATE Receipt.tblCollectionReceipt SET isPrinted=1,IsPrintedDate= '{0:MM/dd/yyyy HH:mm:ss tt}',PrintedBY='{1}',StationCode='{2}' WHERE PaymentRefNumber IN ({3})", DateTime.Now, Program.UserID, Program.stationCode, values); using (SqlCommand sqlCommand = new SqlCommand(query1, db, transaction)) { sqlCommand.ExecuteNonQuery(); } } catch (Exception ex) { transaction.Rollback(); Tripous.Sys.ErrorBox(ex); return; } transaction.Commit(); db.Close(); } } finally { SplashScreenManager.CloseForm(false); } } else { try { SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); using (SqlConnection db = new SqlConnection(Logic.ConnectionString)) { SqlTransaction transaction; db.Open(); transaction = db.BeginTransaction(); try { string query1 = String.Format("DELETE FROM Receipt.tblCollectionReceipt WHERE PaymentRefNumber IN (SELECT PaymentRefNumber FROM Receipt.tblReceipt WHERE PaymentRefNumber in ({0})", values); using (SqlCommand sqlCommand = new SqlCommand(query1, db, transaction)) { sqlCommand.ExecuteNonQuery(); } string query = String.Format("DELETE FROM Receipt.tblReceipt where PaymentRefNumber in ({0})", values); using (SqlCommand sqlCommand1 = new SqlCommand(query, db, transaction)) { sqlCommand1.ExecuteNonQuery(); } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); Tripous.Sys.ErrorBox(ex); return; } db.Close(); } } finally { SplashScreenManager.CloseForm(false); } return; } } else { if (String.Compare(response.Tables[0].Rows[0]["returnCode"].ToString(), "-1", false) == 0) { Common.setMessageBox(response.Tables[0].Rows[0]["returnMessage"].ToString(), "", 2); //return; if (response.Tables[0].Rows[0]["returnMessage"].ToString() != "Payment Ref. Number Already Exist") { //using (Frmcontrol frmcontrol = new Frmcontrol()) //{ // frmcontrol.gridControl1.DataSource = response.Tables[1]; // frmcontrol.gridView1.BestFitColumns(); // frmcontrol.label1.Text = "Payment Ref. Number Already been used"; // frmcontrol.Text = "Payment Ref. Number Already been used"; // frmcontrol.ShowDialog(); //} return; } else { using (Frmcontrol frmcontrol = new Frmcontrol()) { frmcontrol.gridControl1.DataSource = response.Tables[1]; frmcontrol.gridView1.BestFitColumns(); frmcontrol.label1.Text = "Payment Ref. Number Already been used"; frmcontrol.Text = "Payment Ref. Number Already been used"; frmcontrol.ShowDialog(); } } } else { Common.setMessageBox(response.Tables[0].Rows[0]["returnMessage"].ToString(), "", 2); return; } } } } }