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 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();
}
}
}
}
// 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();
}
