public string Execute_sp(OracleConnection conn, OracleTransaction tran) { string v_return = ""; for (int i = 0; i < GridView1.Rows.Count; i++) { //if (((CheckBox)GridView1.Rows[i].FindControl("cbPublish")).Checked == true) OracleParameter[] parm = new OracleParameter[10]; int pno = 0; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_Trans_type", OracleType.VarChar, ParameterDirection.Input, (GridView1.Rows[i].Cells[1].Text == " ") ? "" : GridView1.Rows[i].Cells[1].Text); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, GridView1.Rows[i].Cells[0].Text); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("p_bank_code", 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_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, "10"); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, ""); v_return = _dbConfig.TransSPOracle_GetReturnStringVal1(conn, tran, "SP_Data_Segregation", parm, pno); if (v_return.StartsWith("04") == false) { lblMessage.Text = v_return.Split(',').GetValue(1).ToString(); return(v_return); } } return(v_return); }
public string executeMasterData(OracleConnection conn, OracleTransaction trans, string p_noofrecord) { string p_file_type = rbCancel.Checked == true ? "C" : "U"; //File Type C for Cancel and U for Unhold string p_return = ""; try { OracleParameter[] param = new OracleParameter[6]; param[0] = db.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue); param[1] = db.Oracle_Param("p_file_name", OracleType.VarChar, ParameterDirection.Input, ViewState["fileName"].ToString()); param[2] = db.Oracle_Param("p_noofrecord", OracleType.VarChar, ParameterDirection.Input, p_noofrecord); param[3] = db.Oracle_Param("p_user_id", OracleType.VarChar, ParameterDirection.Input, Session["UserId"].ToString()); param[4] = db.Oracle_Param("p_file_type", OracleType.VarChar, ParameterDirection.Input, p_file_type); param[5] = db.Oracle_Param("p_retval", OracleType.VarChar, ParameterDirection.Output, ""); p_return = db.TransSPOracle_GetReturnStringVal1(conn, trans, "sp_bulk_cancel_upload", param, 5); } catch (Exception ex) { p_return = "1;" + ex.Message; } return(p_return); }