void btnUpdate_Click(object sender, EventArgs e) { if (selection.SelectedCount == 0) { Common.setMessageBox("No Selection Made for Printing of Receipts", Program.ApplicationName, 3); return; } else if (selection2.SelectedCount == 0) { Common.setMessageBox("No Selection Made for Printing of Receipts", Program.ApplicationName, 3); return; } else if (selection.SelectedCount != selection.SelectedCount) { Common.setMessageBox("Number of Delist Transaction Record not equall", Program.ApplicationName, 3); return; } else { for (int i = 0; i < selection.SelectedCount; i++) { for (int j = 0; j < selection2.SelectedCount; j++) { string _values = String.Format("'{0}'", (selection.GetSelectedRow(i) as DataRowView)["Amount"]); string _values2 = string.Format("'{0}'", (selection2.GetSelectedRow(j) as DataRowView)["Amount"]); if (_values.CompareTo(_values2) == 0) { ///add code here for true temTable.Rows.Add(new object[] { j, String.Format("{0}", (selection2.GetSelectedRow(j) as DataRowView)["PaymentRefNumber"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["PaymentRefNumber"]), Program.UserID }); } else { Common.setMessageBox("Selected Amount Not Equall", Program.ApplicationName, 3); return; } } } if (temTable != null && temTable.Rows.Count > 0) { dataSet = new DataSet("table"); dataSet.Tables.Add(temTable); switch (Program.intCode) { case 13: //Akwa Ibom state using (var receiptAka = new CentralAkwa.CollectionManager()) { dts = receiptAka.DelistUpdate(dataSet); } using (var tempState = new StateAkwa.CollectionManager()) { dts2 = tempState.DelistUpdate(dataSet); } break; case 20: //Delta state using (var tempCentral = new CentralDetla.CollectionManager()) { dts = tempCentral.DelistUpdate(dataSet); } using (var tempState = new StateDelta.CollectionManager()) { dts2 = tempState.DelistUpdate(dataSet); } break; case 32: //kogi state //using (var receiptservic = new Kogireceiptservice.ReceiptService()) //{ // dataSet = receiptservic.DownloadDataCentral(Program.stateCode); //} //break; case 37: //ogun state using (var receiptsserv = new Centralogun.CollectionManager()) { dts = receiptsserv.DelistUpdate(dataSet); } using (var tempState = new StateOgun.CollectionManager()) { dts2 = tempState.DelistUpdate(dataSet); } break; case 40: //oyo state using (var receiptsServices = new Centraloyo.CollectionManager()) { dts = receiptsServices.DelistUpdate(dataSet); } using (var tempState = new StateOyo.CollectionManager()) { dts2 = tempState.DelistUpdate(dataSet); } break; default: break; } } //get return //dataSet2.Tables[0].Rows[0]["returnCode"].ToString() == "-1" if (dts.Tables[0].Rows[0]["returnCode"].ToString() == "00" && dts2.Tables[0].Rows[0]["returnCode"].ToString() == "00") { //insert record local after delist from online using (SqlConnection connect = new SqlConnection(Logic.ConnectionString)) { //gridControl1.DataSource = null; connect.Open(); _command = new SqlCommand("InsertDelist", connect) { CommandType = CommandType.StoredProcedure }; _command.Parameters.Add(new SqlParameter("@DelistTemp", SqlDbType.Structured)).Value = temTable; _command.CommandTimeout = 0; using (System.Data.DataSet ds = new System.Data.DataSet()) { adp = new SqlDataAdapter(_command); adp.Fill(ds, "ViewUnsweptTransaction"); //Dts = ds.Tables[0]; connect.Close(); if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "00") { Common.setMessageBox(string.Format("{0}", dts.Tables[0].Rows[0]["returnMessage"]), Program.ApplicationName, 1); gridControl1.DataSource = null; gridControl2.DataSource = null; } else { Tripous.Sys.ErrorBox(String.Format("{0}{1}", ds.Tables[0].Rows[0]["returnCode"].ToString(), ds.Tables[0].Rows[0]["returnMessage"].ToString())); return; } } } } else { Common.setMessageBox(string.Format("{0}...Error Occur During Delist Transaction", dts.Tables[0].Rows[0]["returnMessage"]), Program.ApplicationName, 3); return; } } }
void btnGet_Click(object sender, EventArgs e) { try { SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false); dts = new System.Data.DataSet(); dts.Clear(); switch (Program.intCode) { case 13: //Akwa Ibom state using (var receiptAka = new CentralAkwa.CollectionManager()) { dts = receiptAka.DelistFetch(txtSearch.Text.Trim().ToString()); } break; case 20: //Delta state using (var receiptservic = new CentralDetla.CollectionManager()) { dts = receiptservic.DelistFetch(txtSearch.Text.Trim().ToString()); } break; case 32: //kogi state //using (var receiptservic = new Kogireceiptservice.ReceiptService()) //{ // dataSet = receiptservic.DownloadDataCentral(Program.stateCode); //} //break; case 37: //ogun state using (var receiptsserv = new Centralogun.CollectionManager()) { dts = receiptsserv.DelistFetch(txtSearch.Text.Trim().ToString()); } break; case 40: //oyo state using (var receiptsServices = new Centraloyo.CollectionManager()) { dts = receiptsServices.DelistFetch(txtSearch.Text.Trim().ToString()); } break; default: break; } if (dts.Tables[0].Rows[0]["returnCode"].ToString() == "00") { if (dts.Tables[1] != null && dts.Tables[1].Rows.Count > 0) { gridControl2.DataSource = dts.Tables[1]; gridView2.Columns["Provider"].Visible = false; gridView2.Columns["Channel"].Visible = false; gridView2.Columns["DepositSlipNumber"].Visible = false; gridView2.Columns["PaymentMethod"].Visible = false; gridView2.Columns["AgencyName"].Visible = false; gridView2.Columns["AgencyCode"].Visible = false; gridView2.Columns["BankCode"].Visible = false; gridView2.Columns["BankName"].Visible = false; gridView2.Columns["BranchCode"].Visible = false; gridView2.Columns["BranchName"].Visible = false; gridView2.Columns["ReceiptNo"].Visible = false; gridView2.Columns["ReceiptDate"].Visible = false; gridView2.Columns["TelephoneNumber"].Visible = false; gridView2.Columns["AmountWords"].Visible = false; gridView2.Columns["RevenueCode"].Visible = false; gridView2.Columns["RevenueName"].Visible = false; gridView2.Columns["ChequeNumber"].Visible = false; gridView2.Columns["ChequeValueDate"].Visible = false; gridView2.Columns["ChequeBankCodeListID"].Visible = false; gridView2.Columns["ChequeBankCodeName"].Visible = false; gridView2.Columns["ChequeStatus"].Visible = false; gridView2.Columns["DateChequeReturned"].Visible = false; gridView2.Columns["TownName"].Visible = false; gridView2.Columns["PaymentMethod"].Visible = false; gridView2.Columns["PayerAddress"].Visible = false; gridView2.Columns["PayerName"].Visible = false; gridView2.Columns["PayerID"].Visible = false; gridView2.Columns["EReceipts"].Visible = false; gridView2.Columns["EReceiptsDate"].Visible = false; gridView2.Columns["GeneratedBy"].Visible = false; gridView2.Columns["ControlNumber"].Visible = false; gridView2.Columns["Status"].Visible = false; gridView2.Columns["PrintedDate"].Visible = false; gridView2.Columns["PrintedBy"].Visible = false; gridView2.Columns["StationCode"].Visible = false; gridView2.Columns["PayerAddress"].Visible = false; gridView2.Columns["TownListID"].Visible = false; gridView2.Columns["ICMAeReceipts"].Visible = false; gridView2.Columns["PostedBy"].Visible = false; gridView2.Columns["ReceiptDownloadStatus"].Visible = false; gridView2.Columns["Amount"].DisplayFormat.FormatType = FormatType.Numeric; gridView2.Columns["Amount"].DisplayFormat.FormatString = "n2"; gridView2.Columns["PaymentDate"].DisplayFormat.FormatType = FormatType.DateTime; gridView2.Columns["PaymentDate"].DisplayFormat.FormatString = "dd/MM/yyyy"; if (isSeconGrid) { selection2 = new GridCheckMarksSelection(gridView2, ref lblSelect2); selection2.CheckMarkColumn.VisibleIndex = 0; isSeconGrid = false; } } } } catch (Exception ex) { Tripous.Sys.ErrorBox(ex.Message + ex.StackTrace.ToString(), Program.ApplicationName); return; } finally { SplashScreenManager.CloseForm(false); } }