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