// private void FillProgramCode()
// {
// System.Data.DataTable dTable;
// Oracle.DataAccess.Client.OracleConnection conn= new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
// Oracle.DataAccess.Client.OracleCommand cmd =
// new Oracle.DataAccess.Client.OracleCommand("pkg_training.program_code_list",conn);
// cmd.CommandType = System.Data.CommandType.StoredProcedure;
//
// SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd,"list_","cursor","out","");
// Oracle.DataAccess.Client.OracleDataAdapter da =
// new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
// DataSet mds=new DataSet();
// conn.Open();
// try
// {
//
// da.Fill(mds,"Purpose");
// dTable = mds.Tables["Purpose"];
// ddlProgramCode.Items.Clear();
// ddlProgramCode.Items.Add(new ListItem("---- Select ----","-1"));
// foreach (DataRow dr in dTable.Rows)
// {
// ListItem li = new ListItem(dr["description"].ToString(),dr["program_code"].ToString());
// ddlProgramCode.Items.Add(li);
// }
// }
// finally
// {
// conn.Close();
// conn.Dispose();
// cmd.Dispose();
// da.Dispose();
// mds.Dispose();
// dTable=null;
// }
// if (ddlProgramCode.Items.Count==1)
// {
// ddlProgramCode.Enabled =false;
// lblStarProgramCode.Visible = false;
// rvProgramCode.Visible = false;
// lblProgramCodeCommingSoon.Visible = true;
// }
// }
private void FillAccountNo()
{
System.Data.DataTable dTable;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd =
new Oracle.DataAccess.Client.OracleCommand("pkg_training.account_no_list", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "list_", "cursor", "out", "");
Oracle.DataAccess.Client.OracleDataAdapter da =
new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
DataSet mds = new DataSet();
conn.Open();
try
{
da.Fill(mds, "Purpose");
dTable = mds.Tables["Purpose"];
opnlstAccountNumber.Items.Clear();
foreach (DataRow dr in dTable.Rows)
{
ListItem li = new ListItem(dr["description"].ToString(), dr["account_no"].ToString());
opnlstAccountNumber.Items.Add(li);
}
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
da.Dispose();
mds.Dispose();
dTable = null;
}
}
private void FillReasonCheckBoxList()
{
System.Data.DataTable dTable;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
Oracle.DataAccess.Client.OracleCommand cmd =
new Oracle.DataAccess.Client.OracleCommand("pkg_training.reason_for_admin_partial_list", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "reason_list_", "cursor", "out", "");
Oracle.DataAccess.Client.OracleDataAdapter da =
new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
DataSet mds = new DataSet();
conn.Open();
try
{
da.Fill(mds, "Purpose");
dTable = mds.Tables["Purpose"];
chklstReasons.Items.Clear();
foreach (DataRow dr in dTable.Rows)
{
ListItem li = new ListItem(dr["description"].ToString(), dr["record_id"].ToString());
chklstReasons.Items.Add(li);
}
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
da.Dispose();
mds.Dispose();
dTable = null;
}
}
private DataTable GetData()
{
string strProcedureName = "pkg_training.reason_for_suprvsl_denial_list";
if (Request.Params["type"] == "2")
{
strProcedureName = "pkg_training.reason_for_supr_partial_list";
}
if (Request.Params["type"] == "3")
{
strProcedureName = "pkg_training.reason_for_admin_denial_list";
}
if (Request.Params["type"] == "4")
{
strProcedureName = "pkg_training.reason_for_admin_partial_list";
}
if (Request.Params["type"] == "5")
{
strProcedureName = "pkg_training_cdp.reason_for_suprvsl_denial_list";
}
System.Data.DataTable dTable;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
Oracle.DataAccess.Client.OracleCommand cmd =
new Oracle.DataAccess.Client.OracleCommand(strProcedureName, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "reason_list_", "cursor", "out", "");
Oracle.DataAccess.Client.OracleDataAdapter da =
new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
DataSet mds = new DataSet();
conn.Open();
try
{
da.Fill(mds, "Purpose");
dTable = mds.Tables["Purpose"];
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
da.Dispose();
mds.Dispose();
}
return(dTable);
}
private DataTable GetGridTable()
{
bool blnIsAll = ddlWhat.SelectedValue == "1000";
string steProcedureName = "BASDBA.pkg_training.pendig_payor_List";
if (blnIsAll)
{
steProcedureName = "BASDBA.pkg_training.payor_List";
}
DataTable tbl = null;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(steProcedureName, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "employee_number_", ViewState["Supervisor_Employee_Number"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "processing_year_", ViewState["Processing_Year"].ToString());
if (!blnIsAll)
{
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "application_status_", ddlWhat.SelectedValue);
}
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "pnding_list_", "cursor", "out", "");
DataSet mds = new DataSet();
Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
try
{
conn.Open();
da.Fill(mds);
tbl = mds.Tables[0];
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
mds.Dispose();
if (da != null)
{
da.Dispose();
}
}
return(tbl);
}
private void FillReasonCheckBoxList()
{
string strProcedureName = "pkg_training.reason_for_suprvsl_denial_list";
if (Request.Params["who"] == "payor")
{
strProcedureName = "pkg_training.reason_for_admin_denial_list";
}
else if (ViewState["Product_Code"].ToString() == "11001")
{
strProcedureName = "pkg_training_cdp.reason_for_suprvsl_denial_list";
}
System.Data.DataTable dTable;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
Oracle.DataAccess.Client.OracleCommand cmd =
new Oracle.DataAccess.Client.OracleCommand(strProcedureName, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "reason_list_", "cursor", "out", "");
Oracle.DataAccess.Client.OracleDataAdapter da =
new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
DataSet mds = new DataSet();
conn.Open();
try
{
da.Fill(mds, "Purpose");
dTable = mds.Tables["Purpose"];
chklstReasons.Items.Clear();
foreach (DataRow dr in dTable.Rows)
{
ListItem li = new ListItem(dr["description"].ToString(), dr["record_id"].ToString());
chklstReasons.Items.Add(li);
}
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
da.Dispose();
mds.Dispose();
dTable = null;
}
}
private void FillProgramCode()
{
string strCode = Request.Params["code"].ToString();
System.Data.DataTable dTable;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd =
new Oracle.DataAccess.Client.OracleCommand("pkg_training.program_code_list", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "list_", "cursor", "out", "");
Oracle.DataAccess.Client.OracleDataAdapter da =
new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
DataSet mds = new DataSet();
conn.Open();
try
{
da.Fill(mds, "Purpose");
dTable = mds.Tables["Purpose"];
optProgramCode.Items.Clear();
foreach (DataRow dr in dTable.Rows)
{
ListItem li = new ListItem(dr["program_code"].ToString() + " - " + dr["description"].ToString(), dr["program_code"].ToString() + " - " + dr["description"].ToString());
if (dr["program_code"].ToString() == strCode)
{
li.Selected = true;
}
optProgramCode.Items.Add(li);
}
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
da.Dispose();
mds.Dispose();
dTable = null;
}
}
private void FillPurposeOfTraining()
{
System.Data.DataTable dTable;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd =
new Oracle.DataAccess.Client.OracleCommand("pkg_training.getpurposeoftraininglist", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "employee_number_", ViewState["Employee_Number"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "processing_year_", ViewState["Processing_Year"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "purpose_list_", "cursor", "out", "");
Oracle.DataAccess.Client.OracleDataAdapter da =
new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
DataSet mds = new DataSet();
conn.Open();
try
{
da.Fill(mds, "Purpose");
dTable = mds.Tables["Purpose"];
ddlPurposeOfTraining.Items.Add(new ListItem("---- Select ----", "xx"));
foreach (DataRow dr in dTable.Rows)
{
ListItem li = new ListItem(dr["description"].ToString(), dr["record_id"].ToString());
ddlPurposeOfTraining.Items.Add(li);
}
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
da.Dispose();
mds.Dispose();
dTable = null;
}
}
