public int App_Detail_04NH_Update(AppDetail04NHInfo pInfo)
{
try
{
AppDetail04NH_DA objData = new AppDetail04NH_DA();
return(objData.App_Detail_04NH_Update(pInfo));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
public ActionResult TM04NHGetInfo(decimal pAppHeaderId, string p_idchudon, string p_iddaidienchudon, string p_idappclass)
{
try
{
var objBL = new AppDetail04NHBL();
string language = AppsCommon.GetCurrentLang();
var ds04NH = objBL.AppTM04NHGetByID(pAppHeaderId, language, 7);// tạm thời truyền vào trạng thái = 7
var _AppDetail04NHInfo = new AppDetail04NHInfo();
if (ds04NH != null && ds04NH.Tables.Count == 5)
{
_AppDetail04NHInfo = CBO <AppDetail04NHInfo> .FillObjectFromDataTable(ds04NH.Tables[0]);
ViewBag.lstClassDetailInfo = CBO <AppClassDetailInfo> .FillCollectionFromDataTable(ds04NH.Tables[3]);
}
ViewBag.objAppHeaderInfo = _AppDetail04NHInfo;
string _viewChuDon = "";
string _viewDaiDienChuDon = "";
string _viewAppClass = "";
_viewChuDon = RenderPartialToString("~/Areas/TradeMark/Views/Shared/_PartialThongTinChuDon.cshtml", p_idchudon);
_viewDaiDienChuDon = RenderPartialToString("~/Areas/TradeMark/Views/Shared/_PartialThongTinDaiDienChuDon.cshtml", p_iddaidienchudon);
_viewAppClass = RenderPartialToString("~/Areas/TradeMark/Views/Shared/_PartialTMAddAppClass.cshtml", null);
return(Json(new
{
success = 0,
NgayNopDon = _AppDetail04NHInfo.Ngaynopdon_Ut.ToDateStringN0(),
LogoURL = _AppDetail04NHInfo.Logourl,
ViewChuDon = _viewChuDon,
ViewDaiDienChuDon = _viewDaiDienChuDon,
ViewAppClass = _viewAppClass
}));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(Json(new { success = -1 }));
}
}
public int App_Detail_04NH_Update(AppDetail04NHInfo pInfo)
{
try
{
// Logger.LogInfo("pInfo:" + pInfo.Id.ToString() + " pInfo.App_Header_Id:" + pInfo.App_Header_Id + " Appcode:" + pInfo.Appcode +
// "Language_Code:" + pInfo.Language_Code + " Dactichhanghoa:" + pInfo.Dactichhanghoa.ToString() + " pInfo.Used_Special:" + pInfo.Used_Special +
// " pInfo.Duadate:" + pInfo.Duadate.ToString("dd/MM/yyyy") + " pInfo.Ngaynopdon_Ut:" + pInfo.Ngaynopdon_Ut.ToString("dd/MM/yyyy") +
// " pInfo.Ngaynopdon_Ut2:" + pInfo.Ngaynopdon_Ut2.ToString("dd/MM/yyyy"));
// Logger.LogInfo("1pInfo Logourl:" + pInfo.Logourl.ToString() + " pInfo.Dactichhanghoa:" + pInfo.Dactichhanghoa + " Color:" + pInfo.Color +
//" Description:" + pInfo.Description + " Huongquyenuutien:" + pInfo.Huongquyenuutien.ToString() + " pInfo.Sodon_Ut:" + pInfo.Sodon_Ut +
//" pInfo.Nguongocdialy:" + pInfo.Nguongocdialy + " pInfo.Chatluong:" + pInfo.Chatluong + " pInfo.Dactinhkhac:" + pInfo.Dactinhkhac);
// Logger.LogInfo("2pInfo pInfo.LoaiNhanHieu:" + pInfo.LoaiNhanHieu.ToString() + " pInfo.CodeLogo:" + pInfo.CodeLogo + " Sodon_Ut2:" + pInfo.Sodon_Ut2 +
//" Ngaynopdon_Ut2:" + pInfo.Ngaynopdon_Ut2.ToString("dd/MM/yyyy") + " Nuocnopdon_Ut2:" + pInfo.Nuocnopdon_Ut2.ToString() + " pInfo.Huongquyenuutien2:" + pInfo.Huongquyenuutien2 +
//" pInfo.ThoaThuanKhac:" + pInfo.ThoaThuanKhac + " pInfo.Chatluong:" + pInfo.Chatluong + " pInfo.Dactinhkhac:" + pInfo.Dactinhkhac);
var paramReturn = new OracleParameter("P_RETURN", OracleDbType.Int32, ParameterDirection.Output);
paramReturn.Size = 10;
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "PKG_APP_DETAIL_04NH.PROC_APP_DETAIL_04NH_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_appcode", OracleDbType.Varchar2, pInfo.Appcode, ParameterDirection.Input),
new OracleParameter("p_language_code", OracleDbType.Varchar2, pInfo.Language_Code, ParameterDirection.Input),
new OracleParameter("p_appno", OracleDbType.Varchar2, pInfo.Appno, ParameterDirection.Input),
new OracleParameter("p_duadate", OracleDbType.Date, pInfo.Duadate, ParameterDirection.Input),
new OracleParameter("p_logourl", OracleDbType.Varchar2, pInfo.Logourl, ParameterDirection.Input),
new OracleParameter("p_dactichhanghoa", OracleDbType.Int32, pInfo.Dactichhanghoa, ParameterDirection.Input),
new OracleParameter("p_color", OracleDbType.Varchar2, pInfo.Color, ParameterDirection.Input),
new OracleParameter("p_description", OracleDbType.Varchar2, pInfo.Description, ParameterDirection.Input),
new OracleParameter("p_huongquyenuutien", OracleDbType.Varchar2, pInfo.Huongquyenuutien, 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.Varchar2, pInfo.Nuocnopdon_Ut, ParameterDirection.Input),
new OracleParameter("p_nguongocdialy", OracleDbType.Varchar2, pInfo.Nguongocdialy, ParameterDirection.Input),
new OracleParameter("p_chatluong", OracleDbType.Varchar2, pInfo.Chatluong, ParameterDirection.Input),
new OracleParameter("p_dactinhkhac", OracleDbType.Varchar2, pInfo.Dactinhkhac, ParameterDirection.Input),
new OracleParameter("p_cdk_name_1", OracleDbType.Varchar2, pInfo.Cdk_Name_1, ParameterDirection.Input),
new OracleParameter("p_cdk_address_1", OracleDbType.Varchar2, pInfo.Cdk_Address_1, ParameterDirection.Input),
new OracleParameter("p_cdk_phone_1", OracleDbType.Varchar2, pInfo.Cdk_Phone_1, ParameterDirection.Input),
new OracleParameter("p_cdk_fax_1", OracleDbType.Varchar2, pInfo.Cdk_Fax_1, ParameterDirection.Input),
new OracleParameter("p_cdk_email_1", OracleDbType.Varchar2, pInfo.Cdk_Email_1, ParameterDirection.Input),
new OracleParameter("p_cdk_name_2", OracleDbType.Varchar2, pInfo.Cdk_Name_2, ParameterDirection.Input),
new OracleParameter("p_cdk_address_2", OracleDbType.Varchar2, pInfo.Cdk_Address_2, ParameterDirection.Input),
new OracleParameter("p_cdk_phone_2", OracleDbType.Varchar2, pInfo.Cdk_Phone_2, ParameterDirection.Input),
new OracleParameter("p_cdk_fax_2", OracleDbType.Varchar2, pInfo.Cdk_Fax_2, ParameterDirection.Input),
new OracleParameter("p_cdk_email_2", OracleDbType.Varchar2, pInfo.Cdk_Email_2, ParameterDirection.Input),
new OracleParameter("p_cdk_name_3", OracleDbType.Varchar2, pInfo.Cdk_Name_3, ParameterDirection.Input),
new OracleParameter("p_cdk_address_3", OracleDbType.Varchar2, pInfo.Cdk_Address_3, ParameterDirection.Input),
new OracleParameter("p_cdk_phone_3", OracleDbType.Varchar2, pInfo.Cdk_Phone_3, ParameterDirection.Input),
new OracleParameter("p_cdk_fax_3", OracleDbType.Varchar2, pInfo.Cdk_Fax_3, ParameterDirection.Input),
new OracleParameter("p_cdk_email_3", OracleDbType.Varchar2, pInfo.Cdk_Email_3, ParameterDirection.Input),
new OracleParameter("p_cdk_name_4", OracleDbType.Varchar2, pInfo.Cdk_Name_4, ParameterDirection.Input),
new OracleParameter("p_cdk_address_4", OracleDbType.Varchar2, pInfo.Cdk_Address_4, ParameterDirection.Input),
new OracleParameter("p_cdk_phone_4", OracleDbType.Varchar2, pInfo.Cdk_Phone_4, ParameterDirection.Input),
new OracleParameter("p_cdk_fax_4", OracleDbType.Varchar2, pInfo.Cdk_Fax_4, ParameterDirection.Input),
new OracleParameter("p_cdk_email_4", OracleDbType.Varchar2, pInfo.Cdk_Email_4, ParameterDirection.Input),
new OracleParameter("p_used_special", OracleDbType.Decimal, pInfo.Used_Special, ParameterDirection.Input),
new OracleParameter("P_LOAINHANHIEU", OracleDbType.Varchar2, pInfo.LoaiNhanHieu, ParameterDirection.Input),
new OracleParameter("P_CODELOGO", OracleDbType.Varchar2, pInfo.CodeLogo, ParameterDirection.Input),
new OracleParameter("P_SODON_UT2", OracleDbType.Varchar2, pInfo.Sodon_Ut2, ParameterDirection.Input),
new OracleParameter("P_NGAYNOPDON_UT2", OracleDbType.Date, pInfo.Ngaynopdon_Ut2, ParameterDirection.Input),
new OracleParameter("P_NUOCNOPDON_UT2", OracleDbType.Varchar2, pInfo.Nuocnopdon_Ut2, ParameterDirection.Input),
new OracleParameter("P_HUONGQUYENUUTIEN2", OracleDbType.Varchar2, pInfo.Huongquyenuutien2, ParameterDirection.Input),
new OracleParameter("P_YCCAPPHO1", OracleDbType.Varchar2, pInfo.YCCapPho1, ParameterDirection.Input),
new OracleParameter("P_YCCAPPHO2", OracleDbType.Varchar2, pInfo.YCCapPho2, ParameterDirection.Input),
new OracleParameter("P_YCCAPPHO3", OracleDbType.Varchar2, pInfo.YCCapPho3, ParameterDirection.Input),
new OracleParameter("P_YCCAPPHO4", OracleDbType.Varchar2, pInfo.YCCapPho4, ParameterDirection.Input),
new OracleParameter("P_THOATHUANKHAC", OracleDbType.Varchar2, pInfo.ThoaThuanKhac, ParameterDirection.Input),
new OracleParameter("P_LOGOCHU", OracleDbType.Int32, pInfo.Logochu, ParameterDirection.Input),
new OracleParameter("P_LOGO_FONT_SIZE", OracleDbType.Int32, pInfo.LOGO_FONT_SIZE, ParameterDirection.Input),
new OracleParameter("P_FONTTYPE", OracleDbType.Varchar2, pInfo.FONTTYPE, ParameterDirection.Input),
paramReturn);
var result = Convert.ToInt32(paramReturn.Value.ToString());
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
