protected void btnAuthorize_Click(object sender, EventArgs e)
{
string v_return = "";
OracleParameter[] parm = new OracleParameter[8];
int pno = 0;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("p_branch_code", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("p_Account_no", OracleType.VarChar, ParameterDirection.Input, "");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_Userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString());
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_type", OracleType.VarChar, ParameterDirection.Input, "02");
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("p_file_name", OracleType.VarChar, ParameterDirection.Input, ddlFile.SelectedValue);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("p_retval", OracleType.VarChar, ParameterDirection.Output, "");
v_return = _dbConfig.OracleExecuteSP_GetReturnVal("sp_force_Updation", parm, pno);
lblMessage.Text = v_return.Split(';').GetValue(1).ToString();
}
private void Submit(string rowid, string draftid, string cancel_no, string userid, string cancel_action, string p_type, string company_code)
{
try
{
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[8];
parm[0] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, rowid);
parm[1] = _dbConfig.Oracle_Param("p_draftid", OracleType.VarChar, ParameterDirection.Input, draftid);
parm[2] = _dbConfig.Oracle_Param("p_cancel_no", OracleType.VarChar, ParameterDirection.Input, cancel_no);
parm[3] = _dbConfig.Oracle_Param("p_userid", OracleType.VarChar, ParameterDirection.Input, userid);
parm[4] = _dbConfig.Oracle_Param("p_cancel_action", OracleType.VarChar, ParameterDirection.Input, cancel_action);
parm[5] = _dbConfig.Oracle_Param("p_type", OracleType.VarChar, ParameterDirection.Input, p_type);
parm[6] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, company_code);
parm[7] = _dbConfig.Oracle_Param("p_return", OracleType.VarChar, ParameterDirection.Output, "");
string retVal = _dbConfig.OracleExecuteSP_GetReturnVal("RPS_SP_DraftCancellation_Add", parm, 7);
lblmessage.Text = retVal;
if (retVal.StartsWith("0"))
{
btnUpdate.Enabled = false;
}
}
catch (Exception ex)
{
lblmessage.Text = ex.Message;
}
}
public void AddInQueueTitleFetchTrans()
{
string retval = "";
try
{
OracleParameter[] parms = new OracleParameter[4];
parms[0] = db.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue);
parms[1] = db.Oracle_Param("p_file_name", OracleType.VarChar, ParameterDirection.Input, ddlFile.SelectedValue);
parms[2] = db.Oracle_Param("p_userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString());
parms[3] = db.Oracle_Param("p_return", OracleType.VarChar, ParameterDirection.Output, "");
retval = db.OracleExecuteSP_GetReturnVal("sp_insert_ibft_title", parms, 3);
lblMessage.Text = retval;
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
private void ExecuteGridView1()
{
DataSet ds = new DataSet();
string retval;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
if (((CheckBox)GridView1.Rows[i].FindControl("Ckb_Select")).Checked == true)
{
OracleParameter[] parms = new OracleParameter[5];
parms[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString());
parms[1] = _dbConfig.Oracle_Param("p_file_name", OracleType.VarChar, ParameterDirection.Input, ddlFile.SelectedItem.ToString());
parms[2] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, GridView1.Rows[i].Cells[0].Text);
parms[3] = _dbConfig.Oracle_Param("p_userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString());//Session["U_NAME"].ToString()
parms[4] = _dbConfig.Oracle_Param("p_retval", OracleType.VarChar, ParameterDirection.Output, "");
retval = _dbConfig.OracleExecuteSP_GetReturnVal("sp_acc_comp_publish_submit", parms, 4);
lblMessage.Text = retval.Split(',')[1].ToString();
}
}
}
public string trans_process(string p_company_code, string p_bank_code, string p_cust_refno, string p_userid)
{
string retVal = "";
OracleParameter[] param = new OracleParameter[5];
param[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, p_company_code);
param[1] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, p_bank_code);
param[2] = _dbConfig.Oracle_Param("p_cust_refno", OracleType.VarChar, ParameterDirection.Input, p_cust_refno);
param[3] = _dbConfig.Oracle_Param("p_userid", OracleType.VarChar, ParameterDirection.Input, p_userid);
param[4] = _dbConfig.Oracle_Param("p_return", OracleType.VarChar, ParameterDirection.Output, "");
retVal = _dbConfig.OracleExecuteSP_GetReturnVal("sp_pri_poston_symbol", param, 4);
return(retVal);
}
public string Process(string p_company_code, string p_file_name, string p_type, string p_user_id)
{
string v_return = "";
OracleParameter[] parm = new OracleParameter[5];
parm[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, p_company_code);
parm[1] = _dbConfig.Oracle_Param("p_file_name", OracleType.VarChar, ParameterDirection.Input, p_file_name);
parm[2] = _dbConfig.Oracle_Param("p_type", OracleType.VarChar, ParameterDirection.Input, p_type);
parm[3] = _dbConfig.Oracle_Param("p_user_id", OracleType.VarChar, ParameterDirection.Input, p_user_id);
parm[4] = _dbConfig.Oracle_Param("p_return", OracleType.VarChar, ParameterDirection.Output, "");
v_return = _dbConfig.OracleExecuteSP_GetReturnVal("sp_publish_file_manual", parm, 4);
return(v_return);
}
public void UploadLog(string comapny_code, string filename, string user_id, string action, string app_datetime)
{
string p_return = "";
try
{
if (CheckGlobalVar == true)
{
OracleParameter[] parm = new OracleParameter[6];
parm[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, comapny_code);
parm[1] = _dbConfig.Oracle_Param("p_file_name", OracleType.VarChar, ParameterDirection.Input, filename);
parm[2] = _dbConfig.Oracle_Param("p_userid", OracleType.VarChar, ParameterDirection.Input, user_id);
parm[3] = _dbConfig.Oracle_Param("p_action", OracleType.VarChar, ParameterDirection.Input, action);
parm[4] = _dbConfig.Oracle_Param("p_app_datetime", OracleType.VarChar, ParameterDirection.Input, app_datetime);
parm[5] = _dbConfig.Oracle_Param("p_return", OracleType.VarChar, ParameterDirection.Output, "");
p_return = _dbConfig.OracleExecuteSP_GetReturnVal("sp_UploadLog", parm, 5);
}
}
catch (Exception ex)
{
p_return = ex.Message;
}
}
public string trans_process(string p_rowid, string p_companycode, string p_draftno, string p_cust_refno, string p_transtype, string p_amount, string p_bankcode, string p_userid, string p_action)
{
string retVal = "";
OracleParameter[] param = new OracleParameter[8];
param[0] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, p_rowid);
param[1] = _dbConfig.Oracle_Param("p_companycode", OracleType.VarChar, ParameterDirection.Input, p_companycode);
param[2] = _dbConfig.Oracle_Param("p_draftno", OracleType.VarChar, ParameterDirection.Input, p_draftno);
param[3] = _dbConfig.Oracle_Param("p_cust_refno", OracleType.VarChar, ParameterDirection.Input, p_cust_refno);
param[4] = _dbConfig.Oracle_Param("p_amount", OracleType.VarChar, ParameterDirection.Input, p_amount);
param[5] = _dbConfig.Oracle_Param("p_userid", OracleType.VarChar, ParameterDirection.Input, p_userid);
param[6] = _dbConfig.Oracle_Param("p_action", OracleType.VarChar, ParameterDirection.Input, p_action);
param[7] = _dbConfig.Oracle_Param("p_return", OracleType.VarChar, ParameterDirection.Output, "");
retVal = _dbConfig.OracleExecuteSP_GetReturnVal("sp_unpaid_trans", param, 7);
return(retVal);
}
private void process(string company_code, string FILE_NAME)
{
DataSet ds = new DataSet();
OracleParameter[] param = new OracleParameter[4];
param[0] = new OracleParameter();
param[0] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, company_code);
param[1] = new OracleParameter();
param[1] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, FILE_NAME);
param[2] = new OracleParameter();
param[2] = _dbConfig.Oracle_Param("P_userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString());//Session["U_NAME"].ToString()
param[3] = new OracleParameter();
param[3] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, "");
string return1 = _dbConfig.OracleExecuteSP_GetReturnVal("Account_Completion", param, 3).ToString();
lblMessage.Text = return1.Split(';').GetValue(1).ToString();
//string return1 = "1;Data successfully Proceed.";
}
public string DraftMarking(string p_company_code, string p_file_name)
{
string p_return = "";
try
{
OracleParameter[] parm = new OracleParameter[3];
parm[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, p_company_code);
parm[1] = _dbConfig.Oracle_Param("p_file_name", OracleType.VarChar, ParameterDirection.Input, p_file_name);
parm[2] = _dbConfig.Oracle_Param("p_retval", OracleType.VarChar, ParameterDirection.Output, "");
p_return = _dbConfig.OracleExecuteSP_GetReturnVal("sp_draftprintmark", parm, 2);
p_return = p_return.Split(';').GetValue(1).ToString();
}
catch (Exception ex)
{
p_return = "Draft is not mark " + ex.Message;
}
return(p_return);
}
public string PRIDownloadMarking(string ID, string fileName, string userid)
{
string retVal = "";
try
{
OracleParameter[] PR = new OracleParameter[4];
PR[0] = DataTransform.Oracle_Param("p_corrbankid", OracleType.VarChar, ParameterDirection.Input, ID);
PR[1] = DataTransform.Oracle_Param("p_pri_filename", OracleType.VarChar, ParameterDirection.Input, fileName);
PR[2] = DataTransform.Oracle_Param("p_user_id", OracleType.VarChar, ParameterDirection.Input, userid);
PR[3] = DataTransform.Oracle_Param("p_return", OracleType.VarChar, ParameterDirection.Output, "");
retVal = DataTransform.OracleExecuteSP_GetReturnVal("sp_pridownloadmarking", PR, 3);
}
catch (Exception ex)
{
retVal = ex.Message;
}
return(retVal);
}
public void Execute_sp()
{
string v_return = "";
Label lblStatus;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
lblStatus = ((Label)GridView1.Rows[i].FindControl("lblStatus"));
if (((CheckBox)GridView1.Rows[i].FindControl("cbPublish")).Checked == true)
{
int pno = 0;
OracleParameter[] parm = new OracleParameter[3];
parm[pno] = db.Oracle_Param("p_row_id", OracleType.VarChar, ParameterDirection.Input, GridView1.Rows[i].Cells[0].Text); pno++;
parm[pno] = db.Oracle_Param("p_user_id", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString()); pno++;
parm[pno] = db.Oracle_Param("p_retval", OracleType.VarChar, ParameterDirection.Output, "");
v_return = db.OracleExecuteSP_GetReturnVal("sp_update_unhold_trans", parm, pno);
lblStatus.Text = v_return.Split(';')[1].ToString();
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
lblMessage.Text = "";
try
{
for (int i = 0; i < grdTransaction.Rows.Count; i++)
{
string IBAN = ((TextBox)grdTransaction.Rows[i].FindControl("txtIBAN")).Text;
Label lblStatus = (Label)grdTransaction.Rows[i].FindControl("lblStatus");
CheckBox Ckb_Select = (CheckBox)grdTransaction.Rows[i].FindControl("Ckb_Select");
if (Ckb_Select.Checked == true && IBAN != "")
{
string p_return = "";
DataSet ds = new DataSet();
OracleParameter[] parms = new OracleParameter[4];
parms[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString());
parms[1] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, grdTransaction.Rows[i].Cells[0].Text);
parms[2] = _dbConfig.Oracle_Param("p_iban", OracleType.VarChar, ParameterDirection.Input, IBAN);
parms[3] = _dbConfig.Oracle_Param("p_retval", OracleType.VarChar, ParameterDirection.Output, "");
p_return = _dbConfig.OracleExecuteSP_GetReturnVal("sp_seg_iban_update", parms, 3);
lblStatus.Text = p_return.Split(';')[1].ToString();
if (p_return.StartsWith("0"))
{
Ckb_Select.Checked = false;
Ckb_Select.Enabled = false;
}
}
}
//dllFilename();
//ddlFile_SelectedIndexChanged(null, null);
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
public string spRow_Updation(string Type)
{
string account_no = "";
string branch_code = "";
string TitleofAccount = "";
string rowid = "";
string v_return = "";
for (int i = 0; i < GridView1.Rows.Count; i++)
{
rowid = GridView1.Rows[i].Cells[0].Text;
account_no = ((TextBox)GridView1.Rows[i].FindControl("txtAccountNo")).Text;
branch_code = ((TextBox)GridView1.Rows[i].FindControl("txtBranchCode")).Text;
TitleofAccount = ((TextBox)GridView1.Rows[i].FindControl("txtTitleofAccount")).Text;
if (rowid != "" && account_no != "" && branch_code != "" && TitleofAccount != "")
{
OracleParameter[] parm = new OracleParameter[7];
int pno = 0;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, rowid);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_ACCOUNTNUMBER", OracleType.VarChar, ParameterDirection.Input, account_no);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_BRANCH_CODE", OracleType.VarChar, ParameterDirection.Input, branch_code);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("p_bene_name", OracleType.VarChar, ParameterDirection.Input, TitleofAccount);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_Userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString());
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("P_type", OracleType.VarChar, ParameterDirection.Input, Type);
pno++;
parm[pno] = new OracleParameter();
parm[pno] = _dbConfig.Oracle_Param("p_retval", OracleType.VarChar, ParameterDirection.Output, "");
v_return = _dbConfig.OracleExecuteSP_GetReturnVal("sp_depository_update_auth", parm, pno);
if (v_return.StartsWith("04") == false)
{
lblMessage.Text = v_return.Split(',').GetValue(1).ToString();
return(v_return);
}
else
{
lblMessage.Text = v_return.Split(',').GetValue(1).ToString();
txtAccountNo.Text = "";
txtBranchCode.Text = "";
loadGrid("S");
}
}
else
{
lblMessage.Text = "Account No and Title must be required.";
v_return = "Account No,Branch Code and Title must be required.";
}
}
return(v_return);
}