void AuthoOperation(string Action) { OracleParameter[] parms = new OracleParameter[15]; int i = 0; GetTemplateControlReference(i); if (txtfrmamt.Text != "") { parms[0] = new OracleParameter(); parms[0] = obj_DBLayer.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, ddlcompany.SelectedValue); parms[1] = new OracleParameter(); parms[1] = obj_DBLayer.Oracle_Param("P_product_code", OracleType.VarChar, ParameterDirection.Input, ddlproduct.SelectedValue); parms[2] = new OracleParameter(); parms[2] = obj_DBLayer.Oracle_Param("P_follow_seq", OracleType.VarChar, ParameterDirection.Input, chkflowSeq.Checked == true ? "Y" : "N"); parms[3] = new OracleParameter(); parms[3] = obj_DBLayer.Oracle_Param("P_from_amount", OracleType.VarChar, ParameterDirection.Input, txtfrmamt.Text); parms[4] = new OracleParameter(); parms[4] = obj_DBLayer.Oracle_Param("P_to_amount", OracleType.VarChar, ParameterDirection.Input, txttoamt.Text); parms[5] = new OracleParameter(); parms[5] = obj_DBLayer.Oracle_Param("P_maker_cat", OracleType.VarChar, ParameterDirection.Input, ddlMak.SelectedItem.Text); parms[6] = new OracleParameter(); parms[6] = obj_DBLayer.Oracle_Param("P_check_cat", OracleType.VarChar, ParameterDirection.Input, ddlChk.SelectedItem.Text); parms[7] = new OracleParameter(); parms[7] = obj_DBLayer.Oracle_Param("P_no_of_sign", OracleType.VarChar, ParameterDirection.Input, txtnumofSign.Text); parms[8] = new OracleParameter(); parms[8] = obj_DBLayer.Oracle_Param("P_single_cat", OracleType.VarChar, ParameterDirection.Input, ddlSingle.SelectedItem.Text); parms[9] = new OracleParameter(); parms[9] = obj_DBLayer.Oracle_Param("P_dual_cat", OracleType.VarChar, ParameterDirection.Input, ddlDual.SelectedItem.Text); parms[10] = new OracleParameter(); parms[10] = obj_DBLayer.Oracle_Param("P_triple_cat", OracleType.VarChar, ParameterDirection.Input, ddlTriple.SelectedItem.Text); parms[11] = new OracleParameter(); parms[11] = obj_DBLayer.Oracle_Param("P_publisher", OracleType.VarChar, ParameterDirection.Input, ddlPublish.SelectedItem.Text); parms[12] = new OracleParameter(); parms[12] = obj_DBLayer.Oracle_Param("P_User", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString()); parms[13] = new OracleParameter(); parms[13] = obj_DBLayer.Oracle_Param("P_active", OracleType.VarChar, ParameterDirection.Input, chkactive.Checked == true ? "Y" : "N"); parms[14] = new OracleParameter(); parms[14] = obj_DBLayer.Oracle_Param("P_What", OracleType.VarChar, ParameterDirection.Input, Action); obj_DBLayer.Oracle_GetDataSetSP_DML("SP_DMLAuthorizationMatrix", parms); parms.Initialize(); } }