public DataSet AppTM06SearchByStatus(int p_status, string p_languagecode)
{
try
{
DataSet _ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "pkg_app_detail_tm06dkqt.PROC_APP_TM06_SEARCH",
new OracleParameter("P_STATUS", OracleDbType.Decimal, p_status, ParameterDirection.Input),
new OracleParameter("P_LANGUAGECODE", OracleDbType.Varchar2, p_languagecode, ParameterDirection.Input),
new OracleParameter("P_CURSOR", OracleDbType.RefCursor, ParameterDirection.Output)
);
return(_ds);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}
public DataSet Todo_GetByAppId(decimal p_app_id, string p_processor_by)
{
try
{
DataSet _ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "PKG_TODOS.proc_Todo_GetByApp_Id",
new OracleParameter("p_app_id", OracleDbType.Decimal, p_app_id, ParameterDirection.Input),
new OracleParameter("p_processor_by", OracleDbType.Varchar2, p_processor_by, ParameterDirection.Input),
new OracleParameter("P_CURSOR", OracleDbType.RefCursor, ParameterDirection.Output)
);
return(_ds);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}
public DataSet NotifiGetByCasecode(string p_key_search)
{
try
{
DataSet _ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "PKG_TODOS.PROC_NOTIFI_GETBY_APPS",
new OracleParameter("P_KEY_SEARCH", OracleDbType.Varchar2, p_key_search, ParameterDirection.Input),
new OracleParameter("P_CURSOR", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("P_CURSOR_RIMIND", OracleDbType.RefCursor, ParameterDirection.Output)
);
return(_ds);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}
public int Search_Fee_Delete(decimal p_search_id, string pLanguage)
{
try
{
var paramReturn = new OracleParameter("p_return", OracleDbType.Int32, ParameterDirection.Output);
OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "pkg_search_fee.proc_delete_BySearchId",
new OracleParameter("p_search_id", OracleDbType.Decimal, p_search_id, ParameterDirection.Input),
paramReturn);
var result = Convert.ToInt32(paramReturn.Value.ToString());
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
public DataSet Billing_GetBy_Code(string p_case_code, string p_language_code)
{
try
{
return(OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "pkg_billing.proc_billing_getbycode",
new OracleParameter("p_case_code", OracleDbType.Varchar2, p_case_code, ParameterDirection.Input),
new OracleParameter("p_language_code", OracleDbType.Varchar2, p_language_code, ParameterDirection.Input),
new OracleParameter("p_cursor", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("p_cursor_detail", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("p_cursor_header", OracleDbType.RefCursor, ParameterDirection.Output)));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}
public DataSet Email_GetBy_Id(decimal p_id, string p_case_code, string p_language_code)
{
try
{
DataSet _ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "pkg_send_email.proc_getby_id",
new OracleParameter("p_id", OracleDbType.Decimal, p_id, ParameterDirection.Input),
new OracleParameter("p_case_code", OracleDbType.Varchar2, p_case_code, ParameterDirection.Input),
new OracleParameter("p_language_code", OracleDbType.Varchar2, p_language_code, ParameterDirection.Input),
new OracleParameter("p_cursor", OracleDbType.RefCursor, ParameterDirection.Output));
return(_ds);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}
public DataSet AppDetail_GetBy_Id(string p_appcode, decimal p_app_header_id)
{
try
{
return(OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "pkg_app_translate.proc_app_getby_app_id",
new OracleParameter("p_appcode", OracleDbType.Varchar2, p_appcode, ParameterDirection.Input),
new OracleParameter("p_app_header_id", OracleDbType.Decimal, p_app_header_id, ParameterDirection.Input),
new OracleParameter("p_cursor", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("p_cursor_detail", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("p_cursor_class", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("p_cursor_other_doc", OracleDbType.RefCursor, ParameterDirection.Output)));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}
public DataSet WikiVoting(decimal P_DOCID, string P_USERID, decimal P_POINT)
{
try
{
DataSet _Ds = new DataSet();
_Ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "PKG_WIKI_PORTAL.PROC_VOTING",
new OracleParameter("P_DOCID", OracleDbType.Decimal, P_DOCID, ParameterDirection.Input),
new OracleParameter("P_USERID", OracleDbType.Varchar2, P_USERID, ParameterDirection.Input),
new OracleParameter("P_POINT", OracleDbType.Decimal, P_POINT, ParameterDirection.Input),
new OracleParameter("P_CURSOR", OracleDbType.RefCursor, ParameterDirection.Output));
return(_Ds);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}
public DataSet GetByID(decimal p_app_header_id, string p_language_code)
{
try
{
DataSet _ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "pkg_app_detail_plb01_sdd.Proc_GetBy_ID",
new OracleParameter("p_app_header_id", OracleDbType.Decimal, p_app_header_id, ParameterDirection.Input),
new OracleParameter("p_language_code", OracleDbType.Varchar2, p_language_code, ParameterDirection.Input),
new OracleParameter("p_cursor", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("p_cursorHeader", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("p_cursor_doc", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("p_cursor_fee", OracleDbType.RefCursor, ParameterDirection.Output));
return(_ds);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}
public int Update_Url_Billing(string p_case_code, decimal p_billing_id, string p_url_billing)
{
try
{
var paramReturn = new OracleParameter("p_return", OracleDbType.Int32, ParameterDirection.Output);
OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "PKG_SEARCH_OBJECTS.proc_update_url_billing",
new OracleParameter("p_case_code", OracleDbType.Varchar2, p_case_code, ParameterDirection.Input),
new OracleParameter("p_url_billing", OracleDbType.Varchar2, p_url_billing, ParameterDirection.Input),
new OracleParameter("p_billing_id", OracleDbType.Decimal, p_billing_id, ParameterDirection.Input),
paramReturn);
var result = Convert.ToInt32(paramReturn.Value.ToString());
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public DataSet SEARCH_HEADER_GETBYID(decimal P_ID)
{
try
{
DataSet _Ds = new DataSet();
_Ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "PKG_SEARCH_OBJECTS.PROC_SEARCH_HEADER_GETBYID",
new OracleParameter("P_SEARCH_ID", OracleDbType.Decimal, P_ID, ParameterDirection.Input),
new OracleParameter("P_CURSOR", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("P_DETAIL_CURSOR", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("P_QUETION_CURSOR", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("p_cursor_class", OracleDbType.RefCursor, ParameterDirection.Output)
);
return(_Ds);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}
public int Docking_Update_Delete(decimal p_docking_id, string p_language_code, string p_modify_by, DateTime p_modify_date)
{
try
{
var paramReturn = new OracleParameter("p_return", OracleDbType.Int32, ParameterDirection.Output);
OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "pkg_docking.proc_docking_delete",
new OracleParameter("p_docking_id", OracleDbType.Decimal, p_docking_id, ParameterDirection.Input),
new OracleParameter("p_language_code", OracleDbType.Varchar2, p_language_code, ParameterDirection.Input),
new OracleParameter("p_modify_by", OracleDbType.Varchar2, p_modify_by, ParameterDirection.Input),
new OracleParameter("p_modify_date", OracleDbType.Date, p_modify_date, ParameterDirection.Input),
paramReturn);
var result = Convert.ToInt32(paramReturn.Value.ToString());
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public DataSet AppTM06DKQTGetByID(string pAppHeaderID, string pLanguage, int pStatus)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_total_record", OracleDbType.Decimal, ParameterDirection.Output);
DataSet _ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "PKG_APP_GET_DATA.PROC_APP_TM06DKQT_GET_BY_ID",
new OracleParameter("P_APP_HEADER_ID", OracleDbType.Varchar2, pAppHeaderID, ParameterDirection.Input),
new OracleParameter("P_LANGUAGE", OracleDbType.Varchar2, pLanguage, ParameterDirection.Input),
new OracleParameter("P_STATUS", OracleDbType.Decimal, pStatus, ParameterDirection.Input),
new OracleParameter("P_CURSOR", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("P_C_DOC", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("P_C_CLASS_DETAIL", OracleDbType.RefCursor, ParameterDirection.Output)
);
return(_ds);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}
public DataSet HomeWikiDoc_Search(string p_key_search, string p_from, string p_to, string p_sort_type, ref decimal p_total_record)
{
try
{
OracleParameter paramReturn = new OracleParameter("P_TOTAL_RECORD", OracleDbType.Decimal, ParameterDirection.Output);
DataSet _ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "PKG_WIKI_DOCS.PROC_WIKI_DOC_SEARCH",
new OracleParameter("P_KEY_SEARCH", OracleDbType.Varchar2, p_key_search, ParameterDirection.Input),
new OracleParameter("P_FROM", OracleDbType.Varchar2, p_from, ParameterDirection.Input),
new OracleParameter("P_TO", OracleDbType.Varchar2, p_to, ParameterDirection.Input),
new OracleParameter("P_SORT_TYPE", OracleDbType.Varchar2, p_sort_type, ParameterDirection.Input),
paramReturn,
new OracleParameter("P_CURSOR", OracleDbType.RefCursor, ParameterDirection.Output)
);
p_total_record = Convert.ToDecimal(paramReturn.Value.ToString());
return(_ds);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}
public DataSet Lawer_Info_Search(string p_key_search, string p_from, string p_to, string p_sort_type, ref decimal p_total_record)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_total_record", OracleDbType.Decimal, ParameterDirection.Output);
DataSet _ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "pkg_lawer_info.proc_lawer_search",
new OracleParameter("p_key_search", OracleDbType.Varchar2, p_key_search, ParameterDirection.Input),
new OracleParameter("p_from", OracleDbType.Varchar2, p_from, ParameterDirection.Input),
new OracleParameter("p_to", OracleDbType.Varchar2, p_to, ParameterDirection.Input),
new OracleParameter("p_sort_type", OracleDbType.Varchar2, p_sort_type, ParameterDirection.Input),
paramReturn,
new OracleParameter("p_cursor", OracleDbType.RefCursor, ParameterDirection.Output));
p_total_record = Convert.ToDecimal(paramReturn.Value.ToString());
return(_ds);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}
public DataSet GetByID(decimal p_app_header_id, string p_language_code)
{
try
{
DataSet _ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "PKG_C08.PROC_GETBY_ID",
new OracleParameter("P_APP_HEADER_ID", OracleDbType.Decimal, p_app_header_id, ParameterDirection.Input),
new OracleParameter("P_LANGUAGE_CODE", OracleDbType.Varchar2, p_language_code, ParameterDirection.Input),
new OracleParameter("P_CURSOR", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("P_CURSORHEADER", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("P_CURSOR_DOC", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("P_CURSOR_FEE", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("P_CURSOR_OTHER_MASTER", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("P_CURSOR_OTHER_DOC", OracleDbType.RefCursor, ParameterDirection.Output)
);
return(_ds);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}
public DataSet Portal_Catalogue_Search(string keysSearch, OptionFilter options, ref int totalRecord)
{
try
{
DataSet _Ds = new DataSet();
OracleParameter paramReturn = new OracleParameter("P_TOTAL_RECORD", OracleDbType.Decimal, ParameterDirection.Output);
_Ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "PKG_WIKI_PORTAL.PROC_SEARCH_CATALOGE",
new OracleParameter("P_KEY_SEARCH", OracleDbType.Varchar2, keysSearch.ToFillKeySearch(), ParameterDirection.Input),
new OracleParameter("P_FROM", OracleDbType.Varchar2, options.StartAt.ToString(), ParameterDirection.Input),
new OracleParameter("P_TO", OracleDbType.Varchar2, options.EndAt.ToString(), ParameterDirection.Input),
new OracleParameter("P_SORT_TYPE", OracleDbType.Varchar2, options.OrderBy, ParameterDirection.Input),
paramReturn,
new OracleParameter("P_CURSOR", OracleDbType.RefCursor, ParameterDirection.Output));
totalRecord = Convert.ToInt32(paramReturn.Value.ToString());
return(_Ds);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}
public DataSet AppDDSHCNGetAll(string pName, string pPhone, int pStart, int pEnd, ref decimal pTotalRecord)
{
try
{
var paramReturn = new OracleParameter("P_RECORD", OracleDbType.Int32, ParameterDirection.Output);
DataSet ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "PKG_APP_DDSHCN.PROC_APPDDSHCN_GETALL",
new OracleParameter("P_NAME", OracleDbType.Varchar2, pName, ParameterDirection.Input),
new OracleParameter("P_PHONE", OracleDbType.Varchar2, pPhone, ParameterDirection.Input),
new OracleParameter("P_START", OracleDbType.Int32, pStart, ParameterDirection.Input),
new OracleParameter("P_END", OracleDbType.Int32, pEnd, ParameterDirection.Input),
new OracleParameter("P_CURSOR", OracleDbType.RefCursor, ParameterDirection.Output),
paramReturn
);
pTotalRecord = Convert.ToDecimal(paramReturn.Value.ToString());
return(ds);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}