public string Execute_sp()
{
string v_return = "";
DBUniversalUploadProcess Upload = new DBUniversalUploadProcess();
v_return = Upload.A2ATransaction(GridView1.Rows.Count, ddlCompanyCode.SelectedValue, ddlFile.SelectedValue, GridView1);
lblMessage.Text = v_return;
#region
//for (int i = 0; i < GridView1.Rows.Count; i++)
//{
// //if (((CheckBox)GridView1.Rows[i].FindControl("cbPublish")).Checked == true)
// //{
// OracleParameter[] parm = new OracleParameter[4];
// int pno = 0;
// parm[pno] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue);
// pno++;
// parm[pno] = _dbConfig.Oracle_Param("p_file_name", OracleType.VarChar, ParameterDirection.Input, ddlFile.SelectedValue);
// pno++;
// parm[pno] = _dbConfig.Oracle_Param("p_row_id", OracleType.VarChar, ParameterDirection.Input, GridView1.Rows[i].Cells[0].Text);
// pno++;
// parm[pno] = _dbConfig.Oracle_Param("p_retval", OracleType.VarChar, ParameterDirection.Output, "");
// v_return = _dbConfig.OracleExecuteSP_GetReturnVal("corebank_system_int_symbol", parm, pno);
// lblMessage.Text = v_return.Split(';').GetValue(1).ToString();
// /*if (v_return.StartsWith("0") == false)
// {
// lblMessage.Text = v_return.Split(';').GetValue(1).ToString();
// }*/
// //}
//}
#endregion
return(v_return);
}
public void process()
{
string retvalue = "";
try
{
if (Get_data(ViewState["filepath"].ToString()))
{
if (arr_size.Length > 0)
{
OracleConnection conn = new OracleConnection(db.ConnectionString);
conn.Open();
OracleTransaction trans = conn.BeginTransaction();
try
{
retvalue = executeMasterData(conn, trans, arr_size.Length.ToString());
if (retvalue.StartsWith("0"))
{
retvalue = "";
DBUniversalUploadProcess Upload = new DBUniversalUploadProcess();
//retvalue = Upload.BulkCancelationProcess(dt, "bulk_cancel_upload");
retvalue = Upload.BulkCancelationProcess(arr_size.Length, arr_company, arr_xpin, arr_file, arr_size, "sp_bulk_cancel_detail");
if (retvalue.StartsWith("0") == true)
{
trans.Commit();
conn.Close();
lblMessage.Text = retvalue.IndexOf(';') > 0 ? retvalue.Split(';')[1].ToString() : retvalue;
}
else
{
trans.Rollback();
conn.Close();
lblMessage.Text = retvalue.IndexOf(';') > 0 ? retvalue.Split(';')[1].ToString() : retvalue;
}
}
else
{
trans.Rollback();
conn.Close();
lblMessage.Text = retvalue.IndexOf(';') > 0 ? retvalue.Split(';')[1].ToString() : retvalue;
}
}
catch (Exception ex)
{
trans.Rollback();
conn.Close();
lblMessage.Text = ex.Message;
}
}
else
{
lblMessage.Text = "No record available for cancelation";
}
}
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
public void insertData(string filepath)
{
string batch_no = "";
Random rdnum = new Random();
batch_no = DateTime.Now.ToString("yyyyMMdd") + rdnum.Next(1, 99999);
hdn_value.Value = batch_no;
try
{
DataTable fileData = new DataTable();
Get_data(filepath);
if (dt.Rows.Count > 0)
{
string[] retvalue;
DBUniversalUploadProcess Upload = new DBUniversalUploadProcess();
if (dt.Rows.Count > 0)
{
string v_out = "";
retvalue = Upload.CustomerFindingUpload(dt.Rows.Count, Session["U_NAME"].ToString(), dt, batch_no, out v_out);
if (v_out.Split(';')[0] == "0")
{
bindDatawithStatus(retvalue);
}
else
{
lbl_Message.Text = v_out;
}
}
}
else
{
lbl_Message.Text = "No data found in file.";
}
}
catch (Exception ex)
{
lbl_Message.Text = ex.Message;
}
finally
{
if (File.Exists(filepath) == true)
{
File.Delete(filepath);
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
DBUniversalUploadProcess db = new DBUniversalUploadProcess();
string val = db.force_updation(GridView1, Session["U_NAME"].ToString(), "01", GridView1.Rows.Count, ddlCompanyCode.SelectedValue, ddlFile.SelectedValue);
lblMessage.Text = (val.Contains(";") == true ? val.Split(';').GetValue(1).ToString() : val);
#region
//OracleConnection con = new OracleConnection(ViewState["ConnectionString"].ToString());
//con.Open();
//OracleTransaction trans = con.BeginTransaction();
//string val = Execute_sp(con, trans);
//if (val.StartsWith("04") == true)
//{
// val = postLeadger(con, trans);
// if (val.StartsWith("04") == true)
// {
// trans.Commit();
// con.Close();
// loadGrid("S");
// }
// else
// {
// trans.Rollback();
// con.Close();
// }
//}
//else
//{
// trans.Rollback();
// con.Close();
//}
#endregion
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
public bool process(string fileSeparate)
{
try
{
DataTable fileData = new DataTable();
UploadLog(ddlCompanyCode.SelectedValue, ViewState["fileName"].ToString(), Session["UserId"].ToString(), "Get data from file Start", DateTime.Now.ToString());
Get_data(ViewState["filepath"].ToString(), fileSeparate);
UploadLog(ddlCompanyCode.SelectedValue, ViewState["fileName"].ToString(), Session["UserId"].ToString(), "Get data from file and records length " + dt.Rows.Count.ToString() + " End", DateTime.Now.ToString());
string sp_name = "";
if (dt.Rows.Count > 0)
{
string retvalue = "";
DBUniversalUploadProcess Upload = new DBUniversalUploadProcess();
retvalue = Upload.UploadProcess(dt.Rows.Count, dt, ddlCompanyCode.SelectedValue, ddlConfigID.SelectedValue, ViewState["fileName"].ToString());
//sp_name = retvalue.Split(';').GetValue(1).ToString();
sp_name = retvalue.IndexOf(';') > 0 ? retvalue.Split(';').GetValue(1).ToString() : retvalue;
if (retvalue.StartsWith("0") == true)
{
lbl_Message.Text = retvalue.Split(';').GetValue(1).ToString();
lblA2A.Text = "";
lblPRI.Text = "";
lblCOC.Text = "";
lblDD.Text = "";
lblDuplicateRecords.Text = "";
lblInvalidIBANRecords.Text = "";
lblTotalRecord.Text = "";
lblTotalAmount.Text = "";
lblA2ATOT.Text = "";
lblPRITOT.Text = "";
lblCOCTOT.Text = "";
lblDDTOT.Text = "";
lblDUPTOT.Text = "";
lblIBANTOT.Text = "";
if (File.Exists(ViewState["filepath"].ToString()) == true)
{
File.Delete(ViewState["filepath"].ToString());
}
UploadLog(ddlCompanyCode.SelectedValue, ViewState["fileName"].ToString(), Session["UserId"].ToString(), "Error on SP_RAW_DATALOAD : " + retvalue + " and file deleted at local path", DateTime.Now.ToString());
return(false);
}
else
{
string TransType = (chTransDD.Checked == true) ? "Y" : "N";
UploadLog(ddlCompanyCode.SelectedValue, ViewState["fileName"].ToString(), Session["UserId"].ToString(), "Call SP_RAW_DATALOAD1 Start", DateTime.Now.ToString());
retvalue = Upload.MianProcess(ddlCompanyCode.SelectedValue, ddlConfigID.SelectedValue, ViewState["fileName"].ToString(), TransType, sp_name);
UploadLog(ddlCompanyCode.SelectedValue, ViewState["fileName"].ToString(), Session["UserId"].ToString(), "Call SP_RAW_DATALOAD1 and return value " + retvalue + " End", DateTime.Now.ToString());
lbl_Message.Text = retvalue.IndexOf(';') > 0 ? retvalue.Split(';').GetValue(1).ToString() : retvalue;
//retvalue.Split(';').GetValue(1).ToString();
DataSet ds1 = new DataSet();
if (retvalue.StartsWith("1") == true)
{
DBProcess spProcess = new DBProcess();
spProcess.RecordInputStart();
spProcess.Get_Company_Code = ddlCompanyCode.SelectedValue;
spProcess.Get_Conf_ID = ddlConfigID.SelectedValue;
spProcess.Get_FileName = ViewState["fileName"].ToString();
spProcess.Get_UserID = Session["UserId"].ToString();
spProcess.Get_TOTAL_RECORDS = dt.Rows.Count.ToString();
spProcess.RecordInputCommit();
spProcess.AddNewGroup();
#region Summary and Duplication
UploadLog(ddlCompanyCode.SelectedValue, ViewState["fileName"].ToString(), Session["UserId"].ToString(), "Get data for file summary Start", DateTime.Now.ToString());
ds1 = lov.GetFileSummary(ddlCompanyCode.SelectedValue, ViewState["fileName"].ToString());
UploadLog(ddlCompanyCode.SelectedValue, ViewState["fileName"].ToString(), Session["UserId"].ToString(), "Get data for file summary End", DateTime.Now.ToString());
lblIBFT.Text = ds1.Tables[0].Rows[0]["IBFT"].ToString();
lblA2A.Text = ds1.Tables[0].Rows[0]["A2A"].ToString();
lblPRI.Text = ds1.Tables[0].Rows[0]["PRI"].ToString();
lblCOC.Text = ds1.Tables[0].Rows[0]["COC"].ToString();
lblDD.Text = ds1.Tables[0].Rows[0]["DD"].ToString();
lblDuplicateRecords.Text = ds1.Tables[1].Rows[0]["DuplicateRecords"].ToString();
lblInvalidIBANRecords.Text = ds1.Tables[1].Rows[0]["InvalidIBANRecords"].ToString();
/*filerecodsSp = Convert.ToInt32(ds1.Tables[0].Rows[0]["total_records"])
+Convert.ToInt32(ds1.Tables[1].Rows[0]["DuplicateRecords"]);*/
lblIBFTTOT.Text = ds1.Tables[0].Rows[0]["IBFTTOT"].ToString();
lblA2ATOT.Text = ds1.Tables[0].Rows[0]["A2ATOT"].ToString();
lblPRITOT.Text = ds1.Tables[0].Rows[0]["PRITOT"].ToString();
lblCOCTOT.Text = ds1.Tables[0].Rows[0]["COCTOT"].ToString();
lblDDTOT.Text = ds1.Tables[0].Rows[0]["DDTOT"].ToString();
lblDUPTOT.Text = ds1.Tables[1].Rows[0]["DUPTOT"].ToString();
lblIBANTOT.Text = ds1.Tables[1].Rows[0]["IBANTOT"].ToString();
lblTotalAmount.Text = Convert.ToString(Convert.ToDecimal(ds1.Tables[0].Rows[0]["TotalAmount"]) + Convert.ToDecimal(ds1.Tables[1].Rows[0]["DUPTOT"]) + Convert.ToDecimal(ds1.Tables[1].Rows[0]["IBANTOT"]));
int count = Convert.ToInt32(ds1.Tables[0].Rows[0]["IBFT"]) +
Convert.ToInt32(ds1.Tables[0].Rows[0]["A2A"]) +
Convert.ToInt32(ds1.Tables[0].Rows[0]["PRI"]) +
Convert.ToInt32(ds1.Tables[0].Rows[0]["COC"]) +
Convert.ToInt32(ds1.Tables[0].Rows[0]["DD"]);
lblTotalRecord.Text = Convert.ToString(count + Convert.ToInt64(lblDuplicateRecords.Text) + Convert.ToInt64(lblInvalidIBANRecords.Text));
lbIBFT.Attributes.Add("style", "visibility:visible;");
lbA2A.Attributes.Add("style", "visibility:visible;");
lbPRI.Attributes.Add("style", "visibility:visible;");
lbCOC.Attributes.Add("style", "visibility:visible;");
lbDD.Attributes.Add("style", "visibility:visible;");
lbDuplicateRecords.Attributes.Add("style", "visibility:visible;");
lbIBANRecords.Attributes.Add("style", "visibility:visible;");
lbTotalTransaction.Attributes.Add("style", "visibility:visible;");
lbTotalAmount.Attributes.Add("style", "visibility:visible;");
if (Convert.ToInt32(lblDuplicateRecords.Text) > 0)
{
//lbDuplicateRecords
lbDuplicateRecords.Attributes["onmouseover"] = "javascript:setMouseOverColor(this);";
lbDuplicateRecords.Attributes["onmouseout"] = "javascript:setMouseOutColor(this);";
string company_code = ddlCompanyCode.SelectedValue;
string file_name = ViewState["fileName"].ToString();
lbDuplicateRecords.Attributes.Add("onclick", "var str='MCB';wid=window.open('duplicateRecord.aspx?company_code=" + company_code + "&file_name=" + file_name + "', 'CS', 'left=550,top=165,height=650, width= 450 ,menubar=no,location=no,toolbar=no,scrollbars=yes,resizable=yes');return false;");
}
else
{
lbDuplicateRecords.Attributes["onmouseover"] = "javascript:NODuplicate(this);";
lbDuplicateRecords.Attributes.Add("onclick", "return false");
}
if (Convert.ToInt32(lblInvalidIBANRecords.Text) > 0)
{
//lbDuplicateRecords
lbIBANRecords.Attributes["onmouseover"] = "javascript:setMouseOverColor(this);";
lbIBANRecords.Attributes["onmouseout"] = "javascript:setMouseOutColor(this);";
string company_code = ddlCompanyCode.SelectedValue;
string file_name = ViewState["fileName"].ToString();
lbIBANRecords.Attributes.Add("onclick", "var str='MCB';wid=window.open('IBANInvalidRecord.aspx?company_code=" + company_code + "&file_name=" + file_name + "', 'CS', 'left=550,top=165,height=650, width= 450 ,menubar=no,location=no,toolbar=no,scrollbars=yes,resizable=yes');return false;");
}
else
{
lbIBANRecords.Attributes["onmouseover"] = "javascript:NODuplicate(this);";
lbIBANRecords.Attributes.Add("onclick", "return false");
}
lblSummary.Visible = true;
lblrecord.Visible = true;
lblamount.Visible = true;
dt = lov.GetContactNoforSMS(ddlCompanyCode.SelectedValue, ViewState["fileName"].ToString(), "01").Tables[0];
if (dt.Rows.Count > 0)
{
int y = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (GenerateSMS(dt.Rows[i]["contactnumber"].ToString(), dt.Rows[i]["msg"].ToString()) == true)
{
y = 1;
}
}
if (y == 1)
{
lbl_Message.Text += " and SMS has been sent to Beneficiary.";
}
}
#endregion
}
}
}
}
catch (Exception ex)
{
lbl_Message.Text = ex.Message;
}
UploadLog(ddlCompanyCode.SelectedValue, ViewState["fileName"].ToString(), Session["UserId"].ToString(), "In process method file delete at local path Start", DateTime.Now.ToString());
if (File.Exists(ViewState["filepath"].ToString()) == true)
{
File.Delete(ViewState["filepath"].ToString());
}
UploadLog(ddlCompanyCode.SelectedValue, ViewState["fileName"].ToString(), Session["UserId"].ToString(), "In process method file delete at local path End", DateTime.Now.ToString());
return(true);
}
