public decimal Insert(App_Detail_F04_Info pInfo)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_app_detail_F04.Proc_App_Detail_F04_Insert",
new OracleParameter("p_app_header_id", OracleDbType.Decimal, pInfo.App_Header_Id, ParameterDirection.Input),
new OracleParameter("p_appcode", OracleDbType.Varchar2, pInfo.Appcode, 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.ToDecimal(paramReturn.Value.ToString());
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
public App_Detail_F04_Info GetByID(decimal p_app_header_id, string p_language_code,
ref ApplicationHeaderInfo applicationHeaderInfo,
ref List <AppDocumentInfo> appDocumentInfos,
ref List <AppDocumentOthersInfo> _LstDocumentOthersInfo,
ref List <UTienInfo> pUTienInfo, ref List <AppClassDetailInfo> pAppClassInfo)
{
try
{
var objData = new App_Detail_F04_DA();
DataSet dataSet = objData.GetByID(p_app_header_id, p_language_code);
App_Detail_F04_Info app_Detail_F04 = CBO <App_Detail_F04_Info> .FillObjectFromDataTable(dataSet.Tables[0]);
if (dataSet != null && dataSet.Tables.Count == 6)
{
applicationHeaderInfo = CBO <ApplicationHeaderInfo> .FillObjectFromDataTable(dataSet.Tables[1]);
appDocumentInfos = CBO <AppDocumentInfo> .FillCollectionFromDataTable(dataSet.Tables[2]);
_LstDocumentOthersInfo = CBO <AppDocumentOthersInfo> .FillCollectionFromDataTable(dataSet.Tables[3]);
pUTienInfo = CBO <UTienInfo> .FillCollectionFromDataTable(dataSet.Tables[4]);
pAppClassInfo = CBO <AppClassDetailInfo> .FillCollectionFromDataTable(dataSet.Tables[5]);
}
return(app_Detail_F04);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new App_Detail_F04_Info());
}
}
public int Update(App_Detail_F04_Info pInfo)
{
try
{
App_Detail_F04_DA objData = new App_Detail_F04_DA();
return(objData.UpDate(pInfo));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
public decimal Insert(App_Detail_F04_Info pInfo)
{
try
{
App_Detail_F04_DA objData = new App_Detail_F04_DA();
return(objData.Insert(pInfo));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
