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