public decimal Customer_Review(string p_case_code, decimal p_status, string p_notes, string p_language_code, string p_modified_by)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
paramReturn.Size = 10;
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "PKG_SEARCH_OBJECTS.proc_customer_review",
new OracleParameter("p_case_code", OracleDbType.Varchar2, p_case_code, ParameterDirection.Input),
new OracleParameter("p_status", OracleDbType.Decimal, p_status, ParameterDirection.Input),
new OracleParameter("p_notes", OracleDbType.Varchar2, p_notes, ParameterDirection.Input),
new OracleParameter("p_language_code", OracleDbType.Varchar2, p_language_code, ParameterDirection.Input),
new OracleParameter("p_modified_by", OracleDbType.Varchar2, p_modified_by, ParameterDirection.Input),
paramReturn);
return(Convert.ToDecimal(paramReturn.Value.ToString()));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public decimal App_Notice_Insert(string p_case_code, string p_notice_number, DateTime p_notice_date, decimal p_notice_type, string p_notice_url, string p_notice_trans_url,
decimal p_result, DateTime p_accept_date, DateTime p_exp_date, string p_accept_url, string p_reject_reason, decimal p_status, string p_advise_replies,
decimal p_billing_id, string p_billing_url, string p_created_by, string p_note, DateTime p_replies_deadline)
{
{
try
{
var paramReturn = new OracleParameter("p_return", OracleDbType.Int32, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_app_notice_info.Proc_App_Notice_Info_Insert",
new OracleParameter("p_case_code", OracleDbType.Varchar2, p_case_code, ParameterDirection.Input),
new OracleParameter("p_notice_number", OracleDbType.Varchar2, p_notice_number, ParameterDirection.Input),
new OracleParameter("p_notice_date", OracleDbType.Date, p_notice_date, ParameterDirection.Input),
new OracleParameter("p_notice_type", OracleDbType.Decimal, p_notice_type, ParameterDirection.Input),
new OracleParameter("p_notice_url", OracleDbType.Varchar2, p_notice_url, ParameterDirection.Input),
new OracleParameter("p_notice_trans_url", OracleDbType.Varchar2, p_notice_trans_url, ParameterDirection.Input),
new OracleParameter("p_result", OracleDbType.Decimal, p_result, ParameterDirection.Input),
new OracleParameter("p_accept_date", OracleDbType.Date, p_accept_date, ParameterDirection.Input),
new OracleParameter("p_exp_date", OracleDbType.Date, p_exp_date, ParameterDirection.Input),
new OracleParameter("p_accept_url", OracleDbType.Varchar2, p_accept_url, ParameterDirection.Input),
new OracleParameter("p_reject_reason", OracleDbType.Varchar2, p_reject_reason, ParameterDirection.Input),
new OracleParameter("p_status", OracleDbType.Decimal, p_status, ParameterDirection.Input),
new OracleParameter("p_advise_replies", OracleDbType.Varchar2, p_advise_replies, ParameterDirection.Input),
new OracleParameter("p_billing_id", OracleDbType.Decimal, p_billing_id, ParameterDirection.Input),
new OracleParameter("p_biling_url", OracleDbType.Varchar2, p_billing_url, ParameterDirection.Input),
new OracleParameter("p_replies_deadline", OracleDbType.Date, p_replies_deadline, ParameterDirection.Input),
new OracleParameter("p_created_by", OracleDbType.Varchar2, p_created_by, ParameterDirection.Input),
new OracleParameter("p_note", OracleDbType.Varchar2, p_note, ParameterDirection.Input),
paramReturn);
return(Convert.ToDecimal(paramReturn.Value.ToString()));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
}
public decimal Timesheet_Approve(decimal p_id, int p_status, string p_reject_reason, string p_notes, string p_modify_by, DateTime p_modify_date)
{
try
{
var paramReturn = new OracleParameter("p_return", OracleDbType.Int32, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_timesheet.proc_timesheet_approve",
new OracleParameter("p_id", OracleDbType.Decimal, p_id, ParameterDirection.Input),
//new OracleParameter("p_hours_adjust", OracleDbType.Decimal, p_hours_adjust, ParameterDirection.Input),
new OracleParameter("p_status", OracleDbType.Int16, p_status, ParameterDirection.Input),
new OracleParameter("p_reject_reason", OracleDbType.Varchar2, p_reject_reason, ParameterDirection.Input),
new OracleParameter("p_notes", OracleDbType.Varchar2, p_notes, 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);
return(Convert.ToDecimal(paramReturn.Value.ToString()));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public decimal App_Notice_Review_Accept(string p_case_code, decimal p_notice_type, decimal p_status,
string p_note, string p_modify_by, string p_language_code)
{
try
{
var paramReturn = new OracleParameter("p_return", OracleDbType.Int32, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_app_notice_info.proc_review_accept",
new OracleParameter("p_case_code", OracleDbType.Varchar2, p_case_code, ParameterDirection.Input),
new OracleParameter("p_notice_type", OracleDbType.Decimal, p_notice_type, ParameterDirection.Input),
new OracleParameter("p_status", OracleDbType.Decimal, p_status, ParameterDirection.Input),
new OracleParameter("p_note", OracleDbType.Varchar2, p_note, ParameterDirection.Input),
new OracleParameter("p_modify_by", OracleDbType.Varchar2, p_modify_by, ParameterDirection.Input),
new OracleParameter("p_language_code", OracleDbType.Varchar2, p_language_code, ParameterDirection.Input),
paramReturn);
return(Convert.ToDecimal(paramReturn.Value.ToString()));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public decimal Sys_Pages_Insert(Sys_Pages_Info pInfo)
{
try
{
var paramReturn = new OracleParameter("P_RETURN", OracleDbType.Int32, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_sys_pages.PROC_INSERT",
new OracleParameter("p_code", OracleDbType.Varchar2, pInfo.Code, ParameterDirection.Input),
new OracleParameter("P_HEADER", OracleDbType.Varchar2, pInfo.Header, ParameterDirection.Input),
new OracleParameter("P_HEADER_EN", OracleDbType.Varchar2, pInfo.Header_En, ParameterDirection.Input),
new OracleParameter("P_IMAGEHEADER", OracleDbType.Varchar2, pInfo.Imageheader, ParameterDirection.Input),
new OracleParameter("P_CONTENT", OracleDbType.Clob, pInfo.Content, ParameterDirection.Input),
new OracleParameter("P_CONTENT_EN", OracleDbType.Clob, pInfo.Content_En, ParameterDirection.Input),
new OracleParameter("P_STATUS", OracleDbType.Decimal, pInfo.Status, ParameterDirection.Input),
new OracleParameter("P_CREATED_BY", OracleDbType.Varchar2, pInfo.Created_By, ParameterDirection.Input),
paramReturn);
return(Convert.ToDecimal(paramReturn.Value.ToString()));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public decimal Update(UTienInfo pInfo)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_app_don_uu_tien.proc_app_don_uu_tien_update",
new OracleParameter("p_id", OracleDbType.Decimal, pInfo.Id, ParameterDirection.Input),
new OracleParameter("p_case_code", OracleDbType.Decimal, pInfo.Case_Code, ParameterDirection.Input),
new OracleParameter("p_ut_sodon", OracleDbType.Varchar2, pInfo.UT_SoDon, ParameterDirection.Input),
new OracleParameter("p_ut_ngaynopdon", OracleDbType.Date, pInfo.UT_NgayNopDon, ParameterDirection.Input),
new OracleParameter("p_ut_quocgia", OracleDbType.Decimal, pInfo.UT_QuocGia, ParameterDirection.Input),
new OracleParameter("p_ut_type", OracleDbType.Varchar2, pInfo.UT_Type, ParameterDirection.Input),
new OracleParameter("p_ut_thoathuankhac", OracleDbType.Varchar2, pInfo.UT_ThoaThuanKhac, ParameterDirection.Input),
paramReturn);
var result = Convert.ToDecimal(paramReturn.Value.ToString());
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
public decimal WikiCatalogue_Insert(string P_NAME, string P_NAME_ENG, Decimal P_CATA_LEVEL,
string P_CREATED_BY, DateTime P_CREATED_DATE, Decimal P_PARENT_ID)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "PKG_WIKI_CATALOUGE.PROC_WIKI_CATALOGUES_INSERT",
new OracleParameter("P_NAME", OracleDbType.Varchar2, P_NAME, ParameterDirection.Input),
new OracleParameter("P_NAME_ENG", OracleDbType.Varchar2, P_NAME_ENG, ParameterDirection.Input),
new OracleParameter("P_CATA_LEVEL", OracleDbType.Varchar2, P_CATA_LEVEL, ParameterDirection.Input),
new OracleParameter("P_CREATED_BY", OracleDbType.Varchar2, P_CREATED_BY, ParameterDirection.Input),
new OracleParameter("P_CREATED_DATE", OracleDbType.Date, P_CREATED_DATE, ParameterDirection.Input),
new OracleParameter("P_PARENT_ID", OracleDbType.Decimal, P_PARENT_ID, ParameterDirection.Input),
paramReturn);
return(Convert.ToDecimal(paramReturn.Value.ToString()));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public decimal App_Class_Insert(string P_CODE, string P_NAME_VI, string P_NAME_EN, string P_NAME_CN,
string P_CREATED_BY, DateTime P_CREATED_DATE)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "PKG_APP_CLASS.PROC_CLASS_ADD",
new OracleParameter("P_CODE", OracleDbType.Varchar2, P_CODE, ParameterDirection.Input),
new OracleParameter("P_NAME_VI", OracleDbType.Varchar2, P_NAME_VI, ParameterDirection.Input),
new OracleParameter("P_NAME_EN", OracleDbType.Varchar2, P_NAME_EN, ParameterDirection.Input),
new OracleParameter("P_NAME_CN", OracleDbType.Varchar2, P_NAME_CN, ParameterDirection.Input),
new OracleParameter("P_CREATED_BY", OracleDbType.Varchar2, P_CREATED_BY, ParameterDirection.Input),
new OracleParameter("P_CREATED_DATE", OracleDbType.Date, P_CREATED_DATE, ParameterDirection.Input),
paramReturn);
return(Convert.ToDecimal(paramReturn.Value.ToString()));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public decimal SEARCH_QUESTION_INSERT(SearchObject_Question_Info p_question_info)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "PKG_SEARCH_OBJECTS.PROC_SEARCH_QUESTION_INSERT",
new OracleParameter("P_SEARCH_ID", OracleDbType.Decimal, p_question_info.SEARCH_ID, ParameterDirection.Input),
new OracleParameter("P_SUBJECT", OracleDbType.Varchar2, p_question_info.SUBJECT, ParameterDirection.Input),
new OracleParameter("P_CONTENT", OracleDbType.Varchar2, p_question_info.CONTENT, ParameterDirection.Input),
new OracleParameter("P_RESULT", OracleDbType.Clob, p_question_info.RESULT, ParameterDirection.Input),
new OracleParameter("P_FILE_URL", OracleDbType.Varchar2, p_question_info.FILE_URL, ParameterDirection.Input),
new OracleParameter("P_FILE_URL02", OracleDbType.Varchar2, p_question_info.FILE_URL02, ParameterDirection.Input),
paramReturn);
return(Convert.ToDecimal(paramReturn.Value.ToString()));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public decimal Sys_Search_Fee_Insert(Sys_Search_Fix_Info p_obj)
{
try
{
var paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_sys_search_fix.Proc_Sys_Search_Fee_Insert",
new OracleParameter("p_country_id", OracleDbType.Decimal, p_obj.Country_Id, ParameterDirection.Input),
new OracleParameter("p_search_object", OracleDbType.Decimal, p_obj.Search_Object, ParameterDirection.Input),
new OracleParameter("p_search_type", OracleDbType.Decimal, p_obj.Search_Type, ParameterDirection.Input),
new OracleParameter("p_amount", OracleDbType.Decimal, p_obj.Amount, ParameterDirection.Input),
new OracleParameter("p_amount_usd", OracleDbType.Decimal, p_obj.Amount_usd, ParameterDirection.Input),
new OracleParameter("p_created_by", OracleDbType.Varchar2, p_obj.Created_By, ParameterDirection.Input),
paramReturn
);
var result = Convert.ToDecimal(paramReturn.Value.ToString());
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public decimal Docking_Insert_Transaction(string p_app_case_code, decimal p_docking_type, string p_document_name, string p_document_name_type, string p_document_name_other,
decimal p_document_type, decimal p_status,
DateTime p_deadline, decimal p_isshowcustomer, DateTime p_in_out_date, string p_created_by, DateTime p_created_date, string p_language_code,
string p_url, string p_notes, decimal p_place_submit, string p_filename)
{
try
{
var paramReturn = new OracleParameter("p_return", OracleDbType.Int32, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "Pkg_Docking.Proc_Docking_Insert_tran",
new OracleParameter("p_app_case_code", OracleDbType.Varchar2, p_app_case_code, ParameterDirection.Input),
new OracleParameter("p_docking_type", OracleDbType.Decimal, p_docking_type, ParameterDirection.Input),
new OracleParameter("p_document_name", OracleDbType.Varchar2, p_document_name, ParameterDirection.Input),
new OracleParameter("p_document_name_type", OracleDbType.Varchar2, p_document_name_type == null ? "" : p_document_name_type, ParameterDirection.Input),
new OracleParameter("p_document_name_other", OracleDbType.Varchar2, p_document_name_other == null ? "" : p_document_name_other, ParameterDirection.Input),
new OracleParameter("p_document_type", OracleDbType.Decimal, p_document_type, ParameterDirection.Input),
new OracleParameter("p_status", OracleDbType.Decimal, p_status, ParameterDirection.Input),
new OracleParameter("p_deadline", OracleDbType.Date, p_deadline, ParameterDirection.Input),
new OracleParameter("p_isshowcustomer", OracleDbType.Decimal, p_isshowcustomer, ParameterDirection.Input),
new OracleParameter("p_in_out_date", OracleDbType.Date, p_in_out_date, ParameterDirection.Input),
new OracleParameter("p_created_by", OracleDbType.Varchar2, p_created_by, ParameterDirection.Input),
new OracleParameter("p_created_date", OracleDbType.Date, p_created_date, ParameterDirection.Input),
new OracleParameter("p_place_submit", OracleDbType.Decimal, p_place_submit, ParameterDirection.Input),
new OracleParameter("p_url", OracleDbType.Varchar2, p_url, ParameterDirection.Input),
new OracleParameter("p_filename", OracleDbType.Varchar2, p_filename, ParameterDirection.Input),
new OracleParameter("p_notes", OracleDbType.Varchar2, p_notes, ParameterDirection.Input),
new OracleParameter("p_language_code", OracleDbType.Varchar2, p_language_code, ParameterDirection.Input),
paramReturn);
return(Convert.ToDecimal(paramReturn.Value.ToString()));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public int UpDate(App_Detail_F04_Info pInfo)
{
try
{
var paramReturn = new OracleParameter("p_return", OracleDbType.Int32, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_app_detail_F04.proc_app_detail_F04_update",
new OracleParameter("p_id", OracleDbType.Decimal, pInfo.Id, ParameterDirection.Input),
new OracleParameter("p_app_header_id", OracleDbType.Decimal, pInfo.App_Header_Id, ParameterDirection.Input),
new OracleParameter("p_appno", OracleDbType.Varchar2, pInfo.Appno, ParameterDirection.Input),
new OracleParameter("p_case_code", OracleDbType.Varchar2, pInfo.Case_Code, ParameterDirection.Input),
new OracleParameter("p_language_code", OracleDbType.Varchar2, pInfo.Language_Code, ParameterDirection.Input),
new OracleParameter("p_applicant_type", OracleDbType.Decimal, pInfo.Applicant_Type, ParameterDirection.Input),
new OracleParameter("p_business_line", OracleDbType.Varchar2, pInfo.Business_Line, ParameterDirection.Input),
new OracleParameter("p_description", OracleDbType.Varchar2, pInfo.Description, ParameterDirection.Input),
new OracleParameter("p_codelogo", OracleDbType.Varchar2, pInfo.Codelogo, ParameterDirection.Input),
new OracleParameter("p_loainhanhieu", OracleDbType.Varchar2, pInfo.Loainhanhieu, ParameterDirection.Input),
new OracleParameter("p_sodon_ut", OracleDbType.Varchar2, pInfo.Sodon_ut, ParameterDirection.Input),
new OracleParameter("p_ngaynopdon_ut", OracleDbType.Date, pInfo.Ngaynopdon_ut, ParameterDirection.Input),
new OracleParameter("p_nuocnopdon_ut", OracleDbType.Decimal, pInfo.Nuocnopdon_ut, ParameterDirection.Input),
new OracleParameter("p_color", OracleDbType.Varchar2, pInfo.Color, ParameterDirection.Input),
new OracleParameter("p_translation_of_word", OracleDbType.Varchar2, pInfo.Translation_Of_Word, ParameterDirection.Input),
new OracleParameter("p_logourl", OracleDbType.Varchar2, pInfo.Logourl, ParameterDirection.Input),
new OracleParameter("p_classno", OracleDbType.Varchar2, pInfo.ClassNo, ParameterDirection.Input),
new OracleParameter("p_duadate", OracleDbType.Date, pInfo.Duadate, ParameterDirection.Input),
new OracleParameter("p_used_special", OracleDbType.Decimal, pInfo.Used_Special, ParameterDirection.Input),
paramReturn);
var result = Convert.ToInt32(paramReturn.Value.ToString());
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
public int App_Detail_06TMDKQT_Update(App_Detail_TM06DKQT_Info pInfo)
{
try
{
var paramReturn = new OracleParameter("P_RETURN", OracleDbType.Int32, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "PKG_APP_DETAIL_TM06DKQT.PROC_TM06DKQT_UPDATE",
new OracleParameter("P_ID", OracleDbType.Decimal, pInfo.Id, ParameterDirection.Input),
new OracleParameter("P_APPCODE", OracleDbType.Varchar2, pInfo.Appcode, ParameterDirection.Input),
new OracleParameter("P_APP_HEADER_ID", OracleDbType.Decimal, pInfo.APP_HEADER_ID, ParameterDirection.Input),
new OracleParameter("P_LANGUAGE", OracleDbType.Varchar2, pInfo.LANGUAGE_CODE, ParameterDirection.Input),
new OracleParameter("P_APPNO", OracleDbType.Varchar2, pInfo.APPNO, ParameterDirection.Input),
new OracleParameter("P_THANHVIEN_ND_TC", OracleDbType.Varchar2, pInfo.THANHVIEN_ND_TC, ParameterDirection.Input),
new OracleParameter("P_LOGOURL", OracleDbType.Varchar2, pInfo.LOGOURL, ParameterDirection.Input),
new OracleParameter("P_DON_GIAY_DKNHCS", OracleDbType.Varchar2, pInfo.DON_GIAY_DKNHCS, ParameterDirection.Input),
new OracleParameter("P_REF_APPNO", OracleDbType.Varchar2, pInfo.REF_APPNO, ParameterDirection.Input),
new OracleParameter("P_COUNTRY_ID01", OracleDbType.Varchar2, pInfo.COUNTRY_ID01, ParameterDirection.Input),
new OracleParameter("P_COUNTRY_ID02", OracleDbType.Varchar2, pInfo.COUNTRY_ID02, ParameterDirection.Input),
new OracleParameter("P_COUNTRY_ID03", OracleDbType.Varchar2, pInfo.COUNTRY_ID03, ParameterDirection.Input),
new OracleParameter("P_COUNTRY_ID04", OracleDbType.Varchar2, pInfo.COUNTRY_ID04, ParameterDirection.Input),
new OracleParameter("P_COUNTRY_ID05", OracleDbType.Varchar2, pInfo.COUNTRY_ID05, ParameterDirection.Input),
new OracleParameter("P_COUNTRY_ID06", OracleDbType.Varchar2, pInfo.COUNTRY_ID06, ParameterDirection.Input),
new OracleParameter("P_COUNTRY_ID07", OracleDbType.Varchar2, pInfo.COUNTRY_ID07, ParameterDirection.Input),
new OracleParameter("P_COUNTRY_ID08", OracleDbType.Varchar2, pInfo.COUNTRY_ID08, ParameterDirection.Input),
new OracleParameter("P_LEPHI", OracleDbType.Decimal, pInfo.LEPHI, ParameterDirection.Input),
new OracleParameter("P_PAGE_REMAIN", OracleDbType.Decimal, pInfo.PAGE_REMAIN, ParameterDirection.Input),
new OracleParameter("P_NGAYNOPDON", OracleDbType.Date, pInfo.NGAYNOPDON, ParameterDirection.Input),
paramReturn);
var result = Convert.ToInt32(paramReturn.Value.ToString());
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
public decimal Update(AuthorsInfo pInfo)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_authors.proc_authors_update",
new OracleParameter("p_author_id", OracleDbType.Decimal, pInfo.Author_Id, ParameterDirection.Input),
new OracleParameter("p_case_code", OracleDbType.Decimal, pInfo.Case_Code, ParameterDirection.Input),
new OracleParameter("p_author_name", OracleDbType.Varchar2, pInfo.Author_Name, ParameterDirection.Input),
new OracleParameter("p_author_address", OracleDbType.Varchar2, pInfo.Author_Address, ParameterDirection.Input),
new OracleParameter("p_author_phone", OracleDbType.Varchar2, pInfo.Author_Phone, ParameterDirection.Input),
new OracleParameter("p_author_fax", OracleDbType.Varchar2, pInfo.Author_Fax, ParameterDirection.Input),
new OracleParameter("p_author_email", OracleDbType.Varchar2, pInfo.Author_Email, ParameterDirection.Input),
new OracleParameter("p_author_country", OracleDbType.Decimal, pInfo.Author_Country, ParameterDirection.Input),
paramReturn);
var result = Convert.ToDecimal(paramReturn.Value.ToString());
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
public decimal SEARCH_HEADER_UPDATE(SearchObject_Header_Info p_SearchObject_Header_Info)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "PKG_SEARCH_OBJECTS.PROC_SEARCH_HEADER_UPDATE",
new OracleParameter("P_SEARCH_ID", OracleDbType.Decimal, p_SearchObject_Header_Info.SEARCH_ID, ParameterDirection.Input),
new OracleParameter("P_CASE_CODE", OracleDbType.Varchar2, p_SearchObject_Header_Info.CASE_CODE, ParameterDirection.Input),
new OracleParameter("P_CLIENT_REFERENCE", OracleDbType.Varchar2, p_SearchObject_Header_Info.CLIENT_REFERENCE, ParameterDirection.Input),
new OracleParameter("P_CASE_NAME", OracleDbType.Varchar2, p_SearchObject_Header_Info.CASE_NAME, ParameterDirection.Input),
new OracleParameter("P_REQUEST_DATE", OracleDbType.Date, p_SearchObject_Header_Info.REQUEST_DATE, ParameterDirection.Input),
new OracleParameter("P_RESPONSE_DATE", OracleDbType.Date, p_SearchObject_Header_Info.RESPONSE_DATE, ParameterDirection.Input),
new OracleParameter("P_STATUS", OracleDbType.Decimal, p_SearchObject_Header_Info.STATUS, ParameterDirection.Input),
new OracleParameter("P_LAWER_ID", OracleDbType.Decimal, p_SearchObject_Header_Info.LAWER_ID, ParameterDirection.Input),
new OracleParameter("P_MODIFIED_BY", OracleDbType.Varchar2, p_SearchObject_Header_Info.MODIFIED_BY, ParameterDirection.Input),
new OracleParameter("P_MODIFIED_DATE", OracleDbType.Date, p_SearchObject_Header_Info.MODIFIED_DATE, ParameterDirection.Input),
new OracleParameter("P_NOTES", OracleDbType.Varchar2, p_SearchObject_Header_Info.NOTE, ParameterDirection.Input),
new OracleParameter("P_OBJECT_SEARCH", OracleDbType.Decimal, p_SearchObject_Header_Info.Object_Search, ParameterDirection.Input),
new OracleParameter("P_URL_FILE", OracleDbType.Varchar2, p_SearchObject_Header_Info.Url_File, ParameterDirection.Input),
//HungTD thêm up ảnh
new OracleParameter("P_LOGOURL", OracleDbType.Varchar2, p_SearchObject_Header_Info.Logourl, ParameterDirection.Input),
new OracleParameter("P_LOGOCHU", OracleDbType.Decimal, p_SearchObject_Header_Info.Logochu, ParameterDirection.Input),
new OracleParameter("P_LOGO_FONT_SIZE", OracleDbType.Decimal, p_SearchObject_Header_Info.LOGO_FONT_SIZE, ParameterDirection.Input),
new OracleParameter("P_FONTTYPE", OracleDbType.Varchar2, p_SearchObject_Header_Info.FONTTYPE, ParameterDirection.Input),
new OracleParameter("P_NAME", OracleDbType.Varchar2, p_SearchObject_Header_Info.Name, ParameterDirection.Input),
paramReturn);
return(Convert.ToDecimal(paramReturn.Value.ToString()));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public int ExecuteNonQuery(string cmdText, Dictionary <string, object> commandParameters)
{
OracleParameter[] sqlParams = Dp2Op(commandParameters);
return(OracleHelper.ExecuteNonQuery(connectionString, CommandType.Text, cmdText, sqlParams));
}