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