/// <summary>
///
/// </summary>
/// <param name="titleOfTableDesired"></param>
/// <param name="caseID"></param>
/// <param name="userID"></param>
/// <param name="edipi"></param>
/// <param name="branchID"></param>
/// <param name="relationshipID"></param>
/// <returns></returns>
public DataSet GetInfo2(String titleOfTableDesired, Int64 caseID, Int64 userID, String edipi, Int64 branchID, Int64 relationshipID)
{
DataSet test= GetInfo2_NEW( titleOfTableDesired, caseID, userID, edipi, branchID, relationshipID);
return test;
NMOOracleParameter[] Parameters = new NMOOracleParameter[7];
Parameters[0] = new NMOOracleParameter();
Parameters[0].ParameterName = "p_title";
Parameters[0].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[0].Direction = NMOParameterDirection.Input;
Parameters[0].Value = titleOfTableDesired;
Parameters[1] = new NMOOracleParameter();
Parameters[1].ParameterName = "p_case_id";
Parameters[1].OracleDbType = NMOOracleDbType.Int64;
Parameters[1].Direction = NMOParameterDirection.Input;
Parameters[1].Value = caseID;
Parameters[2] = new NMOOracleParameter();
Parameters[2].ParameterName = "p_user_id";
Parameters[2].OracleDbType = NMOOracleDbType.Int64;
Parameters[2].Direction = NMOParameterDirection.Input;
Parameters[2].Value = userID;
Parameters[3] = new NMOOracleParameter();
Parameters[3].ParameterName = "p_edipi";
Parameters[3].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[3].Direction = NMOParameterDirection.Input;
Parameters[3].Value = edipi;
Parameters[4] = new NMOOracleParameter();
Parameters[4].ParameterName = "p_branch_id";
Parameters[4].OracleDbType = NMOOracleDbType.Int64;
Parameters[4].Direction = NMOParameterDirection.Input;
Parameters[4].Value = branchID;
Parameters[5] = new NMOOracleParameter();
Parameters[5].ParameterName = "p_relationship_id";
Parameters[5].OracleDbType = NMOOracleDbType.Int64;
Parameters[5].Direction = NMOParameterDirection.Input;
Parameters[5].Value = relationshipID;
Parameters[6] = new NMOOracleParameter();
Parameters[6].ParameterName = "p_cur";
Parameters[6].OracleDbType = NMOOracleDbType.RefCursor;
Parameters[6].Direction = NMOParameterDirection.Output;
try
{
NMOOracleDatabase dbsdw1 = new NMOOracleDatabase(dbConnSdw);
dbsdw1.OpenConnection();
DataSet ds = dbsdw1.GetDataSet("PKG_ICM_UTILS.GET_INFO2", Parameters);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow r = ds.Tables[0].Rows[0];
DataRow r2 = ds.Tables[0].Rows[0];
return ds;
}
else
{
return null;
}
}
catch (Exception e)
{
logger.Fatal("BaseClass.GetInfo2 exception: " + e.Message + e.StackTrace);
throw;
}
finally
{
dbsdw1.CloseConnection();
}
}
public DataSet GetExternalDocTypes(int userID)
{
NMOOracleDatabase database = new NMOOracleDatabase(System.Configuration.ConfigurationManager.ConnectionStrings["IncapDevDb"].ToString());
NMOOracleParameter[] Parameters = new NMOOracleParameter[2];
Parameters[0] = new NMOOracleParameter();
Parameters[0].ParameterName = "p_user_id";
Parameters[0].OracleDbType = NMOOracleDbType.Int32;
Parameters[0].Direction = NMOParameterDirection.Input;
Parameters[0].Value = userID;
Parameters[1] = new NMOOracleParameter();
Parameters[1].ParameterName = "p_cur";
Parameters[1].OracleDbType = NMOOracleDbType.RefCursor;
Parameters[1].Direction = NMOParameterDirection.Output;
try
{
database.OpenConnection();
return database.GetDataSet("get_extDocTypes", Parameters);
}
catch
{
throw;
}
finally
{
database.CloseConnection();
}
}
//
//
//
public DataSet getCaseWaiverGroupsRequested(Int64 caseID, Int64 userID)
{
NMOOracleParameter[] Parameters = new NMOOracleParameter[3];
Parameters[0] = new NMOOracleParameter();
Parameters[0].ParameterName = "p_case_id";
Parameters[0].OracleDbType = NMOOracleDbType.Int64;
Parameters[0].Direction = NMOParameterDirection.Input;
Parameters[0].Value = caseID;
Parameters[1] = new NMOOracleParameter();
Parameters[1].ParameterName = "p_user_id";
Parameters[1].OracleDbType = NMOOracleDbType.Int64;
Parameters[1].Direction = NMOParameterDirection.Input;
Parameters[1].Value = userID;
Parameters[2] = new NMOOracleParameter();
Parameters[2].ParameterName = "p_cur";
Parameters[2].OracleDbType = NMOOracleDbType.RefCursor;
Parameters[2].Direction = NMOParameterDirection.Output;
using (NMOOracleDatabase dbsdw1 = new NMOOracleDatabase(dbConnSdw))
{
try
{
// dbsdw1.OpenConnection();
return dbsdw1.GetDataSet("PKG_ICM_CASES.getCaseWaiverGroupsRequested", Parameters);
}
catch (Exception e)
{
logger.Fatal("CaseClass.getCaseWaiverGroupsRequested exception: " + e.Message + e.StackTrace);
throw;
}
finally
{
dbsdw1.CloseConnection();
}
}
}
public DataSet GetAvgTimeReport(string _ReportName, int _UserID, string _FromDate, string _ToDate)
{
NMOOracleDatabase database = new NMOOracleDatabase(System.Configuration.ConfigurationManager.ConnectionStrings["IncapDevDb"].ToString());
NMOOracleParameter[] Parameters = new NMOOracleParameter[6];
Parameters[0] = new NMOOracleParameter();
Parameters[0].ParameterName = "P_REPORT_NAME";
Parameters[0].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[0].Direction = NMOParameterDirection.Input;
Parameters[0].Value = _ReportName;
Parameters[1] = new NMOOracleParameter();
Parameters[1].ParameterName = "P_USER_ID";
Parameters[1].OracleDbType = NMOOracleDbType.Int32;
Parameters[1].Direction = NMOParameterDirection.Input;
Parameters[1].Value = _UserID;
Parameters[2] = new NMOOracleParameter();
Parameters[2].ParameterName = "P_DATE_FROM";
Parameters[2].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[2].Direction = NMOParameterDirection.Input;
Parameters[2].Value = _FromDate;
Parameters[3] = new NMOOracleParameter();
Parameters[3].ParameterName = "P_DATE_TO";
Parameters[3].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[3].Direction = NMOParameterDirection.Input;
Parameters[3].Value = _ToDate;
Parameters[4] = new NMOOracleParameter();
Parameters[4].ParameterName = "p_cur";
Parameters[4].OracleDbType = NMOOracleDbType.RefCursor;
Parameters[4].Direction = NMOParameterDirection.Output;
Parameters[5] = new NMOOracleParameter();
Parameters[5].ParameterName = "p_err";
Parameters[5].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[5].Direction = NMOParameterDirection.Output;
Parameters[5].Size = 4000;
try
{
database.OpenConnection();
return database.GetDataSet("GET_AVG_TIME_REPORT", Parameters);
}
catch
{
throw;
}
finally
{
database.CloseConnection();
}
}
public DataSet GetData(string titleOfTableDesired)
{
NMOOracleDatabase database = new NMOOracleDatabase(System.Configuration.ConfigurationManager.ConnectionStrings["IncapDevDb"].ToString());
NMOOracleParameter[] Parameters = new NMOOracleParameter[2];
Parameters[0] = new NMOOracleParameter();
Parameters[0].ParameterName = "p_title";
Parameters[0].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[0].Direction = NMOParameterDirection.Input;
Parameters[0].Value = titleOfTableDesired;
Parameters[1] = new NMOOracleParameter();
Parameters[1].ParameterName = "p_cur";
Parameters[1].OracleDbType = NMOOracleDbType.RefCursor;
Parameters[1].Direction = NMOParameterDirection.Output;
try
{
database.OpenConnection();
return database.GetDataSet("get_data", Parameters);
}
catch
{
throw;
}
finally
{
database.CloseConnection();
}
}
public DataSet GetSearch(string searchType, string searchTerm)
{
searchTerm = searchTerm.Replace("'", "''");
NMOOracleDatabase database = new NMOOracleDatabase(System.Configuration.ConfigurationManager.ConnectionStrings["IncapDevDb"].ToString());
NMOOracleParameter[] Parameters = new NMOOracleParameter[6];
Parameters[0] = new NMOOracleParameter();
Parameters[0].ParameterName = "p_search_type";
Parameters[0].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[0].Direction = NMOParameterDirection.Input;
Parameters[0].Value = searchType;
Parameters[1] = new NMOOracleParameter();
Parameters[1].ParameterName = "p_search_term";
Parameters[1].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[1].Direction = NMOParameterDirection.Input;
Parameters[1].Value = searchTerm;
Parameters[2] = new NMOOracleParameter();
Parameters[2].ParameterName = "p_cur_dependent";
Parameters[2].OracleDbType = NMOOracleDbType.RefCursor;
Parameters[2].Direction = NMOParameterDirection.Output;
Parameters[2].Size = 128;
Parameters[3] = new NMOOracleParameter();
Parameters[3].ParameterName = "p_cur_sponsor";
Parameters[3].OracleDbType = NMOOracleDbType.RefCursor;
Parameters[3].Direction = NMOParameterDirection.Output;
Parameters[3].Size = 128;
Parameters[4] = new NMOOracleParameter();
Parameters[4].ParameterName = "p_cur_user";
Parameters[4].OracleDbType = NMOOracleDbType.RefCursor;
Parameters[4].Direction = NMOParameterDirection.Output;
Parameters[4].Size = 128;
Parameters[5] = new NMOOracleParameter();
Parameters[5].ParameterName = "p_cur_case";
Parameters[5].OracleDbType = NMOOracleDbType.RefCursor;
Parameters[5].Direction = NMOParameterDirection.Output;
Parameters[5].Size = 128;
try
{
database.OpenConnection();
return database.GetDataSet("get_search", Parameters);
}
catch
{
throw;
}
finally
{
database.CloseConnection();
}
}
public DataSet GetAReport(string _ReportName, int _UserID, string _FromDate, string _ToDate, int service, int dod_status,
int dod_component)
{
NMOOracleDatabase database = new NMOOracleDatabase(System.Configuration.ConfigurationManager.ConnectionStrings["IncapDevDb"].ToString());
NMOOracleParameter[] Parameters = new NMOOracleParameter[9];
Parameters[0] = new NMOOracleParameter();
Parameters[0].ParameterName = "P_REPORT_NAME";
Parameters[0].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[0].Direction = NMOParameterDirection.Input;
Parameters[0].Value = _ReportName;
Parameters[1] = new NMOOracleParameter();
Parameters[1].ParameterName = "P_USER_ID";
Parameters[1].OracleDbType = NMOOracleDbType.Int32;
Parameters[1].Direction = NMOParameterDirection.Input;
Parameters[1].Value = _UserID;
Parameters[2] = new NMOOracleParameter();
Parameters[2].ParameterName = "P_DATE_FROM";
Parameters[2].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[2].Direction = NMOParameterDirection.Input;
Parameters[2].Value = _FromDate;
Parameters[3] = new NMOOracleParameter();
Parameters[3].ParameterName = "P_DATE_TO";
Parameters[3].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[3].Direction = NMOParameterDirection.Input;
Parameters[3].Value = _ToDate;
Parameters[4] = new NMOOracleParameter();
Parameters[4].ParameterName = "p_cur";
Parameters[4].OracleDbType = NMOOracleDbType.RefCursor;
Parameters[4].Direction = NMOParameterDirection.Output;
Parameters[5] = new NMOOracleParameter();
Parameters[5].ParameterName = "p_err";
Parameters[5].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[5].Direction = NMOParameterDirection.Output;
Parameters[5].Size = 4000;
Parameters[6] = new NMOOracleParameter();
Parameters[6].ParameterName = "P_SERVICE";
Parameters[6].OracleDbType = NMOOracleDbType.Int32;
Parameters[6].Direction = NMOParameterDirection.Input;
Parameters[6].Value = service;
Parameters[7] = new NMOOracleParameter();
Parameters[7].ParameterName = "P_DOD_STATUS";
Parameters[7].OracleDbType = NMOOracleDbType.Int32;
Parameters[7].Direction = NMOParameterDirection.Input;
Parameters[7].Value = dod_status;
Parameters[8] = new NMOOracleParameter();
Parameters[8].ParameterName = "P_DOD_COMPONENT";
Parameters[8].OracleDbType = NMOOracleDbType.Int32;
Parameters[8].Direction = NMOParameterDirection.Input;
Parameters[8].Value = dod_component;
try
{
database.OpenConnection();
return database.GetDataSet("GET_A_REPORT", Parameters);
}
catch
{
throw;
}
finally
{
database.CloseConnection();
}
}
public DataSet GetRecommendationsReport(string reportMonth, int service, int dod_status, int dod_component)
{
NMOOracleDatabase database = new NMOOracleDatabase(System.Configuration.ConfigurationManager.ConnectionStrings["IncapDevDb"].ToString());
NMOOracleParameter[] Parameters = new NMOOracleParameter[5];
Parameters[0] = new NMOOracleParameter();
Parameters[0].ParameterName = "P_MONTH";
Parameters[0].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[0].Direction = NMOParameterDirection.Input;
Parameters[0].Value = reportMonth;
Parameters[1] = new NMOOracleParameter();
Parameters[1].ParameterName = "P_SERVICE";
Parameters[1].OracleDbType = NMOOracleDbType.Int32;
Parameters[1].Direction = NMOParameterDirection.Input;
Parameters[1].Value = service;
Parameters[2] = new NMOOracleParameter();
Parameters[2].ParameterName = "P_DOD_STATUS";
Parameters[2].OracleDbType = NMOOracleDbType.Int32;
Parameters[2].Direction = NMOParameterDirection.Input;
Parameters[2].Value = dod_status;
Parameters[3] = new NMOOracleParameter();
Parameters[3].ParameterName = "P_DOD_COMPONENT";
Parameters[3].OracleDbType = NMOOracleDbType.Int32;
Parameters[3].Direction = NMOParameterDirection.Input;
Parameters[3].Value = dod_component;
Parameters[4] = new NMOOracleParameter();
Parameters[4].ParameterName = "P_CUR";
Parameters[4].OracleDbType = NMOOracleDbType.RefCursor;
Parameters[4].Direction = NMOParameterDirection.Output;
try
{
database.OpenConnection();
return database.GetDataSet("GET_RECOMMENDATIONS", Parameters);
}
catch
{
throw;
}
finally
{
database.CloseConnection();
}
}
public DataSet GetPersonnelTypes()
{
NMOOracleDatabase database = new NMOOracleDatabase(System.Configuration.ConfigurationManager.ConnectionStrings["IncapDevDb"].ToString());
NMOOracleParameter[] Parameters = new NMOOracleParameter[1];
Parameters[0] = new NMOOracleParameter();
Parameters[0].ParameterName = "p_cur";
Parameters[0].OracleDbType = NMOOracleDbType.RefCursor;
Parameters[0].Direction = NMOParameterDirection.Output;
try
{
database.OpenConnection();
return database.GetDataSet("get_personnel_type", Parameters);
}
catch
{
throw;
}
finally
{
database.CloseConnection();
}
}
public DataSet GetOtherPriorities(int caseID)
{
NMOOracleDatabase database = new NMOOracleDatabase(System.Configuration.ConfigurationManager.ConnectionStrings["IncapDevDb"].ToString());
NMOOracleParameter[] Parameters = new NMOOracleParameter[2];
Parameters[0] = new NMOOracleParameter();
Parameters[0].ParameterName = "p_case_id";
Parameters[0].OracleDbType = NMOOracleDbType.Int32;
Parameters[0].Direction = NMOParameterDirection.Input;
Parameters[0].Value = caseID;
Parameters[1] = new NMOOracleParameter();
Parameters[1].ParameterName = "p_cur";
Parameters[1].OracleDbType = NMOOracleDbType.RefCursor;
Parameters[1].Direction = NMOParameterDirection.Output;
try
{
database.OpenConnection();
return database.GetDataSet("LKUP_OTHER_PRIORITIES", Parameters);
}
catch
{
throw;
}
finally
{
database.CloseConnection();
}
}
public DataSet GetOpenClosedCounts(string from, string to, int service, int dod_status, int dod_component)
{
NMOOracleDatabase database = new NMOOracleDatabase(System.Configuration.ConfigurationManager.ConnectionStrings["IncapDevDb"].ToString());
NMOOracleParameter[] Parameters = new NMOOracleParameter[6];
Parameters[0] = new NMOOracleParameter();
Parameters[0].ParameterName = "P_FROM_DATE";
Parameters[0].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[0].Direction = NMOParameterDirection.Input;
Parameters[0].Value = from;
Parameters[1] = new NMOOracleParameter();
Parameters[1].ParameterName = "P_TO_DATE";
Parameters[1].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[1].Direction = NMOParameterDirection.Input;
Parameters[1].Value = to;
Parameters[2] = new NMOOracleParameter();
Parameters[2].ParameterName = "P_SERVICE";
Parameters[2].OracleDbType = NMOOracleDbType.Int32;
Parameters[2].Direction = NMOParameterDirection.Input;
Parameters[2].Value = service;
Parameters[3] = new NMOOracleParameter();
Parameters[3].ParameterName = "P_DOD_STATUS";
Parameters[3].OracleDbType = NMOOracleDbType.Int32;
Parameters[3].Direction = NMOParameterDirection.Input;
Parameters[3].Value = dod_status;
Parameters[4] = new NMOOracleParameter();
Parameters[4].ParameterName = "P_DOD_COMPONENT";
Parameters[4].OracleDbType = NMOOracleDbType.Int32;
Parameters[4].Direction = NMOParameterDirection.Input;
Parameters[4].Value = dod_component;
Parameters[5] = new NMOOracleParameter();
Parameters[5].ParameterName = "P_CUR";
Parameters[5].OracleDbType = NMOOracleDbType.RefCursor;
Parameters[5].Direction = NMOParameterDirection.Output;
try
{
database.OpenConnection();
return database.GetDataSet("GET_OPENCLOSED", Parameters);
}
catch
{
throw;
}
finally
{
database.CloseConnection();
}
}
public DataSet GetLetterComponents(String component)
{
NMOOracleDatabase database = new NMOOracleDatabase(System.Configuration.ConfigurationManager.ConnectionStrings["IncapDB"].ToString());
NMOOracleParameter[] Parameters = new NMOOracleParameter[2];
Parameters[0] = new NMOOracleParameter();
Parameters[0].ParameterName = "p_component";
Parameters[0].OracleDbType = NMOOracleDbType.Varchar2;
Parameters[0].Direction = NMOParameterDirection.Input;
Parameters[0].Value = component;
Parameters[1] = new NMOOracleParameter();
Parameters[1].ParameterName = "p_cur";
Parameters[1].OracleDbType = NMOOracleDbType.RefCursor;
Parameters[1].Direction = NMOParameterDirection.Output;
try
{
database.OpenConnection();
return database.GetDataSet("GET_LETTER_COMPONENTS", Parameters);
}
catch
{
throw;
}
finally
{
database.CloseConnection();
}
}
