protected void btnSubmit_Click(object sender, EventArgs e) { try { string p_return = ""; string[] p_retval; for (int i = 0; i < GridView1.Rows.Count; i++) { string transType = ((DropDownList)GridView1.Rows[i].FindControl("DDLCHANGETO")).SelectedValue.ToString(); if (transType != "Select Mode") { DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[10]; parms[0] = new OracleParameter(); parms[0] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString()); parms[1] = new OracleParameter(); parms[1] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, ddlFile.SelectedItem.ToString()); parms[2] = new OracleParameter(); parms[2] = _dbConfig.Oracle_Param("P_Trans_type", OracleType.VarChar, ParameterDirection.Input, transType); parms[3] = new OracleParameter(); parms[3] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, GridView1.Rows[i].Cells[0].Text); parms[4] = new OracleParameter(); parms[4] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, GridView1.Rows[i].Cells[3].Text); parms[5] = new OracleParameter(); parms[5] = _dbConfig.Oracle_Param("p_branch_code", OracleType.VarChar, ParameterDirection.Input, GridView1.Rows[i].Cells[4].Text); parms[6] = new OracleParameter(); parms[6] = _dbConfig.Oracle_Param("P_Userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString()); parms[7] = new OracleParameter(); parms[7] = _dbConfig.Oracle_Param("P_type", OracleType.VarChar, ParameterDirection.Input, "04"); parms[8] = new OracleParameter(); parms[8] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); parms[9] = new OracleParameter(); parms[9] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, ""); p_return = _dbConfig.Oracle_GetDataSetSP_DML("SP_Data_Segregation", parms, 9); lblMessage.Text = p_return.Split(',').GetValue(1).ToString(); } } if (p_return.Split(',').GetValue(0).ToString() == "04") { loadGrid("S"); } } catch (Exception EX) { lblMessage.Text = EX.Message; } }
public void Execute_sp() { string v_return = ""; for (int i = 0; i < sort_table.Rows.Count; i++) { //string branchCode = ((HiddenField)sort_table.Rows[i].FindControl("hf_BranchCode")).Value; string branchCode = ((TextBox)sort_table.Rows[i].FindControl("txtBranchCode")).Text; if (branchCode != "") { branchCode = get_Branch(i); } OracleParameter[] parm = new OracleParameter[10]; int pno = 0; if (branchCode != "" && branchCode != "0" && branchCode != "Branch not found") { parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, ddlFile.SelectedValue.ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_Trans_type", OracleType.VarChar, ParameterDirection.Input, sort_table.Rows[i].Cells[1].Text); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, sort_table.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, branchCode); 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, "06"); 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.Oracle_GetDataSetSP_DML("SP_Data_Segregation", parm, pno); lblMessage.Text = v_return.Split(',').GetValue(1).ToString(); } } /*if (v_return.Split(',').GetValue(0).ToString() == "04") * { * loadGrid("S"); * }*/ }
//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, ddlCompanyCode.SelectedValue.ToString()); // pno++; // parm[pno] = new OracleParameter(); // parm[pno] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, ddlFile.SelectedValue.ToString()); // 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 spRow_Updation(string rowid, string beneName, string AccountNO, string Type, string bank_code, string branchID) { 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[7]; int pno = 0; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("p_benename", OracleType.VarChar, ParameterDirection.Input, beneName); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_accountno", OracleType.VarChar, ParameterDirection.Input, AccountNO); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, bank_code); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("p_branchid", OracleType.VarChar, ParameterDirection.Input, branchID); pno++; 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_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.Oracle_GetDataSetSP_DML("sp_Trans_Enquiry_upd", parm, pno); if (v_return.StartsWith("1") == false) { lblMessage.Text = v_return.Split(';').GetValue(1).ToString(); return(v_return); } else { lblMessage.Text = v_return.Split(';').GetValue(1).ToString(); } //} return(v_return); }
protected void btnDuplicate_Click(object sender, EventArgs e) { string rowCode = GridView1.DataKeys[0].Value.ToString(); if (this.GridView1.Rows.Count > 0) { if (rowCode.Length > 0) { OracleParameter[] parms = new OracleParameter[2]; parms[0] = new OracleParameter(); parms[0] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, rowCode); parms[1] = new OracleParameter(); parms[1] = _dbConfig.Oracle_Param("p_retval", OracleType.VarChar, ParameterDirection.Output, ""); //DataSet ds = _dbConfig.Oracle_GetDataSetSP("sp_duplicate_dd", parms); _dbConfig.Oracle_GetDataSetSP_DML("sp_duplicate_dd", parms); if (CRUtlityGetsafeString(parms[1].Value).Length > 0) { string[] result = CRUtlityGetsafeString(parms[1].Value).Split(';'); if (result[0] == "0") { this.lblMessage.Visible = true; this.lblMessage.Text = result[1]; this.lblRecord.Visible = false; } else { this.lblRecord.Visible = true; this.lblRecord.Text = result[1]; this.lblMessage.Visible = false; } } } } }
public string spRow_Updation(string rowid, string beneName, string AccountNO, string beneid, string Type) { string v_return = ""; OracleParameter[] parm = new OracleParameter[7]; parm[0] = _dbConfig.Oracle_Param("p_benename", OracleType.VarChar, ParameterDirection.Input, beneName); parm[1] = _dbConfig.Oracle_Param("p_accountnumber", OracleType.VarChar, ParameterDirection.Input, AccountNO); parm[2] = _dbConfig.Oracle_Param("p_beneficiaryid", OracleType.VarChar, ParameterDirection.Input, beneid); parm[3] = _dbConfig.Oracle_Param("p_userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString()); parm[4] = _dbConfig.Oracle_Param("p_type", OracleType.VarChar, ParameterDirection.Input, Type); parm[5] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, rowid); parm[6] = _dbConfig.Oracle_Param("p_retval", OracleType.VarChar, ParameterDirection.Output, ""); v_return = _dbConfig.Oracle_GetDataSetSP_DML("sp_amedment_afterPublish", parm, 6); 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(); } return(v_return); }
public string spRow_Updation(string rowid, string beneName, string AccountNO, string Type) { 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[26]; 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_BENENAME", OracleType.VarChar, ParameterDirection.Input, beneName); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_BENEADDRESS", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_CONTACTNUMBER", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_CNIC", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_REMENAME", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_DATEOFREME", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_CUSTOMERREFERENCENUMBER", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_ACCOUNTNUMBER", OracleType.VarChar, ParameterDirection.Input, AccountNO); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_XPIN", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_COVERAMOUNT", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_EXCHANGERATE", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_TRANSAMOUNT", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_BANK", OracleType.VarChar, ParameterDirection.Input, ""); 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_BRANCH_NAME", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_BRANCH_ADDRESS", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_FXCODE", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parm[pno] = new OracleParameter(); parm[pno] = _dbConfig.Oracle_Param("P_COUNTRY", 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, Type); pno++; 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("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.Oracle_GetDataSetSP_DML("SP_Data_Segregation_updation", 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(); } //} return(v_return); }
protected void UpdateButton_Click(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { LOV_COLLECTION L = new LOV_COLLECTION(); DataSet DS; DS = L.SP_SignatorySetup_DP(((TextBox)FormView1.FindControl("TXT_SIGNATORY_NAME_EDIT")).Text, Session["SPDS_SignatorySetup_ID"].ToString()); if (DS.Tables[0].Rows.Count > 0) { ((Label)FormView1.FindControl("lblDuplicate_EDIT")).Text = "Duplicate Record"; } else { //SP_SET_UPDATE_SPDS_SignSetup if (DS.Tables[0].Rows.Count <= 0) { string v_return = ""; OracleParameter[] parm = new OracleParameter[7]; int pno = 0; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_ID", OracleType.VarChar, ParameterDirection.Input, Session["SPDS_SignatorySetup_ID"].ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_SIGNATORY_NAME", OracleType.VarChar, ParameterDirection.Input, ((TextBox)FormView1.FindControl("TXT_SIGNATORY_NAME_EDIT")).Text); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_UPLOAD_IMAGE_PATH", OracleType.VarChar, ParameterDirection.Input, ((FileUpload)FormView1.FindControl("TXT_UPLOAD_IMAGE_PATH_EDIT")).FileName.ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_CURRENT_STATUS", OracleType.VarChar, ParameterDirection.Input, ((DropDownList)FormView1.FindControl("DDL_CURRENT_STATUS_EDIT")).SelectedValue); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_UPLOAD_IMAGE", OracleType.Blob, ParameterDirection.Input, ((FileUpload)FormView1.FindControl("TXT_UPLOAD_IMAGE_PATH_EDIT")).FileBytes); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_E_UserID", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("V_RETURN", OracleType.VarChar, ParameterDirection.Output, ""); v_return = obj_DBLayer.Oracle_GetDataSetSP_DML("SP_SET_UPDATE_SPDS_SignSetup", parm, pno); if (v_return.StartsWith("0")) { ((FileUpload)FormView1.FindControl("TXT_UPLOAD_IMAGE_PATH_EDIT")).SaveAs(Server.MapPath("~") + "\\SignatureImage\\" + ((FileUpload)FormView1.FindControl("TXT_UPLOAD_IMAGE_PATH_EDIT")).FileName.ToString()); BackPage(); } else { ((Label)FormView1.FindControl("lblDuplicate_EDIT")).Text = v_return.Replace("1;", ""); } } else { ((TextBox)FormView1.FindControl("TXT_SIGNATORY_NAME_EDIT")).Text = ""; ((RequiredFieldValidator)FormView1.FindControl("REQ_Name_EDIT")).Validate(); } } } }
protected void UpdateButton_Click(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { LOV_COLLECTION L = new LOV_COLLECTION(); DataSet DS; DS = L.SP_SignatorySetup_DP(TXT_SIGNATORY_NAME_INSERT.Text, Session["SPDS_SignatorySetup_ID"].ToString()); if (DS.Tables[0].Rows.Count > 0) { lblDuplicate_INSERT.Text = "Duplicate Record"; } else { if (Path.GetExtension(TXT_UPLOAD_IMAGE_PATH_INSERT.FileName.ToLower()) == ".jpg") { if (DS.Tables[0].Rows.Count <= 0) { string v_return = ""; OracleParameter[] parm = new OracleParameter[7]; int pno = 0; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_ID", OracleType.VarChar, ParameterDirection.Input, Session["SPDS_SignatorySetup_ID"].ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_SIGNATORY_NAME", OracleType.VarChar, ParameterDirection.Input, TXT_SIGNATORY_NAME_INSERT.Text); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_UPLOAD_IMAGE_PATH", OracleType.VarChar, ParameterDirection.Input, TXT_UPLOAD_IMAGE_PATH_INSERT.FileName.ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_CURRENT_STATUS", OracleType.VarChar, ParameterDirection.Input, DDL_CURRENT_STATUS_INSERT.SelectedValue); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_UPLOAD_IMAGE", OracleType.Blob, ParameterDirection.Input, TXT_UPLOAD_IMAGE_PATH_INSERT.FileBytes); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("v_E_UserID", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString()); pno++; parm[pno] = new OracleParameter(); parm[pno] = obj_DBLayer.Oracle_Param("V_RETURN", OracleType.VarChar, ParameterDirection.Output, ""); v_return = obj_DBLayer.Oracle_GetDataSetSP_DML("SP_SET_UPDATE_SPDS_SignSetup", parm, pno); if (v_return.StartsWith("0")) { TXT_UPLOAD_IMAGE_PATH_INSERT.SaveAs(Server.MapPath("~") + "\\SignatureImage\\" + TXT_UPLOAD_IMAGE_PATH_INSERT.FileName.ToString()); } else { lblDuplicate_INSERT.Text = v_return.Replace("1;", ""); } Response.Redirect("../SignatorySetup/frmSPDS_SignatorySetup.aspx?s1=" + Request.QueryString[0].ToString()); } else { TXT_SIGNATORY_NAME_INSERT.Text = ""; } } else { lblDuplicate_INSERT.Text = "Select JPG image file"; return; } } } }
void DMLOperation(string Action) { OracleParameter[] parms = new OracleParameter[15]; for (int i = 0; i < grd_matrix.Rows.Count; i++) { 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(); } } }