private void SbnUpdate_Click(object sender, EventArgs e)
{
try
{
SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false);
switch (Program.intCode)
{
case 13: //Akwa Ibom state
break;
case 20: //Delta state
using (var reconcilation = new CentralDetla.CollectionManager())
{
dts = reconcilation.ReconcilliationReclassificationCheckApproved(dtsoff);
}
break;
case 32: //kogi state
break;
case 37: //ogun state
using (var receiptsserv = new Centralogun.CollectionManager())
{
dts = receiptsserv.ReconcilliationReclassificationCheckApproved(dtsoff);
}
break;
case 40: //oyo state
using (var reconciliationoyo = new Centraloyo.CollectionManager())
{
dts = reconciliationoyo.ReconcilliationReclassificationCheckApproved(dtsoff);
}
break;
default:
break;
}
if (dts != null)
{
//tableTrans = new DataTable();
foreach (DataRow dr in dts.Tables[0].Rows)
{
for (int rowHandle = 0; rowHandle < gridView1.RowCount; rowHandle++)
{
var periodID = gridView1.GetRowCellValue(rowHandle, gridView1.Columns["ID"]);
if (Convert.ToInt32(dr["OfflineUniqueID"].ToString()) == Convert.ToInt32(periodID.ToString()))
{
bool?approvalStatus = null;
if (dr["isApproved"] != null && dr["isApproved"] != DBNull.Value)
{
approvalStatus = Convert.ToBoolean(dr["isApproved"]);
}
if (approvalStatus == null)
{
gridView1.SetRowCellValue(rowHandle, gridView1.Columns["Status"], "Awaiting Approval");
}
else if (approvalStatus == true)
{
gridView1.SetRowCellValue(rowHandle, gridView1.Columns["Status"], "Approved");
//get approved offlineid
tableTrans.Rows.Add(new object[] { Convert.ToInt32(dr["OfflineUniqueID"].ToString()), dr["ApprovedBY"].ToString(), Convert.ToDateTime(dr["ApprovedDate"]) });
}
else if (approvalStatus == false)
{
gridView1.SetRowCellValue(rowHandle, gridView1.Columns["Status"], "Disapproved");
}
}
}
}
}
//check for approved record before processing
if (tableTrans != null && tableTrans.Rows.Count > 0)
{
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("doReclassifiedProcess", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@pTransaction", SqlDbType.Structured)).Value = tableTrans;
_command.Parameters.Add(new SqlParameter("@userid", SqlDbType.VarChar)).Value = Program.UserID;
_command.CommandTimeout = 0;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() != "00")
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
return;
}
else
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
using (FrmReclassifiedResult frmreport = new FrmReclassifiedResult(ds))
{
frmreport.ShowDialog();
}
}
}
}
}
else
{
Common.setMessageBox("No Approved Record Found to Reclassified!", "Reclassification", 2); return;
}
}
catch (Exception ex)
{
Tripous.Sys.ErrorBox(ex.Message); return;
}
finally
{
SplashScreenManager.CloseForm(false);
}
}
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);
}
}
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 Processwork()
{
DataSet dataSet = new DataSet();
dts = new System.Data.DataSet();
dts.Clear();
if (string.IsNullOrEmpty(selection.SelectedCount.ToString()) || selection.SelectedCount == 0)
{
Common.setMessageBox("No Record selected", "Reclassification", 1); return;
}
string str = string.Format("Do you really want to Approve this ({0}) number(s) of Reclassified Transaction", selection.SelectedCount);
DialogResult results = MessageBox.Show(str, Program.ApplicationName, MessageBoxButtons.YesNo);
if (results == DialogResult.Yes)
{
for (int i = 0; i < selection.SelectedCount; i++)
{
tableTrans.Rows.Add(new object[] { (selection.GetSelectedRow(i) as DataRowView)["ID"], (selection.GetSelectedRow(i) as DataRowView)["BSID"], (selection.GetSelectedRow(i) as DataRowView)["TransID"] });
}
try
{
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("dogetReclassifiedInforequest", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@pTransaction", SqlDbType.Structured)).Value = tableTrans;
_command.Parameters.Add(new SqlParameter("@userid", SqlDbType.VarChar)).Value = Program.UserID;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
if (ds != null || ds.Tables[0].Rows.Count > 0)
{
switch (Program.intCode)
{
case 13: //Akwa Ibom state
break;
case 20: //Delta state
using (var reconcilation = new CentralDetla.CollectionManager())
{
dts = reconcilation.ReconcilliationReclassificationRequests(ds);
}
break;
case 32: //kogi state
break;
case 37: //ogun state
//var receiptsserv = /*new Centralogun.CollectionManager*/
using (var receiptsserv = new Centralogun.CollectionManager())
{
dts = receiptsserv.ReconcilliationReclassificationRequests(ds);
}
break;
case 40: //oyo state
using (var reconciliationoyo = new Centraloyo.CollectionManager())
{
dts = reconciliationoyo.ReconcilliationReclassificationRequests(ds);
}
break;
default:
break;
}
if (dts.Tables[0].Rows[0]["returnCode"].ToString() == "00")
{
//using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
//{
if (ds.Tables[0].Columns.Contains("Narration"))
{
ds.Tables[0].Columns.Remove("Narration");
}
connect.Open();
_command = new SqlCommand("ReclassifiedTransactionLogRequest", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@pTransaction", SqlDbType.Structured)).Value = ds.Tables[0];
_command.Parameters.Add(new SqlParameter("@userid", SqlDbType.VarChar)).Value = Program.UserID;
using (System.Data.DataSet ds1 = new System.Data.DataSet())
{
ds1.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds1);
connect.Close();
if (ds1.Tables[0].Rows[0]["returnCode"].ToString() != "00")
{
Common.setMessageBox(ds1.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
return;
}
else
{
Common.setMessageBox(ds1.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
setReload();
return;
}
}
//}
}
else
{
Tripous.Sys.ErrorBox(String.Format("{0}", dts.Tables[0].Rows[0]["returnMessage"].ToString()));
return;
}
}
else
{
return;
}
}
}
}
catch (Exception ex)
{
Tripous.Sys.ErrorBox(String.Format("{0}{1}", ex.Message, ex.StackTrace)); return;
}
}
}
