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;
}
}
}
