public TABLE_SPDS_DataLoadCofiguration() { OracleParameter[] PR = new OracleParameter[2]; PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "CONFIG_DEF_MASTER"); PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); SPDS_DataLoadCofiguration_DATASET = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR); }
public void dllFilename() { DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[3]; parms[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString()); parms[1] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); parms[2] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, ""); ds = _dbConfig.Oracle_GetDataSetSP("SP_DraftFileName_LOV", parms); if (ds.Tables[0].Rows.Count > 0) { ddlFile.DataSource = ds; ddlFile.DataValueField = "FILE_NAME"; ddlFile.DataTextField = "FILE_NAME"; ddlFile.DataBind(); // ddlFile.SelectedValue = "EZ REMIT.xls"; /*ViewState["dataset"] = ds; * lblTotalRecord.Text = ds.Tables[0].Rows[0]["total_records"].ToString(); * lblTotalRecord.Attributes.Add("style", "visibility:visible;"); * lblTotalFile.Attributes.Add("style", "visibility:visible;");*/ } else { ddlFile.DataSource = string.Empty; ddlFile.DataValueField = ""; ddlFile.DataTextField = ""; ddlFile.DataBind(); /*btnSubmit.Attributes.Add("style", "visibility:hidden;"); * grdTransaction.DataSource = null; * grdTransaction.DataBind();*/ } }
public DBProcess() { OracleParameter[] PR = new OracleParameter[2]; PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "filelog"); PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); ds = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR); }
private void loadGrid() { string p_return = ""; DataTable dt = new DataTable(); OracleParameter[] parms = new OracleParameter[5]; parms[0] = _dbConfig.Oracle_Param("p_custnic", OracleType.VarChar, ParameterDirection.Input, txtCNIC.Text); parms[1] = _dbConfig.Oracle_Param("p_branch_cd", OracleType.VarChar, ParameterDirection.Input, txtBranchCode.Text); parms[2] = _dbConfig.Oracle_Param("p_accno", OracleType.VarChar, ParameterDirection.Input, txtAccNo.Text); parms[3] = _dbConfig.Oracle_Param("p_iban", OracleType.VarChar, ParameterDirection.Input, txbIBAN.Text); parms[4] = _dbConfig.Oracle_Param("data_resultset", OracleType.Cursor, ParameterDirection.Output, ""); dt = _dbConfig.Oracle_GetDataSetSP("sp_core_bank_acc_enquiry", parms).Tables[0]; if (dt.Rows.Count > 0) { ViewState["TaskTable"] = dt; GridView1.DataSource = dt; GridView1.DataBind(); } else { ViewState["TaskTable"] = null; GridView1.DataSource = null; GridView1.DataBind(); lblMessage.Text = "No record found."; } }
private void loadGrid(string check) { DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[3]; int pno = 0; parms[pno] = new OracleParameter(); parms[pno] = _dbConfig.Oracle_Param("p_account_no", OracleType.VarChar, ParameterDirection.Input, txtAccountNo.Text); pno++; parms[pno] = new OracleParameter(); parms[pno] = _dbConfig.Oracle_Param("p_branch_code", OracleType.VarChar, ParameterDirection.Input, txtBranchCode.Text); pno++; parms[pno] = new OracleParameter(); parms[pno] = _dbConfig.Oracle_Param("DATA_SET", OracleType.Cursor, ParameterDirection.Output, ""); ds = _dbConfig.Oracle_GetDataSetSP("sp_depository_fetch", parms); if (ds.Tables[0].Rows.Count > 0) { DataTable dt = new DataTable(); dt = ds.Tables[0]; GridView1.DataSource = ds; GridView1.DataBind(); btnSubmit.Attributes.Add("style", "visibility:visible"); if (check != "S") { lblMessage.Text = ""; } } else if (check == "S") { GridView1.DataSource = null; GridView1.DataBind(); } else { GridView1.DataSource = null; GridView1.DataBind(); lblMessage.Text = "No data found."; } #region //if (grdTransaction.Rows.Count <= 0) //{ // DataRow dr = ds.Tables[0].NewRow(); // ds.Tables[0].Rows.Add(dr); // this.grdTransaction.DataSource = ds.Tables[0]; // this.grdTransaction.DataBind(); // this.grdTransaction.Rows[0].Cells.Clear(); // this.grdTransaction.Rows[0].Cells.Add(new TableCell()); // this.grdTransaction.Rows[0].Cells[0].ColumnSpan = grdTransaction.Rows[0].Cells.Count; // this.grdTransaction.Rows[0].Cells[0].Text = "No Record found."; //} #endregion }
public TABLE_CMN_CUST_BAL() { DataSet DS = new DataSet(); OracleParameter[] PR = new OracleParameter[2]; PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "RPS_CUSTOMER_BALANCE"); PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); dsResult = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR); }
public TABLE_SPDS_UniversalUploadCofigurationDetail() { // SPDS_UniversalUploadCofigurationDetail_DATASET = DataTransform.ReteriveDataMultiple // ("EXEC SP_GET_TABLE_STRUCT SPDS_UniversalUploadCofigurationDetail","NEW_USER_INFO"); OracleParameter[] PR = new OracleParameter[2]; PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "SPDS_UNIVUploadCofiguration"); PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); SPDS_UniversalUploadCofigurationDetail_DATASET = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR); }
public DataTable get_data_cust_fund(string p_batch_no) { DataSet ds = new DataSet(); OracleParameter[] param = new OracleParameter[2]; param[0] = _dbConfig.Oracle_Param("p_batch_no", OracleType.VarChar, ParameterDirection.Input, p_batch_no); param[1] = _dbConfig.Oracle_Param("p_dataset", OracleType.Cursor, ParameterDirection.Output, ""); ds = _dbConfig.Oracle_GetDataSetSP("sp_get_cust_funding_upd", param); return(ds.Tables[0]); }
public DataSet Get_DuplicateData(string CompanyCode, string filename) { OracleParameter[] PR = new OracleParameter[3]; PR[0] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, CompanyCode); PR[1] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, filename); PR[2] = _dbConfig.Oracle_Param("data_set", OracleType.Cursor, ParameterDirection.Output, ""); ds = _dbConfig.Oracle_GetDataSetSP("sp_get_duplicate_records", PR); ViewState["TaskTable"] = ds.Tables[0]; return(ds); }
public TABLE_SPDS_AuthorizationMatrix() { //SPDS_AuthorizationMatrix_DATASET = DataTransform.ReteriveDataMultiple // ("EXEC SP_GET_TABLE_STRUCT SPDS_AuthorizationMatrix", "NEW_USER_INFO"); OracleParameter[] PR = new OracleParameter[2]; PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "SPDS_AuthorizationMatrix"); PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); SPDS_AuthorizationMatrix_DATASET = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR); }
public TABLE_RPS_MoneyGramRemittance() { //RPS_MoneyGramRemittance_DATASET = DataTransform.ReteriveDataMultiple // ("EXEC SP_GET_TABLE_STRUCT RPS_MoneyGramRemittance","NEW_USER_INFO"); OracleParameter[] PR = new OracleParameter[2]; PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "RPS_MoneyGramRemittance"); PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); RPS_MoneyGramRemittance_DATASET = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR); }
public string GetCustomerFilePath(string ID) { OracleParameter[] PR = new OracleParameter[2]; PR[0] = DataTransform.Oracle_Param("v_ID", OracleType.VarChar, ParameterDirection.Input, ID); PR[1] = DataTransform.Oracle_Param("cv_1", OracleType.Cursor, ParameterDirection.Output, ""); DS = DataTransform.Oracle_GetDataSetSP("GetCustomerFilePath", PR); //return DS; //DS = DataTransform.ReteriveDataMultiple("EXEC GetCustomerFilePath " + ID , "GET_ALL_USER"); return(DS.Tables[0].Rows[0][0].ToString()); }
public TABLE_PRIFileSetup() { //PRIFileSetup_DATASET = DataTransform.ReteriveDataMultiple // ("EXEC SP_GET_TABLE_STRUCT PRIFileSetup", "NEW_USER_INFO"); DataSet DS = new DataSet(); OracleParameter[] PR = new OracleParameter[2]; PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "PRIFileSetup"); PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); PRIFileSetup_DATASET = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR); }
private void loadGrid(string draftno, string customerRef, string account_no) { int pno = 0; DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[7]; parms[pno] = _dbConfig.Oracle_Param("p_DRAFTNO", OracleType.VarChar, ParameterDirection.Input, draftno); pno++; parms[pno] = _dbConfig.Oracle_Param("p_CUSTREFNUMBER", OracleType.VarChar, ParameterDirection.Input, customerRef); pno++; parms[pno] = _dbConfig.Oracle_Param("p_account_no", OracleType.VarChar, ParameterDirection.Input, account_no); pno++; parms[pno] = _dbConfig.Oracle_Param("P_USER_ID", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString()); pno++; parms[pno] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parms[pno] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, ""); pno++; parms[pno] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); ds = _dbConfig.Oracle_GetDataSetSP("sp_Trans_Enquiry", parms); if (ds.Tables[0].Rows.Count > 0) { DataTable dt = new DataTable(); dt = ds.Tables[0]; ViewState["TaskTable"] = dt; GridView1.DataSource = ds; GridView1.DataBind(); lblRecord.Text = ds.Tables[0].Rows.Count.ToString() + " Record(s) found."; //btnPrint.Attributes.Add("style", "visibility:visible;"); btnPrint.Attributes.Add("style", "visibility:visible;"); } else { btnPrint.Attributes.Add("style", "visibility:hidden;"); GridView1.DataSource = null; GridView1.DataBind(); lblMessage.Text = ""; //lblMessage.Text = "No data found."; lblRecord.Text = ""; } }
public DataTable GridDataSource() { DataTable dt = new DataTable(); try { OracleParameter[] PR = new OracleParameter[4]; PR[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, ViewState["CompanyCode"].ToString() == "" ? "" : ViewState["CompanyCode"].ToString()); PR[1] = _dbConfig.Oracle_Param("p_from_dt", OracleType.VarChar, ParameterDirection.Input, txtFormDate.Text); PR[2] = _dbConfig.Oracle_Param("p_to_dt", OracleType.VarChar, ParameterDirection.Input, txtToDate.Text); PR[3] = _dbConfig.Oracle_Param("data_set", OracleType.Cursor, ParameterDirection.Output, ""); dt = _dbConfig.Oracle_GetDataSetSP("sp_core_nr_ac_satmnt_rpt", PR).Tables[0]; } catch (Exception ex) { lblMessage.Text = ex.Message; } return(dt); }
protected DataSet Fetch_DPAGE() { DatabaseConnection_Util db = new DatabaseConnection_Util(); DataSet ds = new DataSet(); OracleParameter[] param = new OracleParameter[1]; param[0] = db.Oracle_Param("data_resultset", OracleType.Cursor, ParameterDirection.Output, ""); ds = db.Oracle_GetDataSetSP("sp_web_setup_getdpage", param); return(ds); }
private void loadGrid() { DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[8]; parms[0] = new OracleParameter(); parms[0] = _dbConfig.Oracle_Param("P_Accountnumber", OracleType.VarChar, ParameterDirection.Input, txtAccountNo.Text); parms[1] = new OracleParameter(); parms[1] = _dbConfig.Oracle_Param("P_custnic", OracleType.VarChar, ParameterDirection.Input, txtCNIC.Text); parms[2] = new OracleParameter(); parms[2] = _dbConfig.Oracle_Param("P_accounttitle", OracleType.VarChar, ParameterDirection.Input, txtAccountTitle.Text); parms[3] = new OracleParameter(); parms[3] = _dbConfig.Oracle_Param("P_branch_code", OracleType.VarChar, ParameterDirection.Input, txtBranchCode.Text); parms[4] = new OracleParameter(); parms[4] = _dbConfig.Oracle_Param("p_branch_loc", OracleType.VarChar, ParameterDirection.Input, txtBrLocation.Text); parms[5] = new OracleParameter(); parms[5] = _dbConfig.Oracle_Param("p_branch_city", OracleType.VarChar, ParameterDirection.Input, txtCity.Text); parms[6] = new OracleParameter(); parms[6] = _dbConfig.Oracle_Param("p_type", OracleType.VarChar, ParameterDirection.Input, ViewState["TYPE"].ToString()); parms[7] = new OracleParameter(); parms[7] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); ds = _dbConfig.Oracle_GetDataSetSP("ENQUIRY_DATA", parms); if (ds.Tables[0].Rows.Count > 0) { DataTable dt = new DataTable(); dt = ds.Tables[0]; ViewState["TaskTable"] = dt; GridView1.DataSource = ds; GridView1.DataBind(); lblRecord.Text = ds.Tables[0].Rows.Count.ToString() + " Record(s) found."; //btnPrint.Attributes.Add("style", "visibility:visible;"); btnPrint.Attributes.Add("style", "visibility:visible;"); } else { btnPrint.Attributes.Add("style", "visibility:hidden;"); GridView1.DataSource = null; GridView1.DataBind(); lblMessage.Text = ""; //lblMessage.Text = "No data found."; lblRecord.Text = ""; } }
public void Get_data(string draftno, string remitterrefno, string company_code) { DataSet dsReport = new DataSet(); OracleParameter[] parm = new OracleParameter[5]; parm[0] = _dbConfig.Oracle_Param("p_draftno", OracleType.VarChar, ParameterDirection.Input, draftno); parm[1] = _dbConfig.Oracle_Param("p_customerref", OracleType.VarChar, ParameterDirection.Input, remitterrefno); parm[2] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, company_code); parm[3] = _dbConfig.Oracle_Param("p_userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString()); parm[4] = _dbConfig.Oracle_Param("cv_1", OracleType.Cursor, ParameterDirection.Output, ""); DataSet ds = _dbConfig.Oracle_GetDataSetSP("rps_sp_draft_getallforcancel", parm); if (ds.Tables[0].Rows.Count > 0) { GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } else { GridView1.DataSource = null; GridView1.DataBind(); } }
private void loadGrid(string draft_no, string reference_no, string account_no, string user_id, string company_code) { int pno = 0; DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[7]; parms[pno] = _dbConfig.Oracle_Param("p_DRAFTNO", OracleType.VarChar, ParameterDirection.Input, draft_no); pno++; parms[pno] = _dbConfig.Oracle_Param("p_CUSTREFNUMBER", OracleType.VarChar, ParameterDirection.Input, reference_no); pno++; parms[pno] = _dbConfig.Oracle_Param("p_account_no", OracleType.VarChar, ParameterDirection.Input, account_no); pno++; parms[pno] = _dbConfig.Oracle_Param("P_USER_ID", OracleType.VarChar, ParameterDirection.Input, user_id); pno++; parms[pno] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, company_code); pno++; parms[pno] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, ""); pno++; parms[pno] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); ds = _dbConfig.Oracle_GetDataSetSP("sp_Trans_Enquiry", parms); if (ds.Tables[0].Rows.Count > 0) { lbl_CompanyCode.Text = ds.Tables[0].Rows[0]["company_code"].ToString(); lbl_CompanyName.Text = ds.Tables[0].Rows[0]["company_name"].ToString(); lbl_DraftNo.Text = ds.Tables[0].Rows[0]["draftno"].ToString(); lbl_Amount.Text = ds.Tables[0].Rows[0]["draftamount"].ToString(); lbl_TransNo.Text = ds.Tables[0].Rows[0]["trans_no"].ToString(); lbl_TransactionDate.Text = ds.Tables[0].Rows[0]["draftdate"].ToString(); lbl_CustomerRef.Text = ds.Tables[0].Rows[0]["CUSTREFNUMBER"].ToString(); lbl_PaymentDate.Text = ds.Tables[0].Rows[0]["E_DATETIME"].ToString(); lbl_TransType.Text = ds.Tables[0].Rows[0]["trans_type"].ToString(); lbl_TransferMethod.Text = ds.Tables[0].Rows[0]["transfer_method"].ToString(); lbl_BeneficiaryName.Text = ds.Tables[0].Rows[0]["bene_name"].ToString(); lbl_BeneficiaryAddress.Text = ds.Tables[0].Rows[0]["bene_address"].ToString(); lbl_AccountNo.Text = ds.Tables[0].Rows[0]["ACCOUNTNO"].ToString(); lbl_CNIC.Text = ds.Tables[0].Rows[0]["NICNO"].ToString(); lbl_ContactNo.Text = ds.Tables[0].Rows[0]["PHONENO"].ToString(); lbl_PayeeBranch.Text = ds.Tables[0].Rows[0]["paybranchid"].ToString(); lbl_BankCode.Text = ds.Tables[0].Rows[0]["correspondingbankid"].ToString(); lbl_BankName.Text = ds.Tables[0].Rows[0]["bank_name"].ToString(); lbl_BranchCode.Text = ds.Tables[0].Rows[0]["branchid"].ToString(); lbl_BranchName.Text = ds.Tables[0].Rows[0]["branch_name"].ToString(); lbl_RemitterName.Text = ds.Tables[0].Rows[0]["rem_name"].ToString(); lbl_Status.Text = ds.Tables[0].Rows[0]["STATUS"].ToString(); lbl_CancelDate.Text = ds.Tables[0].Rows[0]["canceldate"].ToString(); lbl_Remarks.Text = ds.Tables[0].Rows[0]["remarks"].ToString(); } //DataTable dt = new DataTable(); //dt = ds.Tables[0]; //ViewState["TaskTable"] = dt; //GridView1.DataSource = ds; //GridView1.DataBind(); //lblRecord.Text = ds.Tables[0].Rows.Count.ToString() + " Record(s) found."; //btnPrint.Attributes.Add("style", "visibility:visible;"); }
public void ddlCompanyName() { DataSet ds = new DataSet(); DatabaseConnection_Util DataTransform = new DatabaseConnection_Util(); OracleParameter[] PR = new OracleParameter[1]; PR[0] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); ds = DataTransform.Oracle_GetDataSetSP("GetCompanyName", PR); if (ds.Tables[0].Rows.Count > 0) { ddlCompanyCode.DataSource = ds.Tables[0]; ddlCompanyCode.DataTextField = "COMPANY_NAME"; ddlCompanyCode.DataValueField = "COMPANY_CODE"; ddlCompanyCode.DataBind(); } ddlCompanyCode.Items.Insert(0, new ListItem("All", "")); }
public void GridBind() { try { DataSet DS = new DataSet(); OracleParameter[] PR = new OracleParameter[1]; PR[0] = DataTransform.Oracle_Param("data_resultset", OracleType.Cursor, ParameterDirection.Output, ""); DS = DataTransform.Oracle_GetDataSetSP("sp_getpridatafodownload", PR); if (DS.Tables[0].Rows.Count > 0) { GridView1.DataSource = DS; GridView1.DataBind(); } else { GridView1.DataSource = null; GridView1.DataBind(); } } catch (Exception ex) { throw ex; } }
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); }
private void loadGrid() { DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[5]; parms[0] = new OracleParameter(); parms[0] = _dbConfig.Oracle_Param("p_DRAFTNO", OracleType.VarChar, ParameterDirection.Input, txtDraftNo.Text); parms[1] = new OracleParameter(); parms[1] = _dbConfig.Oracle_Param("p_CUSTREFNUMBER", OracleType.VarChar, ParameterDirection.Input, txtCustomerRef.Text); parms[2] = new OracleParameter(); parms[2] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, ""); parms[3] = new OracleParameter(); parms[3] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, ""); parms[4] = new OracleParameter(); parms[4] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); ds = _dbConfig.Oracle_GetDataSetSP("sp_Trans_Enquiry_DD", parms); if (ds.Tables[0].Rows.Count > 0) { DataTable dt = new DataTable(); dt = ds.Tables[0]; ViewState["TaskTable"] = dt; GridView1.DataSource = ds; GridView1.DataBind(); lblRecord.Text = ds.Tables[0].Rows.Count.ToString() + " Record(s) found."; btnDuplicate.Attributes.Add("style", "visibility:visible;"); } else { btnDuplicate.Attributes.Add("style", "visibility:hidden;"); GridView1.DataSource = null; GridView1.DataBind(); lblMessage.Text = ""; lblRecord.Text = ""; } }
public void FetchData() { int pno = 0; DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[3]; parms[pno] = db.Oracle_Param("p_xpin", OracleType.VarChar, ParameterDirection.Input, txtXpin.Text); pno++; parms[pno] = db.Oracle_Param("p_cust_ref_no", OracleType.VarChar, ParameterDirection.Input, txtCustomerRef.Text); pno++; parms[pno] = db.Oracle_Param("p_data_set", OracleType.Cursor, ParameterDirection.Output, ""); ds = db.Oracle_GetDataSetSP("sp_hold_trans_fetch", parms); if (ds.Tables[0].Rows.Count > 0) { GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); btnSubmit.Attributes.Add("style", "visibility:visible;"); } else { btnSubmit.Attributes.Add("style", "visibility:hidden;"); GridView1.DataSource = null; GridView1.DataBind(); } }
private void loadGridView1() { if (ddlFile.SelectedValue.ToString() != "") { DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[3]; 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_data_set", OracleType.Cursor, ParameterDirection.Output, ""); ds = _dbConfig.Oracle_GetDataSetSP("sp_get_acc_completion_publish", parms); if (ds.Tables[0].Rows.Count > 0) { GridView1.DataSource = ds; GridView1.DataBind(); lblMessage.Text = ""; lblTransaction.Text = ds.Tables[0].Rows.Count.ToString(); btnSubmit.Attributes.Add("style", "visibility:visible;"); lblFieldTrans.Attributes.Add("style", "visibility:visible;"); lblTransaction.Attributes.Add("style", "visibility:visible;"); Panel1.Visible = true; } else { Panel1.Visible = true; } } }
private void loadGrid(string check) { DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[6]; int pno = 0; parms[pno] = new OracleParameter(); parms[pno] = _dbConfig.Oracle_Param("p_benename", OracleType.VarChar, ParameterDirection.Input, txtBeneName.Text); pno++; parms[pno] = new OracleParameter(); parms[pno] = _dbConfig.Oracle_Param("p_CNIC", OracleType.VarChar, ParameterDirection.Input, txtCNIC.Text); pno++; parms[pno] = new OracleParameter(); parms[pno] = _dbConfig.Oracle_Param("p_Accountno", OracleType.VarChar, ParameterDirection.Input, txtAccountNo.Text); pno++; parms[pno] = new OracleParameter(); parms[pno] = _dbConfig.Oracle_Param("p_xpin", OracleType.VarChar, ParameterDirection.Input, txtXPIN.Text); pno++; parms[pno] = new OracleParameter(); parms[pno] = _dbConfig.Oracle_Param("p_referenceNO", OracleType.VarChar, ParameterDirection.Input, txtReferenceNo.Text); pno++; parms[pno] = new OracleParameter(); parms[pno] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); ds = _dbConfig.Oracle_GetDataSetSP("sp_dataupdate_afterpublish", parms); if (ds.Tables[0].Rows.Count > 0) { DataTable dt = new DataTable(); dt = ds.Tables[0]; ViewState["TaskTable"] = dt; GridView1.DataSource = ds; GridView1.DataBind(); Panel1.Attributes.Add("style", "visibility:visible;"); btnSubmit.Attributes.Add("style", "visibility:visible;"); if (check != "S") { lblMessage.Text = ""; } lblTransaction.Text = ds.Tables[0].Rows.Count.ToString(); lblFieldTrans.Attributes.Add("style", "visibility:visible;"); lblTransaction.Attributes.Add("style", "visibility:visible;"); } else if (check == "S") { btnSubmit.Attributes.Add("style", "visibility:hidden;"); GridView1.DataSource = null; GridView1.DataBind(); Panel1.Attributes.Add("style", "visibility:hidden;"); lblTransaction.Text = ds.Tables[0].Rows.Count.ToString(); lblFieldTrans.Attributes.Add("style", "visibility:hidden;"); lblTransaction.Attributes.Add("style", "visibility:hidden;"); } else { btnSubmit.Attributes.Add("style", "visibility:hidden;"); GridView1.DataSource = null; GridView1.DataBind(); lblMessage.Text = "No data found."; lblTransaction.Text = ds.Tables[0].Rows.Count.ToString(); lblFieldTrans.Attributes.Add("style", "visibility:hidden;"); lblTransaction.Attributes.Add("style", "visibility:hidden;"); Panel1.Attributes.Add("style", "visibility:hidden;"); } #region //if (grdTransaction.Rows.Count <= 0) //{ // DataRow dr = ds.Tables[0].NewRow(); // ds.Tables[0].Rows.Add(dr); // this.grdTransaction.DataSource = ds.Tables[0]; // this.grdTransaction.DataBind(); // this.grdTransaction.Rows[0].Cells.Clear(); // this.grdTransaction.Rows[0].Cells.Add(new TableCell()); // this.grdTransaction.Rows[0].Cells[0].ColumnSpan = grdTransaction.Rows[0].Cells.Count; // this.grdTransaction.Rows[0].Cells[0].Text = "No Record found."; //} #endregion }
public DataSet GetPRIForSymbol(string company_code, string bank_code) { if (Session["U_NAME"].ToString() == "") { lbl_msg.Text = "User session has been expired, Please Re-Login."; return(null); } DataSet DS = new DataSet(); OracleParameter[] PR = new OracleParameter[3]; PR[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, company_code); PR[1] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, bank_code); PR[2] = _dbConfig.Oracle_Param("p_dataset", OracleType.Cursor, ParameterDirection.Output, ""); DS = _dbConfig.Oracle_GetDataSetSP("sp_get_pri_postforsymbol", PR); if (DS.Tables[0].Rows.Count > 0) { GridView1.DataSource = DS.Tables[0]; GridView1.DataBind(); } else { lbl_msg.Text = "Data not found"; btnSubmit.Visible = false; } return(DS); }
private void loadGrid(string check) { 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 == null) ? "" : ddlFile.SelectedItem.ToString()); parms[2] = new OracleParameter(); parms[2] = _dbConfig.Oracle_Param("P_Trans_type", OracleType.VarChar, ParameterDirection.Input, ""); parms[3] = new OracleParameter(); parms[3] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, ""); parms[4] = new OracleParameter(); parms[4] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, ""); parms[5] = new OracleParameter(); parms[5] = _dbConfig.Oracle_Param("p_branch_code", OracleType.VarChar, ParameterDirection.Input, ""); 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, "02"); 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, ""); ds = _dbConfig.Oracle_GetDataSetSP("SP_Data_Segregation", parms); if (parms[9].Value.ToString() == "") { if (ds.Tables[0].Rows.Count > 0) { DataTable dt = new DataTable(); dt = ds.Tables[0]; ViewState["TaskTable"] = dt; grdTransaction.DataSource = ds; grdTransaction.DataBind(); onEnterPress(); ((TextBox)grdTransaction.Rows[0].FindControl("txtbandcode")).Focus(); ViewState["dsBank"] = lov.Get_PS_SP_CorrBank_LOV("%", "%").Tables[0]; if (check != "S") { lblMessage.Text = ""; } lblTransaction.Text = ds.Tables[0].Rows.Count.ToString(); btnSubmit.Attributes.Add("style", "visibility:visible;"); lblFieldTrans.Attributes.Add("style", "visibility:visible;"); lblTransaction.Attributes.Add("style", "visibility:visible;"); } else if (check == "S") { btnSubmit.Attributes.Add("style", "visibility:hidden;"); grdTransaction.DataSource = null; grdTransaction.DataBind(); lblTransaction.Text = ds.Tables[0].Rows.Count.ToString(); lblFieldTrans.Attributes.Add("style", "visibility:hidden;"); lblTransaction.Attributes.Add("style", "visibility:hidden;"); } else if (check == "Q") { btnSubmit.Attributes.Add("style", "visibility:hidden;"); grdTransaction.DataSource = null; grdTransaction.DataBind(); lblMessage.Text = "No data found."; lblTransaction.Text = ds.Tables[0].Rows.Count.ToString(); lblFieldTrans.Attributes.Add("style", "visibility:hidden;"); lblTransaction.Attributes.Add("style", "visibility:hidden;"); } } else { } }
public void dllFilename() { DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[3]; parms[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString()); parms[1] = _dbConfig.Oracle_Param("data_resultset", OracleType.Cursor, ParameterDirection.Output, ""); parms[2] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, ""); ds = _dbConfig.Oracle_GetDataSetSP("sp_data_segregation_lov_a2a", parms); if (ds.Tables[0].Rows.Count > 0) { ddlFile.DataSource = ds.Tables[0]; ddlFile.DataValueField = "file_name"; ddlFile.DataTextField = "file_name"; ddlFile.DataBind(); ViewState["dataset"] = ds; lblTotalRecord.Text = ds.Tables[0].Rows[0]["total_records"].ToString(); lblTotalRecord.Attributes.Add("style", "visibility:visible;"); lblTotalFile.Attributes.Add("style", "visibility:visible;"); } else { ddlFile.DataSource = ""; ddlFile.DataValueField = ""; ddlFile.DataTextField = ""; ddlFile.DataBind(); GridView1.DataSource = null; GridView1.DataBind(); lblTotalRecord.Attributes.Add("style", "visibility:hidden;"); lblTotalFile.Attributes.Add("style", "visibility:hidden;"); lblTransaction.Attributes.Add("style", "visibility:hidden;"); lblFieldTrans.Attributes.Add("style", "visibility:hidden;"); } }
private void loadGrid(string check) { 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 == null) ? "" : ddlCompanyCode.SelectedValue.ToString()); parms[1] = new OracleParameter(); parms[1] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, (ddlFile.SelectedItem == null) ? "" : ddlFile.SelectedItem.ToString()); parms[2] = new OracleParameter(); parms[2] = _dbConfig.Oracle_Param("P_Trans_type", OracleType.VarChar, ParameterDirection.Input, ""); parms[3] = new OracleParameter(); parms[3] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, ""); parms[4] = new OracleParameter(); parms[4] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, ""); parms[5] = new OracleParameter(); parms[5] = _dbConfig.Oracle_Param("p_branch_code", OracleType.VarChar, ParameterDirection.Input, ""); parms[6] = new OracleParameter(); parms[6] = _dbConfig.Oracle_Param("P_Userid", OracleType.VarChar, ParameterDirection.Input, "ADMIN1");//Session["U_NAME"].ToString() parms[7] = new OracleParameter(); parms[7] = _dbConfig.Oracle_Param("P_type", OracleType.VarChar, ParameterDirection.Input, "01"); 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, ""); ds = _dbConfig.Oracle_GetDataSetSP("SP_Data_Segregation", parms); if (parms[9].Value.ToString() == "") { if (ds.Tables[0].Rows.Count > 0) { DataTable dt = new DataTable(); dt = ds.Tables[0]; ViewState["TaskTable"] = dt; GridView1.DataSource = ds; //GridView1.PageSize = 10; GridView1.DataBind(); btnSubmit.Attributes.Add("style", "visibility:visible;"); if (check != "S") { lblMessage.Text = ""; } lblTransaction.Text = ds.Tables[0].Rows.Count.ToString(); lblFieldTrans.Attributes.Add("style", "visibility:visible;"); lblTransaction.Attributes.Add("style", "visibility:visible;"); } else if (check == "S") { btnSubmit.Attributes.Add("style", "visibility:hidden;"); GridView1.DataSource = null; GridView1.DataBind(); lblTransaction.Text = ds.Tables[0].Rows.Count.ToString(); lblFieldTrans.Attributes.Add("style", "visibility:hidden;"); lblTransaction.Attributes.Add("style", "visibility:hidden;"); } else { btnSubmit.Attributes.Add("style", "visibility:hidden;"); GridView1.DataSource = null; GridView1.DataBind(); lblMessage.Text = "No data found."; lblTransaction.Text = ds.Tables[0].Rows.Count.ToString(); lblFieldTrans.Attributes.Add("style", "visibility:hidden;"); lblTransaction.Attributes.Add("style", "visibility:hidden;"); } } else { } //if (check == "S") //{ // btnSubmit.Attributes.Add("style", "visibility:hidden;"); // GridView1.DataSource = null; // GridView1.DataBind(); // lblTransaction.Text = ds.Tables[0].Rows.Count.ToString(); // lblFieldTrans.Attributes.Add("style", "visibility:hidden;"); // lblTransaction.Attributes.Add("style", "visibility:hidden;"); //} //ds = _dbConfig.Oracle_GetDataSetSP("SP_Data_Segregation", parms); //this.grdTransaction.DataSource = ds.Tables[0]; //this.grdTransaction.DataBind(); //if (grdTransaction.Rows.Count <= 0) //{ // DataRow dr = ds.Tables[0].NewRow(); // ds.Tables[0].Rows.Add(dr); // grdTransaction.DataSource = ds.Tables[0]; // grdTransaction.DataBind(); // int NewCell = grdTransaction.Rows[0].Cells.Count; // grdTransaction.Rows[0].Cells.Clear(); // grdTransaction.Rows[0].Cells.Add(new TableCell()); // grdTransaction.Rows[0].Cells[0].ColumnSpan = NewCell; // grdTransaction.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center; // grdTransaction.Rows[0].Cells[0].Text = "No Record found."; //} //else //{ //} }