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;"); } }
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); }
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", parms); if (ds.Tables[0].Rows.Count > 0) { ddlFile.DataSource = ds; 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 = string.Empty; ddlFile.DataValueField = ""; ddlFile.DataTextField = ""; ddlFile.DataBind(); btnSubmit.Attributes.Add("style", "visibility:hidden;"); grdTransaction.DataSource = null; grdTransaction.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; } } }
public void dllFilename() { DataSet ds = new DataSet(); DataRow dr = null; 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) { DataTable dt = new DataTable(); dr = ds.Tables[0].NewRow(); dr[0] = "AAA"; dr[1] = "Select"; dr[2] = "Select"; dr[3] = "0"; ds.Tables[0].Rows.Add(dr); dt = ds.Tables[0]; dt.DefaultView.Sort = "Company_Code ASC"; dt = dt.DefaultView.ToTable(); ddlFile.DataSource = dt; ddlFile.DataValueField = "FILE_NAME"; ddlFile.DataTextField = "FILE_NAME"; ddlFile.DataBind(); ViewState["dataset"] = dt; lblTotalRecord.Text = dt.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(); btnSubmit.Attributes.Add("style", "visibility:hidden;"); 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;"); lblStart.Attributes.Add("style", "visibility:hidden;"); lblStartTrans.Attributes.Add("style", "visibility:hidden;"); lblEnd.Attributes.Add("style", "visibility:hidden;"); lblEndTrans.Attributes.Add("style", "visibility:hidden;"); } }
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 DataSet GetPRITransForUnpaid(string draftno, string cust_refno, string action) { 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[4]; PR[0] = _dbConfig.Oracle_Param("p_draftno", OracleType.VarChar, ParameterDirection.Input, draftno); PR[1] = _dbConfig.Oracle_Param("p_cust_refno", OracleType.VarChar, ParameterDirection.Input, cust_refno); PR[2] = _dbConfig.Oracle_Param("p_action", OracleType.VarChar, ParameterDirection.Input, action); PR[3] = _dbConfig.Oracle_Param("p_dataset", OracleType.Cursor, ParameterDirection.Output, ""); DS = _dbConfig.Oracle_GetDataSetSP("sp_get_pri_trans_for_unpaid", PR); if (DS.Tables[0].Rows.Count > 0) { GridView1.DataSource = DS.Tables[0]; GridView1.DataBind(); } else { GridView1.DataSource = null; GridView1.DataBind(); btnUnpaid.Visible = false; } return(DS); }
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 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 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); }
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 }
protected void btnRollBack_Click(object sender, EventArgs e) { try { string p_return = ""; DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[10]; 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, ViewState["fileName"].ToString()); parms[2] = _dbConfig.Oracle_Param("P_Trans_type", OracleType.VarChar, ParameterDirection.Input, ""); parms[3] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, ""); parms[4] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, ""); parms[5] = _dbConfig.Oracle_Param("p_branch_code", OracleType.VarChar, ParameterDirection.Input, ""); parms[6] = _dbConfig.Oracle_Param("P_Userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString()); parms[7] = _dbConfig.Oracle_Param("P_type", OracleType.VarChar, ParameterDirection.Input, "16"); parms[8] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); parms[9] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, ""); ds = _dbConfig.Oracle_GetDataSetSP("SP_Data_Segregation", parms); p_return = ds.Tables[0].Rows[0][0].ToString().Split(';').GetValue(1).ToString(); lbl_Message.Text = p_return; Databind(ddlCompanyCode.SelectedValue, ViewState["fileName"].ToString()); lblIBFT.Text = ""; lblA2A.Text = ""; lblPRI.Text = ""; lblCOC.Text = ""; lblDD.Text = ""; lblDuplicateRecords.Text = ""; lblInvalidIBANRecords.Text = ""; lblTotalRecord.Text = ""; lblTotalAmount.Text = ""; lblIBFTTOT.Text = ""; lblA2ATOT.Text = ""; lblPRITOT.Text = ""; lblCOCTOT.Text = ""; lblDDTOT.Text = ""; lblDUPTOT.Text = ""; lblIBANTOT.Text = ""; } catch (Exception ex) { lbl_Message.Text = ex.Message; } }
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); }
private void GetStatusCodeBind() { DataSet dsReport = new DataSet(); OracleParameter[] parm = new OracleParameter[3]; parm[0] = _dbConfig.Oracle_Param("v_StatusCode", OracleType.VarChar, ParameterDirection.Input, "%"); parm[1] = _dbConfig.Oracle_Param("v_Description", OracleType.VarChar, ParameterDirection.Input, "%"); parm[2] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); DataSet ds = _dbConfig.Oracle_GetDataSetSP("SP_RPS_DetailStatus_LOV", parm); if (ds.Tables[0].Rows.Count > 0) { ddlCancelCode.DataSource = ds.Tables[0]; ddlCancelCode.DataTextField = "DESCRIPTION"; ddlCancelCode.DataValueField = "code"; ddlCancelCode.DataBind(); } }
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); }
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 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 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_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 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); }
private void loadGrid(string type) { DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[6]; 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_USER_ID", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString()); parms[3] = new OracleParameter(); parms[3] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, ""); parms[4] = new OracleParameter(); parms[4] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, ""); parms[5] = new OracleParameter(); parms[5] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); ds = _dbConfig.Oracle_GetDataSetSP("sp_afterPublish_fetch", 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 = dt.Rows.Count.ToString() + " Record(s) found."; if (type == "E") { lblMessage.Text = lblMessage.Text; } else { lblMessage.Text = ""; } //btnPrint.Attributes.Add("style", "visibility:visible;"); //btnPrint.Attributes.Add("style", "visibility:visible;"); } else { //btnPrint.Attributes.Add("style", "visibility:hidden;"); GridView1.DataSource = null; GridView1.DataBind(); lblRecord.Text = ""; lblMessage.Text = "No data found."; } }
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() { 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 = ""; } }
private void loadGrid(string file_name) { int pno = 0; DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[10]; parms[pno] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue); pno++; parms[pno] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, file_name); pno++; parms[pno] = _dbConfig.Oracle_Param("P_Trans_type", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parms[pno] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parms[pno] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parms[pno] = _dbConfig.Oracle_Param("p_branch_code", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parms[pno] = _dbConfig.Oracle_Param("P_Userid", OracleType.VarChar, ParameterDirection.Input, ""); pno++; parms[pno] = _dbConfig.Oracle_Param("P_type", OracleType.VarChar, ParameterDirection.Input, "09"); pno++; parms[pno] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); pno++; parms[pno] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, ""); ds = _dbConfig.Oracle_GetDataSetSP("SP_Data_Segregation", parms); if (parms[pno].Value.ToString() == "") { if (ds.Tables[0].Rows.Count > 0) { DataTable dt = new DataTable(); dt = ds.Tables[0]; GridView1.DataSource = ds; GridView1.DataBind(); lblMessage.Text = ""; } else { GridView1.EmptyDataText = "DATA NOT FOUND"; GridView1.DataSource = null; GridView1.DataBind(); } } else { lblMessage.Text = parms[pno].Value.ToString(); } }
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 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 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 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); }
public void executeStatusData(string filename) { DataSet ds = new DataSet(); OracleParameter[] parms = new OracleParameter[2]; parms[0] = db.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, filename); parms[1] = db.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); ds = db.Oracle_GetDataSetSP("sp_cancelwhoxpin_status", parms); if (ds.Tables[0].Rows.Count > 0) { GridView1.DataSource = ds; GridView1.DataBind(); } else { GridView1.DataSource = null; GridView1.DataBind(); } }