void bttnUpdate_Click(object sender, EventArgs e)
{
if (selection.SelectedCount < 1)
{
Common.setMessageBox("Please, select record to Map", Program.ApplicationName, 3);
}
else if (cboStation.SelectedIndex < 0)
{
Common.setMessageBox("Please, select Station to Map", Program.ApplicationName, 3);
}
else
{
//return;
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
SqlCommand sqlCommand1;
db.Open();
transaction = db.BeginTransaction();
try
{
for (int i = 0; i < selection.SelectedCount; i++)
{
//using (var ds = new System.Data.DataSet())
//{//select record
//BranchCode,BankShortCode
string lol = ((selection.GetSelectedRow(i) as DataRowView)["BranchCode"].ToString());
string lol2 = ((selection.GetSelectedRow(i) as DataRowView)["BankShortCode"].ToString());
string query = String.Format("INSERT INTO [tblStationMap]([StationCode],[StationName],[RevenueOfficeCode],[RevenueOfficeName]) VALUES ('{0}','{1}','{2}','{3}')", cboStation.SelectedValue.ToString(), cboStation.Text, lol, lol2);
sqlCommand1 = new SqlCommand(query, db, transaction);
sqlCommand1.ExecuteNonQuery();
}
//call report for Print
transaction.Commit();
//ReceiptCall();
}
catch (SqlException sqlError)
{
transaction.Rollback();
}
db.Close();
setReload();
cboStation.SelectedIndex = -1;
Common.setMessageBox("Record has been successfully added", Program.ApplicationName, 1);
selection.ClearSelection();
}
}
}
private void SbnDisapprove_Click(object sender, EventArgs e)
{
string value = string.Empty;
if (DialogResults.InputBox(@"Comments for Disapproving ", "Ministry Disapproval", ref value) == DialogResult.OK)
{
if (!string.IsNullOrWhiteSpace(value))
{
for (int i = 0; i < selection.SelectedCount; i++)
{
tableTrans.Rows.Add(new object[] { (selection.GetSelectedRow(i) as DataRowView)["Period"], (selection.GetSelectedRow(i) as DataRowView)["Narriation"], Convert.ToInt32((selection.GetSelectedRow(i) as DataRowView)["BankAccountID"]), Convert.ToInt32((selection.GetSelectedRow(i) as DataRowView)["SummaryID"]), Convert.ToInt32((selection.GetSelectedRow(i) as DataRowView)["FinancialperiodID"]), (selection.GetSelectedRow(i) as DataRowView)["AgencyCode"], (selection.GetSelectedRow(i) as DataRowView)["RevenueCode"],
(selection.GetSelectedRow(i) as DataRowView)["Description"], (selection.GetSelectedRow(i) as DataRowView)["AgencyName"], Convert.ToDecimal((selection.GetSelectedRow(i) as DataRowView)["Amount"]) });
}
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("Reconciliation.DisapprovalMinistrySummary", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@pTransactiondb", SqlDbType.Structured)).Value = tableTrans;
_command.Parameters.Add(new SqlParameter("@Userid", SqlDbType.VarChar)).Value = Program.UserID;
_command.Parameters.Add(new SqlParameter("@comment", SqlDbType.VarChar)).Value = value;
_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);
//FrmReportPosting report = new FrmReportPosting(ds.Tables[1], ds.Tables[2]);
//using (FrmReportPosting frmreport = new FrmReportPosting(ds))
}
}
}
}
else
{
Common.setMessageBox("Disapproval Comment is Empty", "Ministry Disapproval", 3);
return;
}
setReload();
}
}
void strProcess()
{
gridControl1.DataSource = string.Empty;
//clear dt2 tabale
dt2.Clear();
for (int i = 0; i < selection.SelectedCount; i++)
{
dt2.Rows.Add(new object[] { (string)(selection.GetSelectedRow(i) as DataRowView)["PaymentRefNumber"], (string)(selection.GetSelectedRow(i) as DataRowView)["PaymentDate"], Convert.ToDouble((selection.GetSelectedRow(i) as DataRowView)["Amount"]) });
}
DataTable dtChange = getChanges(dt, dt2);
if (dtChange != null)
{
gridControl1.DataSource = dtChange.DefaultView;
gridView1.OptionsBehavior.Editable = false;
gridView1.Columns["Amount"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
gridView1.Columns["Amount"].DisplayFormat.FormatString = "n2";
gridView1.Columns["PaymentRefNumber"].Visible = false;
gridView1.BestFitColumns();
gridView1.Columns["Amount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridView1.Columns["Amount"].SummaryItem.FieldName = "Amount";
gridView1.Columns["Amount"].SummaryItem.DisplayFormat = "Total Amount = {0:n}";
gridView1.OptionsView.ShowFooter = true;
}
}
private void SpbAdd_Click(object sender, EventArgs e)
{
if (selection.SelectedCount == 0)
{
Common.setMessageBox("No Selection Made to Merge", Program.ApplicationName, 3);
return;
}
else
{
for (int i = 0; i < selection.SelectedCount; i++)
{
temTable.Rows.Add(new object[] { String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["UTIN"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["OrganizationName"]) });
}
if (temTable != null && temTable.Rows.Count > 0)
{
gridControl2.DataSource = temTable;
gridView2.Columns["UTIN"].OptionsColumn.AllowEdit = false;
gridView2.Columns["OrganizationName"].OptionsColumn.AllowEdit = false;
gridView2.BestFitColumns();
selection.ClearSelection();
}
//_Helper = new GridRadioGroupColumnHelper(gridView2);
}
}
string GetPayRef()
{
string values = string.Empty;
lblSelect.Text = string.Empty;
int j = 0;
using (WaitDialogForm form = new WaitDialogForm("Application Working...,Please Wait...", "Processing Your Request"))
{
for (int i = 0; i < selection.SelectedCount; i++)
{
//string lol = ((selection.GetSelectedRow(i) as DataRowView)["PaymentRefNumber"].ToString());
values += String.Format("'{0}'", (selection.GetSelectedRow(i) as DataRowView)["PaymentRefNumber"]);
if (j + 1 < selection.SelectedCount)
{
values += ",";
}
++j;
//insert record into tblreceipt for processing
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
db.Open();
transaction = db.BeginTransaction();
try
{
string querys =
String.Format(
"INSERT INTO [tblReceipt]([PaymentRefNumber],[ReceiptNo],[DateSent],[SentBy],[AgencyCode] ,[AgencyName],[RevenueCode],[Description],[DepositSlipNumber],[PaymentDate],[PayerID],[PayerName],[Amount],GeneratedBy,[BankName],[BranchName],StationCode) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}');", String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["PaymentRefNumber"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["EReceipts"]), DateTime.Now, Program.UserID, String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["AgencyCode"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["AgencyName"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["RevenueCode"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["Description"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["DepositSlipNumber"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["PaymentDate"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["PayerID"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["PayerName"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["Amount"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["GeneratedBy"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["BankName"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["BranchName"]), Program.stationCode);
using (SqlCommand sqlCommand2 = new SqlCommand(querys, db, transaction))
{
sqlCommand2.ExecuteNonQuery();
}
transaction.Commit();
}
catch (Exception ex)
{
Tripous.Sys.ErrorBox(ex);
transaction.Rollback();
//return;
}
db.Close();
}
}
}
return(values);
}
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)["Payment Ref. Number"]), Program.UserID });
}
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("ArmsReceiptsMoved", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@pTransaction", SqlDbType.Structured)).Value = temTable;
_command.CommandTimeout = 0;
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)
{
Common.setMessageBox(response.Tables[0].Rows[0]["returnmessage"].ToString(), Program.ApplicationName, 1);
if (response.Tables[1] != null || response.Tables[1].Rows.Count > 0)
{
using (FrmArmsDisplay display = new FrmArmsDisplay(response, true)
{
FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog
})
{
display.ShowDialog();
}
}
}
else
{
Common.setMessageBox(response.Tables[0].Rows[0]["returnmessage"].ToString(), Program.ApplicationName, 1);
return;
}
}
}
void EnableClick()
{
_dtb.Columns.Add("UserID", typeof(string));//give the datatable a structure, in this case, it has only two columns
_dtb.Columns.Add("LoginStatusListID", typeof(Int64));
for (int i = 0; i < selection.SelectedCount; i++)
{
string lol = ((selection.GetSelectedRow(i) as DataRowView)["UserListID"].ToString());
object[] data = { lol, 1 };//2 means disable and 1 means enable
//Dtt.Rows.Add(new object[] { filename, image });
//_dtb.Rows.Add(new object[] { lol, 1 });//2 means disable and 1 means enable
_dtb.Rows.Add(data);
}
retval = EasyServices.DoEnableDisables(_dtb, 4);
_ds = (DataSet)retval;
}
//show selected
private void button1_Click(object sender, System.EventArgs e)
{
string s = "";
for (int i = 0; i < selection.SelectedCount; i++)
{
s += (selection.GetSelectedRow(i) as NameValue).Name + "\n";
}
MessageBox.Show(s, "Selected count: " + selection.SelectedCount.ToString());
}
private void btnNormalize_Click(object sender, EventArgs e)
{
string agentid = string.Empty;
agentid = this.cboTaxAgent.SelectedValue.ToString();
for (int i = 0; i < selection.SelectedCount; i++)
{
string lol = ((selection.GetSelectedRow(i) as DataRowView)["Payment Ref. Number"].ToString());
//MessageBox.Show(lol);
query = String.Format("UPDATE tblCollectionReport SET [Payer ID]='{0}' Where [Payment Ref. Number]='{1}'", agentid, lol);
retval = extMethods.getQuery("INSERT", query);
}
}
void btnUpdate_Click(object sender, EventArgs e)
{
temTable.Clear();
//tableTrans.Rows.Add(new object[] { txtDateds.Text, ElemDescr, 0, txtDepositAmt.Text });
for (int i = 0; i < selection.SelectedCount; i++)
{
//temTable.Rows.Add(new object[] { String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["BSID"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["DefinitionID"]) });
temTable.Rows.Add(new object[] { String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["BSID"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["Description"]) });
}
try
{
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("doSwepTransaction", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@pTransactiondb", SqlDbType.Structured)).Value = temTable;
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
//Dts = ds.Tables[0];
connect.Close();
if (ds.Tables[0].Rows[0]["returnCode"].ToString() != "00")
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 3);
}
else
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 1);
}
}
}
}
catch (Exception ex)
{
Tripous.Sys.ErrorBox(String.Format("{0}{1}Allocating", ex.StackTrace, ex.Message)); return;
}
}
private void btnSelect_Click(object sender, EventArgs e)
{
if (this.check.SelectedCount > 0)
{
for (int i = 0; i < check.SelectedCount; i++)
{
this.resultList.Add((Role)check.GetSelectedRow(i));
}
this.DialogResult = DialogResult.OK;
}
else
{
//MessageBox.Show("PLEASE SELECT LABEL TO PRINT", "WARNING", MessageBoxButtons.OK, MessageBoxIcon.Warning);
XtraMessageBox.Show(this, "PLEASE SELECT ROLE", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1);
}
}
private void btnSelect_Click(object sender, EventArgs e)
{
if (this.check.SelectedCount > 0)
{
if (this._PRODUCT_LIST == null)
{
this._PRODUCT_LIST = new List <Product>();
}
for (int i = 0; i < check.SelectedCount; i++)
{
this._PRODUCT_LIST.Add((Product)check.GetSelectedRow(i));
}
this.DialogResult = DialogResult.OK;
}
else
{
XtraMessageBox.Show(this, "PLEASE SELECT PRODUCT", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1);
}
}
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 btnPrint_Click(object sender, EventArgs e)
{
PrintType = "Original";
if (Program.stateCode == "20")
{
Url = "www.deltabir.com";
}
else if (Program.stateCode == "13")
{
Url = "www.Akwaibomrevenue.com";
}
else if (Program.stateCode == "37")
{
Url = "www.ogunbir.com";
}
else if (Program.stateCode == "40")
{
Url = "www.oyobir.com";
}
if (selection.SelectedCount == 0)
{
Common.setMessageBox("Please Check Records to Print", Program.ApplicationName, 1);
return;
}
else
{
EmptyBankReceipts();
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
db.Open();
transaction = db.BeginTransaction();
try
{
for (int i = 0; i < selection.SelectedCount; i++)
{
using (var ds = new System.Data.DataSet())
{//select record
string lol = ((selection.GetSelectedRow(i) as DataRowView)["PaymentRefNumber"].ToString());
query = String.Format("SELECT [PaymentRefNumber],[DepositSlipNumber],[PaymentDate],[PayerID],[PayerName] ,[RevenueCode] ,[Description] ,[Amount] ,[PaymentMethod] ,[AgencyName] , [BankName] ,[BranchName] ,[EReceipts] ,[PayerAddress],StationName,ZoneName FROM dbo.tblCollectionReport WHERE ([PaymentDate] >= '{0}' AND [PaymentDate] <= '{1}') and EReceipts IS NOT NULL AND [PaymentRefNumber]= '{2}'", dtpfrom.Value.Date.ToString("yyyy-MM-dd"), dtpTo.Value.Date.ToString("yyyy-MM-dd"), lol);
using (SqlDataAdapter ada = new SqlDataAdapter(query, Logic.ConnectionString))
{
ada.Fill(ds, "table");
}
Dt = ds.Tables[0];
}
//insert record into bankreceipt table
foreach (DataRow item in Dt.Rows)
{
if (item["PayerID"].ToString().Length > 14)
{
payerid = "Please approach the BIR for your unique Payer ID.";
}
else
{
payerid = item["PayerID"].ToString();
}
amount = amounttowords.convertToWords(item["Amount"].ToString());
//if (item.Rows[0]["PlateCode"].length)
//payerid
//amount
//try
//{
string desc = Regex.Replace(item["Description"].ToString(), @"[']", "");
string query2 = String.Format("INSERT INTO [BankReceipts]([PaymenRefNumber],[DepositSlipNumber],[PaymentDate],[PayerID],[PayerName] ,[RevenueCode] ,[Description] ,[Amount] ,[PaymentMethod] ,[AgencyName] ,[BankName] ,[BranchName] ,[ReceiptNumber] ,[PayerAddress],[PrintType],[URL],[AmountWords],[Users],StationName,TaxOffice) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}', '{14}','{15}','{16}','{17}' ,'{18}','{19}')", item["PaymentRefNumber"].ToString(), item["DepositSlipNumber"].ToString(), item["PaymentDate"].ToString(), payerid, item["PayerName"].ToString(), item["RevenueCode"].ToString(), desc, item["Amount"].ToString(), item["PaymentMethod"].ToString(), item["AgencyName"].ToString(), item["BankName"].ToString(), item["BranchName"].ToString(), item["EReceipts"].ToString(), item["PayerAddress"].ToString(), PrintType, Url, amount, user, item["StationName"].ToString(), item["ZoneName"].ToString());
using (SqlCommand sqlCommand1 = new SqlCommand(query2, db, transaction))
{
sqlCommand1.ExecuteNonQuery();
}
//}
//catch (Exception ex)
//{
// Common.setMessageBox(ex.StackTrace.ToString(), Program.ApplicationName, 3);
// return;
//}
}
}
transaction.Commit();
//call report for Print
ReceiptCall();
btnMain.Enabled = true;
btnPrint.Enabled = false;
}
catch (SqlException sqlError)
{
transaction.Rollback();
}
db.Close();
}
}
}
void Processwork()
{
if (string.IsNullOrEmpty(selection.SelectedCount.ToString()) || selection.SelectedCount == 0)
{
Common.setMessageBox("No Record selected", "Receipt Reprint Approval", 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"] });
switch (Program.intCode)
{
//case 13://Akwa Ibom state
// using (var receiptAka = new AkwaIbomReceiptServices.ReceiptService())
// {
// dsreturn = receiptAka.LogReceiptsReprintRequest(String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["EReceipts"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["PaymentRefNumber"]), null, Program.UserID, String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["Comment"]), "NONE", null, null, null, null, null, null, Program.stationCode);
// }
// break;
case 20: //Delta state
using (var receiptDelta = new DeltaBir.ReceiptService())
{
dsreturn = receiptDelta.LogReceiptsReprintRequest(String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["EReceipts"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["PaymentRefNumber"]), null, Program.UserID, String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["Comment"]), "NONE", null, null, null, null, null, null, Program.stationCode);
}
break;
case 32: //kogi state
break;
case 37: //ogun state
//using (var receiptsserv = new ReceiptService())
//{
// dsreturn = receiptsserv.LogReceiptsReprintRequest(String.Format("{0}", row["EReceipts"]), String.Format("{0}", row["PaymentRefNumber"]), null, Program.UserID, txtReason.Text, "NONE", null, null, null, null, null, null, Program.stationCode);
//}
//break;
case 40: //oyo state
//using (var receiptsServices = new OyoReceiptServices.ReceiptService())
//{
// dsreturn = receiptsServices.LogReceiptsReprintRequest(String.Format("{0}", row["EReceipts"]), String.Format("{0}", row["PaymentRefNumber"]), null, Program.UserID, txtReason.Text, "NONE", null, null, null, null, null, null, Program.stationCode);
//}
//break;
default:
break;
}
if (dsreturn.Tables[0].Rows[0]["returnCode"].ToString() == "-1")
{
Common.setMessageBox(dsreturn.Tables[0].Rows[0]["returnmessage"].ToString(), Program.ApplicationName, 1);
return;
}
else
{
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
db.Open();
transaction = db.BeginTransaction();
try
{
string query1 = String.Format("UPDATE Receipt.tblReprintedReceipts SET FirstApprovalStatus = '{0}',FirstApprovalBy = '{1}', FirstApprovalDate = '{2}' WHERE PaymentRefNumber IN('{3}')", 1, Program.UserName, string.Format("{0:yyyy/MM/dd hh:mm:ss}", DateTime.Now), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["PaymentRefNumber"]));
using (SqlCommand sqlCommand = new SqlCommand(query1, db, transaction))
{
sqlCommand.ExecuteNonQuery();
}
}
catch (Exception ex)
{
transaction.Rollback();
Tripous.Sys.ErrorBox(ex);
return;
}
transaction.Commit();
db.Close();
}
}
}
///
Common.setMessageBox("Request Sent for Approval,Please Click on Get Approval Record, if your Admin has approve the record....", Program.ApplicationName, 1);
return;
}
else
{
return;
}
}
private void SbnDisapprove_Click(object sender, EventArgs e)
{
string value = string.Empty;
if (DialogResults.InputBox(@"Comments for Disapproving ", "Reclassification", ref value) == DialogResult.OK)
{
//value = String.Format("{0:N2}", Convert.ToDecimal(value));
if (!string.IsNullOrWhiteSpace(value))
{
if (string.IsNullOrEmpty(selection.SelectedCount.ToString()) || selection.SelectedCount == 0)
{
Common.setMessageBox("No Record selected", "Reclassification", 1); return;
}
else
{
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"] });
}
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("doReclassifiedRequestDisapproved", 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.Parameters.Add(new SqlParameter("@comment", SqlDbType.VarChar)).Value = value;
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);
setReload();
return;
}
else
{
Tripous.Sys.ErrorBox(String.Format("{0}", ds.Tables[0].Rows[0]["returnMessage"].ToString()));
return;
}
}
}
}
}
else
{
Common.setMessageBox("Disapproval Comment is Empty", "Reclassification", 3);
return;
}
}
}
void bttnUpdate_Click(object sender, EventArgs e)
{
//tblPrintingRevenueCode
if (selection.SelectedCount < 1)
{
Common.setMessageBox("Please, select revenue code ", Program.ApplicationName, 3); return;
}
else
{
//delete record from the database table
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
SqlCommand sqlCommand1;
db.Open();
transaction = db.BeginTransaction();
try
{
sqlCommand1 = new SqlCommand("DELETE FROM tblPrintingRevenueCode", db, transaction);
sqlCommand1.ExecuteNonQuery();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
Tripous.Sys.ErrorBox(ex);
return;
}
db.Close();
}
//insert new record into the database
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
SqlCommand sqlCommand1;
db.Open();
transaction = db.BeginTransaction();
for (int i = 0; i < selection.SelectedCount; i++)
{
string lol = ((selection.GetSelectedRow(i) as DataRowView)["RevenueCode"].ToString());
string query = String.Format("INSERT INTO [tblPrintingRevenueCode]([RevenueCode]) VALUES ('{0}')", lol);
sqlCommand1 = new SqlCommand(query, db, transaction);
sqlCommand1.ExecuteNonQuery();
}
transaction.Commit();
}
Common.setMessageBox(" Transaction Completed Successfully ", Program.ApplicationName, 1);
}
}
void bttnUpdate_Click(object sender, EventArgs e)
{
if (selection.SelectedCount > 1)
{
Common.setMessageBox("Only Revenue Temp can be Set up", "Default Revenue Set up", 1);
return;
}
else
{
if (!boolIsUpdate)
{
for (int i = 0; i < selection.SelectedCount; i++)
{
string values = string.Empty;
values += String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["RevenueCode"]);
string query = string.Format("INSERT INTO [Reconciliation].[tblRevenueTemp]([RevenueCode]) VALUES ('{0}');", values);
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
db.Open();
transaction = db.BeginTransaction();
try
{
using (SqlCommand sqlCommand1 = new SqlCommand(query, db, transaction))
{
sqlCommand1.ExecuteNonQuery();
}
transaction.Commit();
}
catch (SqlException sqlError)
{
transaction.Rollback(); Tripous.Sys.ErrorBox(sqlError);
return;
}
db.Close();
}
}
return;
}
for (int i = 0; i < selection.SelectedCount; i++)
{
string values = string.Empty;
values += String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["RevenueCode"]);
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
db.Open();
transaction = db.BeginTransaction();
try
{
string dry = String.Format(String.Format("UPDATE [Reconciliation].[tblRevenueTemp] SET [RevenueCode]='{{0}}' where RevenueCode ='{0}'", ID), values);
using (SqlCommand sqlCommand1 = new SqlCommand(dry, db, transaction))
{
sqlCommand1.ExecuteNonQuery();
}
transaction.Commit();
}
catch (SqlException sqlError)
{
transaction.Rollback(); Tripous.Sys.ErrorBox(sqlError);
return;
}
db.Close();
}
}
Common.setMessageBox("Record Update Successfully", Program.ApplicationName, 1);
return;
}
}
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 btnAllocate_Click(object sender, EventArgs e)
{
if (gridView1.SelectedRowsCount == 0)
{
Common.setMessageBox("Select Record to Close", "Close Period", 1); return;
}
else
{
//Common.setMessageBox("Sorry TransactionPosting Suspend for now!", "Close Period", 1);
//return;
try
{
SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false);
tableTrans.Clear();
if (string.IsNullOrEmpty(selection.SelectedCount.ToString()))
{
return;
}
for (int i = 0; i < selection.SelectedCount; i++)
{
bool chkUpdate = (bool)(selection.GetSelectedRow(i) as DataRowView)["IsApproved"];
//BankAccountID,PostingRequestID
if (chkUpdate)
{
tableTrans.Rows.Add(new object[] { (selection.GetSelectedRow(i) as DataRowView)["BankShortCode"], (selection.GetSelectedRow(i) as DataRowView)["FinancialperiodID"], (selection.GetSelectedRow(i) as DataRowView)["StartDate"], (selection.GetSelectedRow(i) as DataRowView)["EndDate"], (selection.GetSelectedRow(i) as DataRowView)["BankAccountID"], (selection.GetSelectedRow(i) as DataRowView)["PostingRequestID"], (selection.GetSelectedRow(i) as DataRowView)["ReconID"] });
}
}
if (tableTrans.Rows.Count <= 0)
{
Common.setMessageBox("No approved record is selected", "Close Period", 3);
return;
}
selection.ClearSelection();
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("PostingTransactionApprove", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@pTransactiondb", SqlDbType.Structured)).Value = tableTrans;
_command.Parameters.Add(new SqlParameter("@Userid", SqlDbType.VarChar)).Value = Program.UserID;
_command.CommandTimeout = 0;
//_command.Parameters.Add(new SqlParameter("@enddate", SqlDbType.VarChar)).Value = string.Format("{0:yyyy/MM/dd}", dtpEnd.Value);
//_command.Parameters.Add(new SqlParameter("@pType", SqlDbType.Bit)).Value = boolIsUpdate2;
//_command.Parameters.Add(new SqlParameter("@Batchcode", SqlDbType.Char)).Value = label22.Text;
//@Years
using (System.Data.DataSet ds = new System.Data.DataSet())
{
ds.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(ds);
connect.Close();
//&& ds.Tables[0].Rows[0]["returnCode"].ToString() != "01"
if (ds.Tables[0].Rows[0]["returnCode"].ToString() != "00" && ds.Tables[0].Rows[0]["returnCode"].ToString() != "01")
{
if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "-1")
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
return;
}
if (ds.Tables[0].Rows[0]["returnCode"].ToString() == "-2")
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
using (FrmReportPosting frmreport = new FrmReportPosting(ds))
{
frmreport.ShowDialog();
}
FrmRequest_Load(null, null);
//return;
}
}
else
{
Common.setMessageBox(ds.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
if (ds.Tables.Count > 1)
{ //FrmReportPosting report = new FrmReportPosting(ds.Tables[1], ds.Tables[2]);
using (FrmReportPosting frmreport = new FrmReportPosting(ds))
{
frmreport.ShowDialog();
}
}
FrmRequest_Load(null, null);
}
}
}
}
catch (Exception ex)
{
Tripous.Sys.ErrorBox(ex.Message); return;
}
finally
{
SplashScreenManager.CloseForm(false);
}
}
}
void Processwork()
{
System.Data.DataSet dataSet = new System.Data.DataSet();
dts = new System.Data.DataSet();
dts.Clear(); tableTrans.Clear();
if (string.IsNullOrEmpty(selection.SelectedCount.ToString()) || selection.SelectedCount == 0)
{
Common.setMessageBox("No Record selected", "Arms Payments", 1); return;
}
else
{
string str = string.Format("Do you really want to Approve this ({0}) number(s) of Arms Payments", 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)["PaymentRefNumber"], Program.UserID, });
}
}
try
{
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("ArmsApproval", 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);
doSending(ds);
////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;
}
}
}
}
catch (Exception ex)
{
Tripous.Sys.ErrorBox(String.Format("{0}{1}", ex.Message, ex.StackTrace)); return;
}
}
}
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 bttnUpdate_Click(object sender, EventArgs e)
{
//if (selection.SelectedCount < 1)
//{
// Common.setMessageBox("Please, select Revenue Code ", Program.ApplicationName, 3); return;
//}
//else
//{
//DELETE record from table by agancycode
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
SqlCommand sqlCommand1;
db.Open();
transaction = db.BeginTransaction();
string querys = String.Format("DELETE FROM Receipt.tblRevenueReceiptException WHERE AgencyCode='{0}'", cboAgency.SelectedValue);
sqlCommand1 = new SqlCommand(querys, db, transaction);
sqlCommand1.ExecuteNonQuery();
try
{
transaction.Commit();
db.Close();
}
catch (Exception ex)
{
transaction.Rollback();
Tripous.Sys.ErrorBox(ex);
return;
}
}
//insert new record into the database
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
SqlCommand sqlCommand1;
db.Open();
transaction = db.BeginTransaction();
for (int i = 0; i < selection.SelectedCount; i++)
{
string lol = ((selection.GetSelectedRow(i) as DataRowView)["RevenueCode"].ToString());
string query = String.Format("INSERT INTO Receipt.tblRevenueReceiptException ( RevenueCode,AgencyCode ) VALUES ('{0}','{1}')", lol, cboAgency.SelectedValue);
sqlCommand1 = new SqlCommand(query, db, transaction); sqlCommand1.ExecuteNonQuery();
}
transaction.Commit();
}
Common.setMessageBox(" Transaction Completed Successfully ", Program.ApplicationName, 1);
//}
}
void bttnUpdate_Click(object sender, EventArgs e)
{
if (selection.SelectedCount < 1)
{
Common.setMessageBox("Please, select revenue code to Map", Program.ApplicationName, 3); return;
}
else if (cboStation.SelectedIndex < 0)
{
Common.setMessageBox("Please, select Station to Map", Program.ApplicationName, 3); cboStation.Focus(); return;
}
else if (cboCentre.SelectedIndex < 0)
{
Common.setMessageBox("Please, select Printing Centre to Map", Program.ApplicationName, 3); cboCentre.Focus(); return;
}
else
{
if (!boolIsUpdate)
{
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
SqlCommand sqlCommand1;
db.Open();
transaction = db.BeginTransaction();
try
{
for (int i = 0; i < selection.SelectedCount; i++)
{
if ((Int32)this.radioGroup1.EditValue == 1)//Revenue Code
{
lol = ((selection.GetSelectedRow(i) as DataRowView)["RevenueCode"].ToString());
}
else if ((Int32)this.radioGroup1.EditValue == 2)//Bank Branch
{
lol = ((selection.GetSelectedRow(i) as DataRowView)["BranchCode"].ToString());
}
string query = String.Format("INSERT INTO [tblPrintingCenterMap]([CentreCode],[CentreName],[StationName],[StationCode],[RevenueCode]) VALUES ('{0}','{1}','{2}','{3}','{4}')", cboCentre.SelectedValue.ToString(), cboCentre.Text.Trim(), cboStation.Text, cboStation.SelectedValue.ToString(), lol);
sqlCommand1 = new SqlCommand(query, db, transaction);
sqlCommand1.ExecuteNonQuery();
}
//call report for Print
transaction.Commit();
//ReceiptCall();
}
catch (SqlException sqlError)
{
transaction.Rollback();
Tripous.Sys.ErrorBox(sqlError);
return;
}
db.Close();
}
}
else
{
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
SqlCommand sqlCommand1;
db.Open();
transaction = db.BeginTransaction();
try
{
string query = String.Format("DELETE FROM tblPrintingCenterMap where CentreCode ='{0}' and StationCode ='{1}'", ID, stationcode);
sqlCommand1 = new SqlCommand(query, db, transaction);
sqlCommand1.ExecuteNonQuery();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
Tripous.Sys.ErrorBox(ex);
return;
}
db.Close();
}
using (SqlConnection dbs = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transactions;
SqlCommand sqlCommand2;
dbs.Open();
transactions = dbs.BeginTransaction();
try
{
for (int i = 0; i < selection.SelectedCount; i++)
{
if ((Int32)this.radioGroup1.EditValue == 1) //Revenue Code
{
lol = ((selection.GetSelectedRow(i) as DataRowView)["RevenueCode"].ToString());
}
else if ((Int32)this.radioGroup1.EditValue == 2) //Bank Branch
{
lol = ((selection.GetSelectedRow(i) as DataRowView)["BranchCode"].ToString());
}
string query = String.Format("INSERT INTO [tblPrintingCenterMap]([CentreCode],[CentreName],[StationName],[StationCode],[RevenueCode]) VALUES ('{0}','{1}','{2}','{3}','{4}')", cboCentre.SelectedValue.ToString(), cboCentre.Text.Trim(), cboStation.Text, cboStation.SelectedValue.ToString(), lol);
sqlCommand2 = new SqlCommand(query, dbs, transactions);
sqlCommand2.ExecuteNonQuery();
}
//call report for Print
transactions.Commit();
//ReceiptCall();
}
catch (SqlException sqlError)
{
transactions.Rollback();
Tripous.Sys.ErrorBox(sqlError);
return;
}
dbs.Close();
}
}
}
setReload1();
setReload(querys);
cboStation.SelectedIndex = -1;
cboCentre.SelectedValue = -1;
Common.setMessageBox(" Transaction Completed Successfully ", Program.ApplicationName, 1);
selection.ClearSelection();
}
void bttnUpdate_Click(object sender, EventArgs e)
{
if (selection.SelectedCount == 0)
{
Common.setMessageBox("Please Select Revenue Code to Map with Tax Payer Type", Program.ApplicationName, 1);
return;
}
else
{
if (!boolIsUpdate)
{
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
db.Open();
transaction = db.BeginTransaction();
try
{
for (int i = 0; i < selection.SelectedCount; i++)
{
using (var ds = new System.Data.DataSet())
{//select record
//get the selected value from the gridview
string lol = ((selection.GetSelectedRow(i) as DataRowView)["RevenueCode"].ToString());
//insert the selected record into the table
string query = String.Format("INSERT INTO [tblRevenueCodeTaxPayerTypeRelation]([TaxPayerTypeCode],[RevenueCode],ModifyBy) VALUES ('{0}','{1}','{2}')", cboStation.SelectedValue, lol, Program.UserID);
using (SqlCommand sqlCommand1 = new SqlCommand(query, db, transaction))
{
sqlCommand1.ExecuteNonQuery();
}
}
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
Tripous.Sys.ErrorBox(ex); return;
}
db.Close(); selection.ClearSelection(); setReload(); cboStation.SelectedIndex = -1;
}
}
else
{
//delete exiting records
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
SqlCommand sqlCommand1;
db.Open();
transaction = db.BeginTransaction();
try
{
string query = String.Format("DELETE FROM tblRevenueCodeTaxPayerTypeRelation where TaxPayerTypeCode ='{0}' ", ID);
sqlCommand1 = new SqlCommand(query, db, transaction);
sqlCommand1.ExecuteNonQuery();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
Tripous.Sys.ErrorBox(ex);
return;
}
db.Close();
}
//insert new records after modification
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
db.Open();
transaction = db.BeginTransaction();
try
{
for (int i = 0; i < selection.SelectedCount; i++)
{
using (var ds = new System.Data.DataSet())
{//select record
//get the selected value from the gridview
string lol = ((selection.GetSelectedRow(i) as DataRowView)["RevenueCode"].ToString());
//insert the selected record into the table
using (SqlCommand sqlCommand1 = new SqlCommand((string)String.Format("INSERT INTO [tblRevenueCodeTaxPayerTypeRelation]([TaxPayerTypeCode],[RevenueCode],ModifyBy) VALUES ('{0}','{1}','{2}')", cboStation.SelectedValue, lol, Program.UserID), db, transaction))
{
sqlCommand1.ExecuteNonQuery();
}
}
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
Tripous.Sys.ErrorBox(ex);
return;
}
db.Close(); selection.ClearSelection(); cboStation.SelectedIndex = -1;
}
}
Common.setMessageBox("Record has been successfully Mapped", Program.ApplicationName, 1);
tsbReload.PerformClick();
}
}
void bttnUpdate_Click(object sender, EventArgs e)
{
using (SqlConnection db = new SqlConnection(Logic.ConnectionString))
{
SqlTransaction transaction;
db.Open();
transaction = db.BeginTransaction();
try
{
for (int i = 0; i < selection.SelectedCount; i++)
{
using (var ds = new System.Data.DataSet())
{//select record
string lol = ((selection.GetSelectedRow(i) as DataRowView)["OfficeCode"].ToString());
string lol2 = ((selection.GetSelectedRow(i) as DataRowView)["OfficeName"].ToString());
string query = String.Format("INSERT INTO [tblStationMap]([StationCode],[StationName],[RevenueOfficeCode],[RevenueOfficeName]) VALUES ('{0}','{1}','{2}','{3}')", cboStation.SelectedValue, cboStation.Text.ToString(), lol, lol2);
using (SqlCommand sqlCommand1 = new SqlCommand(query, db, transaction))
{
sqlCommand1.ExecuteNonQuery();
}
query = String.Format("SELECT StationCode,StationName FROM tblCollectionReport WHERE [ZoneCode] = '{0}'", lol);
using (SqlDataAdapter ada = new SqlDataAdapter(query, Logic.ConnectionString))
{
ada.Fill(ds, "table");
}
Dt = ds.Tables[0];
foreach (DataRow item in Dt.Rows)
{
if (item["StationCode"].ToString() == "0" && item["StationName"].ToString() == "Not Yet Mapped")
{
using (SqlCommand sqlCommand = new SqlCommand(String.Format(String.Format("UPDATE [tblCollectionReport] SET [StationCode]='{{0}}',[StationName]='{{1}}' where [ZoneCode] ='{0}' and [StationCode]='0' and StationName='Not Yet Mapped' ", lol), lol, lol2), db, transaction))
{
sqlCommand.ExecuteNonQuery();
}
}
}
//get the station code and name base on the check revenue office
}
}
//call report for Print
transaction.Commit();
//ReceiptCall();
}
catch (SqlException sqlError)
{
transaction.Rollback();
}
db.Close();
setReload();
cboStation.SelectedIndex = -1;
Common.setMessageBox("Record has been successfully added", Program.ApplicationName, 1);
}
}
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;
}
}
}
}
}
private void BttnUpdate_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtName.Text.Trim().ToString()) || txtName.Text == null)
{
Common.setEmptyField("Profile Name", "Profile Setup");
return;
}
else
{
temTableAgcy.Clear(); temTable.Clear();
if (selection.SelectedCount == 0)
{
Common.setMessageBox("Bank Branch", "Profile Setup", 2); return;
}
else
{
for (int i = 0; i < selection.SelectedCount; i++)
{
temTable.Rows.Add(new object[] { String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["BankShortCode"]), String.Format("{0}", (selection.GetSelectedRow(i) as DataRowView)["BranchCode"]) });
}
}
if (selectiongrid.SelectedCount == 0)
{
Common.setMessageBox("Revenue Description", "Profile Setup", 2); return;
}
else
{
for (int i = 0; i < selectiongrid.SelectedCount; i++)
{
temTableAgcy.Rows.Add(new object[] { String.Format("{0}", (selectiongrid.GetSelectedRow(i) as DataRowView)["AgencyCode"]), String.Format("{0}", (selectiongrid.GetSelectedRow(i) as DataRowView)["RevenueCode"]) });
}
}
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("doProfileCriteria", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@profilename", SqlDbType.VarChar)).Value = txtName.Text.Trim();
_command.Parameters.Add(new SqlParameter("@pAgencyTable", SqlDbType.Structured)).Value = temTableAgcy;
_command.Parameters.Add(new SqlParameter("@pBankTable", SqlDbType.Structured)).Value = temTable;
_command.Parameters.Add(new SqlParameter("@type", SqlDbType.Bit)).Value = boolIsUpdate;
_command.Parameters.Add(new SqlParameter("@userid", SqlDbType.VarChar)).Value = Program.UserID;
_command.Parameters.Add(new SqlParameter("@ids", SqlDbType.Int)).Value = ID;
_command.CommandTimeout = 0;
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)
{
Common.setMessageBox(response.Tables[0].Rows[0]["returnMessage"].ToString(), "", 2);
setClear(); setReload(); tsbReload.PerformClick();
return;
}
else
{
Common.setMessageBox(response.Tables[0].Rows[0]["returnMessage"].ToString(), "", 2);
setClear(); setReload(); tsbReload.PerformClick();
return;
}
}
}
}
private void SbnDisapprove_Click(object sender, EventArgs e)
{
string value = string.Empty;
if (DialogResults.InputBox(@"Comments for Disapproving ", "Reclassification", ref value) == DialogResult.OK)
{
//value = String.Format("{0:N2}", Convert.ToDecimal(value));
SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false);
if (!string.IsNullOrWhiteSpace(value))
{
if (string.IsNullOrEmpty(selection.SelectedCount.ToString()) || selection.SelectedCount == 0)
{
Common.setMessageBox("No Record selected", "Reclassification", 1); return;
}
else
{
for (int i = 0; i < selection.SelectedCount; i++)
{
tableTrans.Rows.Add(new object[] { (selection.GetSelectedRow(i) as DataRowView)["MergeTinID"], (selection.GetSelectedRow(i) as DataRowView)["UTIN"], (selection.GetSelectedRow(i) as DataRowView)["IsprimaryTin"] });
}
if (tableTrans.Columns.Contains("ID"))
{
tableTrans.Columns.Remove("ID");
}
using (SqlConnection connect = new SqlConnection(Logic.ConnectionString))
{
connect.Open();
_command = new SqlCommand("TaxAgentMergeTinDisapproved", connect)
{
CommandType = CommandType.StoredProcedure
};
_command.Parameters.Add(new SqlParameter("@pTransaction", SqlDbType.Structured)).Value = tableTrans;
_command.Parameters.Add(new SqlParameter("@user", SqlDbType.VarChar)).Value = Program.UserID;
_command.CommandTimeout = 0;
using (System.Data.DataSet dts = new System.Data.DataSet())
{
dts.Clear();
adp = new SqlDataAdapter(_command);
adp.Fill(dts);
connect.Close();
if (dts.Tables[0].Rows[0]["returnCode"].ToString() != "00")
{
Common.setMessageBox(dts.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
return;
}
else
{
Common.setMessageBox(dts.Tables[0].Rows[0]["returnMessage"].ToString(), Program.ApplicationName, 2);
return;
}
}
}
}
}
SplashScreenManager.CloseForm(false);
}
}