private void GetNote() { string strSQL = "select t.note,t.expense_type from trn_ee_rqst_expns t where t.record_id=" + Request.Params["rid"]; Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString); Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(strSQL, conn); conn.Open(); Oracle.DataAccess.Client.OracleDataReader reader = null; try { reader = cmd.ExecuteReader(); reader.Read(); txtDescribtion.Text = reader.GetValue(0).ToString(); lblExpenseType.Text = reader.GetValue(1).ToString(); } finally { if (reader != null) { reader.Dispose(); } cmd.Dispose(); conn.Dispose(); } txtDescribtion.Text = SQLStatic.SQL.ExecScaler(strSQL, Training_Source.TrainingClass.ConnectioString).ToString(); txtRemaining.Text = (4000 - txtDescribtion.Text.Length).ToString(); }
private void FillOneDropDown(DropDownList ddl, string strTableName) { ddl.Items.Clear(); ddl.Items.Add(new ListItem("---- Select ----", "xx")); string strSQL = "select record_id,description from " + strTableName; Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString); Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(strSQL, conn); conn.Open(); Oracle.DataAccess.Client.OracleDataReader reader = null; try { reader = cmd.ExecuteReader(); while (reader.Read()) { ListItem li = new ListItem(reader.GetValue(1).ToString(), reader.GetValue(0).ToString()); ddl.Items.Add(li); } } finally { reader.Dispose(); cmd.Dispose(); conn.Dispose(); } }
// private void SetupRollingPanel() // { // upnl.PanelSourceXml = GetRollXML(); // upnl.DataBind(); // } // private void SetupRightPanel() // { // string strXML = GetRightXML(); // if (GetRightXML() != "") // { // upRTab.PanelSourceXml = strXML; // upRTab.DataBind(); // } // } private void SetupMessages() { return; Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(ConnectionString); Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("pkg_web.get_home_page_bas_msg", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandTimeout = 30; SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "ps_session_id", Request.Cookies["Session_ID"].Value.ToString()); SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "ps_page_url", Request.Path); SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "pn_detail_id", "number", "in", 1); SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "cr", "cursor", "out", null); Oracle.DataAccess.Client.OracleDataReader reader = null; try { conn.Open(); reader = cmd.ExecuteReader(); reader.Read(); lblMessageFromBas.Text = reader.GetValue(0).ToString(); } catch {} finally { if (reader != null) { reader.Dispose(); } if (cmd != null) { cmd.Dispose(); } if (conn != null) { conn.Dispose(); } } // lblMessageFromBas.Text = SQLStatic.SQL.ExecScaler( // "select ('"+Request.Cookies["Session_ID"].Value.ToString()+"','"+Request.Path+"',1) from dual",ConnectionString).ToString(); }
private void SetEmployeeInfo() { if (ViewState["Employee_Number"].ToString() != "0") { Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(ConnectionString); Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("pkg_employee_3.employee_profile", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandTimeout = 30; SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "emplouee_number", "number", "in", ViewState["Employee_Number"].ToString()); SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "result_list_", "cursor", "out", null); Oracle.DataAccess.Client.OracleDataReader reader = null; try { conn.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { lblEEName.Text = reader.GetValue(0).ToString(); lblWorkPh.Text = reader.GetValue(1).ToString(); lblHomePh.Text = reader.GetValue(2).ToString(); lblMobilePh.Text = reader.GetValue(3).ToString(); lblHomeEmail.Text = reader.GetValue(4).ToString(); lblWorkEmail.Text = reader.GetValue(5).ToString(); lblEmployer.Text = reader.GetValue(6).ToString(); lblEmployeNo.Text = reader.GetValue(7).ToString(); lblEENumber.Text = reader.GetValue(8).ToString(); lblBenefitClass.Text = reader.GetValue(9).ToString(); lblPaySchedule.Text = reader.GetValue(10).ToString(); lblProcessingYear.Text = reader.GetValue(11).ToString(); } } finally { if (reader != null) { reader.Dispose(); } if (cmd != null) { cmd.Dispose(); } if (conn != null) { conn.Dispose(); } } } }