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