public ActionResult TM06NHGetInfo(string pAppHeaderId, string p_idchudon,
string p_iddaidienchudon, string p_idappclass)
{
try
{
var objBL = new C07_BL();
string language = AppsCommon.GetCurrentLang();
List <AppClassDetailInfo> _listClass = new List <AppClassDetailInfo>();
App_Detail_TM06DKQT_Info _TM06Info = objBL.AppTM06DKQTGetByID(pAppHeaderId, language, 0, ref _listClass);// tạm thời truyền vào trạng thái = 0 và k wherre trong db
ViewBag.lstClassDetailInfo = _listClass;
ViewBag.objAppHeaderInfo = _TM06Info;
string _viewChuDon = "";
string _viewDaiDienChuDon = "";
string _viewAppClass = "";
//ViewBag.Isdisable = 1;
_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 = _TM06Info.NGAYNOPDON.ToDateStringN0(),
LogoURL = _TM06Info.LOGOURL,
ViewChuDon = _viewChuDon,
ViewDaiDienChuDon = _viewDaiDienChuDon,
ViewAppClass = _viewAppClass
}));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(Json(new { success = -1 }));
}
}
public int App_Detail_06TMDKQT_Insert(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_INSERT",
new OracleParameter("P_APPCODE", OracleDbType.Varchar2, pInfo.Appcode, ParameterDirection.Input),
new OracleParameter("P_APP_HEADER_ID", OracleDbType.Varchar2, 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 App_Detail_TM06DKQT_Info AppTM06DKQTGetByID(string pAppHeaderID,
string pLanguage, int pStatus, ref List <AppClassDetailInfo> pListAppClass)
{
List <AppClassDetailInfo> _listAppClass = new List <AppClassDetailInfo>();
App_Detail_TM06DKQT_Info _Tm06DKQT = new App_Detail_TM06DKQT_Info();
DataSet _DS = new DataSet();
try
{
var objData = new C07_DA();
_DS = objData.AppTM06DKQTGetByID(pAppHeaderID, pLanguage, pStatus);
if (_DS != null && _DS.Tables.Count == 3)
{
_Tm06DKQT = CBO <App_Detail_TM06DKQT_Info> .FillObjectFromDataSet(_DS);
_listAppClass = CBO <AppClassDetailInfo> .FillCollectionFromDataTable(_DS.Tables[2]);
}
}
catch (Exception ex)
{
Logger.LogException(ex);
return(_Tm06DKQT);
}
pListAppClass = _listAppClass;
return(_Tm06DKQT);
}
public int App_Detail_06TMDKQT_Update(App_Detail_TM06DKQT_Info pInfo)
{
try
{
App_Detail_TM06DKQT_DA _Da = new App_Detail_TM06DKQT_DA();
return(_Da.App_Detail_06TMDKQT_Update(pInfo));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
public ActionResult GetFee(App_Detail_TM06DKQT_Info pDetail)
{
try
{
List <AppFeeFixInfo> _lstFeeFix = Call_Fee.CallFee_C06(pDetail);
ViewBag.LstFeeFix = _lstFeeFix;
}
catch (Exception ex)
{
Logger.LogException(ex);
}
var PartialTableListFees = AppsCommon.RenderRazorViewToString(this.ControllerContext, "~/Areas/Patent/Views/Shared/_PartialTableListFees.cshtml");
var json = Json(new { success = 1, PartialTableListFees });
return(json);
}
public ActionResult DichDonDangKy(ApplicationHeaderInfo pInfo, App_Detail_TM06DKQT_Info pDetail, List <AppDocumentInfo> pAppDocumentInfo,
List <AppDocumentOthersInfo> pAppDocOtherInfo, List <AppClassDetailInfo> pAppClassInfo, List <AppFeeFixInfo> pFeeFixInfo)
{
try
{
Application_Header_BL objBL = new Application_Header_BL();
AppDetail06DKQT_BL objDetailBL = new AppDetail06DKQT_BL();
AppClassDetailBL objClassDetail = new AppClassDetailBL();
AppDocumentBL objDoc = new AppDocumentBL();
AppFeeFixBL objFeeFixBL = new AppFeeFixBL();
if (pInfo == null || pDetail == null)
{
return(Json(new { status = ErrorCode.Error }));
}
string language = "";
if (pInfo.Languague_Code == Language.LangVI)
{
language = Language.LangEN;
}
else
{
language = Language.LangVI;
}
var CreatedBy = SessionData.CurrentUser.Username;
var CreatedDate = SessionData.CurrentUser.CurrentDate;
int pReturn = ErrorCode.Success;
int pAppHeaderID = 0;
decimal pIDHeaderoot = pInfo.Id;
string prefCaseCode = "";
foreach (AppFeeFixInfo item in pFeeFixInfo)
{
if (item.Amount == 0)
{
// fix là 2 củ
item.Amount = 2000000;
}
}
using (var scope = new TransactionScope())
{
//
pInfo.Languague_Code = language;
if (pInfo.Created_By == null || pInfo.Created_By == "0" || pInfo.Created_By == "")
{
pInfo.Created_By = CreatedBy;
}
//kiểm tra có rồi thì update, chưa có thì insert
if (pInfo.Id_Vi > 0)
{
pInfo.Modify_By = CreatedBy;
pInfo.Modify_Date = CreatedDate;
pAppHeaderID = objBL.AppHeaderUpdate(pInfo);
}
else
{
//TRA RA ID CUA BANG KHI INSERT
pInfo.Created_By = CreatedBy;
pInfo.Created_Date = CreatedDate;
pAppHeaderID = objBL.AppHeaderInsert(pInfo, ref prefCaseCode);
}
//Gán lại khi lấy dl
if (pAppHeaderID >= 0)
{
pReturn = objFeeFixBL.AppFeeFixInsertBath(pFeeFixInfo, prefCaseCode);
}
else
{
Transaction.Current.Rollback();
}
if (pReturn >= 0)
{
pDetail.Appcode = pInfo.Appcode;
pDetail.LANGUAGE_CODE = language;
pDetail.APP_HEADER_ID = pAppHeaderID;
if (pDetail.pfileLogo != null)
{
pDetail.LOGOURL = AppLoadHelpers.PushFileToServer(pDetail.pfileLogo, AppUpload.Logo);
}
pReturn = objDetailBL.App_Detail_06TMDKQT_Insert(pDetail);
//Thêm thông tin class
if (pReturn >= 0)
{
pReturn = objClassDetail.AppClassDetailInsertBatch(pAppClassInfo, pAppHeaderID, language);
}
}
//Tai lieu dinh kem
if (pReturn >= 0 && pAppDocumentInfo != null)
{
if (pAppDocumentInfo.Count > 0)
{
pReturn = objDoc.AppDocumentTranslate(language, pIDHeaderoot, pAppHeaderID);
}
}
//tai lieu khac
if (pReturn >= 0 && pAppDocOtherInfo != null)
{
if (pAppDocOtherInfo.Count > 0)
{
var listDocument = new List <AppDocumentOthersInfo>();
int check = 0;
foreach (var info in pAppDocOtherInfo)
{
if (!string.IsNullOrEmpty(info.Documentname))
{
check = 1;
info.App_Header_Id = pInfo.Id;
info.Language_Code = language;
info.IdRef = Convert.ToDecimal(info.keyFileUpload);
listDocument.Add(info);
}
}
if (check == 1)
{
if (pInfo.Id_Vi > 0)
{
pReturn = objDoc.AppDocumentOtherDeletedByApp(pInfo.Id_Vi, language);
}
pReturn = objDoc.AppDocumentOtherInsertBatch(listDocument);
}
}
}
//end
if (pReturn < 0)
{
Transaction.Current.Rollback();
}
else
{
scope.Complete();
}
}
return(Json(new { status = pAppHeaderID }));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(Json(new { status = ErrorCode.Error }));
}
}
public ActionResult Edit_TM06DKQT(ApplicationHeaderInfo pInfo, App_Detail_TM06DKQT_Info pDetail,
List <AppDocumentInfo> pAppDocumentInfo, List <AppDocumentOthersInfo> pAppDocOtherInfo, List <AppClassDetailInfo> pAppClassInfo)
{
try
{
pDetail.Id = pInfo.Id;
pDetail.APP_HEADER_ID = pInfo.Id;
pDetail.LANGUAGE_CODE = pInfo.Languague_Code;
Application_Header_BL objBL = new Application_Header_BL();
AppFeeFixBL objFeeFixBL = new AppFeeFixBL();
AppDetail06DKQT_BL objDetail = new AppDetail06DKQT_BL();
AppDocumentBL objDoc = new AppDocumentBL();
AppClassDetailBL objClassDetail = new AppClassDetailBL();
bool _IsOk = false;
if (pInfo == null || pDetail == null)
{
return(Json(new { status = ErrorCode.Error }));
}
string language = AppsCommon.GetCurrentLang();
var CreatedBy = SessionData.CurrentUser.Username;
var CreatedDate = SessionData.CurrentUser.CurrentDate;
decimal pReturn = ErrorCode.Success;
List <AppFeeFixInfo> pFeeFixInfo = CommonFunction.Call_Fee.CallFee_C06(pDetail);
pDetail.LEPHI = (pFeeFixInfo[0] as AppFeeFixInfo).Amount;
using (var scope = new TransactionScope())
{
//
pInfo.Languague_Code = language;
pInfo.Modify_By = SessionData.CurrentUser.Username;
pInfo.Modify_Date = SessionData.CurrentUser.CurrentDate;
pInfo.Send_Date = DateTime.Now;
pInfo.DDSHCN = "";
pInfo.MADDSHCN = "";
pInfo.Master_Type = "";
if (pDetail.pfileLogo != null)
{
pDetail.LOGOURL = AppLoadHelpers.PushFileToServer(pDetail.pfileLogo, AppUpload.Logo);
}
//TRA RA ID CUA BANG KHI INSERT
int _re = objBL.AppHeaderUpdate(pInfo);
// detail
if (_re >= 0)
{
pDetail.Appcode = pInfo.Appcode;
pDetail.LANGUAGE_CODE = language;
pDetail.APP_HEADER_ID = pInfo.Id;
pReturn = objDetail.App_Detail_06TMDKQT_Update(pDetail);
}
#region Phí cố định
// xóa đi
AppFeeFixBL _AppFeeFixBL = new AppFeeFixBL();
_AppFeeFixBL.AppFeeFixDelete(pInfo.Case_Code, language);
// insert lại fee
pReturn = objFeeFixBL.AppFeeFixInsertBath(pFeeFixInfo, pInfo.Case_Code);
if (pReturn < 0)
{
Transaction.Current.Rollback();
return(Json(new { status = -1 }));
}
#endregion
//tai lieu khac
#region Tài liệu khác
objDoc = new AppDocumentBL();
List <AppDocumentOthersInfo> Lst_Doc_Others = objDoc.DocumentOthers_GetByAppHeader(pInfo.Id, language);
List <AppDocumentOthersInfo> Lst_Doc_Others_Old = Lst_Doc_Others.FindAll(m => m.FILETYPE == 1).ToList();
Dictionary <decimal, AppDocumentOthersInfo> _dic_doc_others = new Dictionary <decimal, AppDocumentOthersInfo>();
foreach (AppDocumentOthersInfo item in Lst_Doc_Others_Old)
{
_dic_doc_others[item.Id] = item;
}
// xóa đi trước insert lại sau
objDoc.AppDocumentOtherDeletedByApp_Type(pInfo.Id, language, 1);
if (pReturn >= 0 && pAppDocOtherInfo != null && pAppDocOtherInfo.Count > 0)
{
int check = 0;
foreach (var info in pAppDocOtherInfo)
{
if (SessionData.CurrentUser.chashFile.ContainsKey(info.keyFileUpload))
{
string _url = (string)SessionData.CurrentUser.chashFile[info.keyFileUpload];
info.Filename = _url;
check = 1;
}
else if (_dic_doc_others.ContainsKey(info.Id))
{
info.Filename = _dic_doc_others[info.Id].Filename;
check = 1;
}
info.App_Header_Id = pInfo.Id;
info.Language_Code = language;
}
if (check == 1)
{
pReturn = objDoc.AppDocumentOtherInsertBatch(pAppDocOtherInfo);
}
}
#endregion
#region Tai lieu dinh kem
if (pReturn >= 0 && pAppDocumentInfo != null)
{
if (pAppDocumentInfo.Count > 0)
{
// Get ra để map sau đó xóa đi để insert vào sau
AppDocumentBL _AppDocumentBL = new AppDocumentBL();
List <AppDocumentInfo> Lst_AppDoc = _AppDocumentBL.AppDocument_Getby_AppHeader(pDetail.APP_HEADER_ID, language);
Dictionary <string, AppDocumentInfo> dic_appDoc = new Dictionary <string, AppDocumentInfo>();
foreach (AppDocumentInfo item in Lst_AppDoc)
{
dic_appDoc[item.Document_Id] = item;
}
// xóa đi trước
_AppDocumentBL.AppDocumentDelByApp(pDetail.APP_HEADER_ID, language);
foreach (var info in pAppDocumentInfo)
{
if (SessionData.CurrentUser.chashFile.ContainsKey(info.keyFileUpload))
{
string _url = (string)SessionData.CurrentUser.chashFile[info.keyFileUpload];
string[] _arr = _url.Split('/');
string _filename = WebApps.Resources.Resource.FileDinhKem;
if (_arr.Length > 0)
{
_filename = _arr[_arr.Length - 1];
}
info.Filename = _filename;
info.Url_Hardcopy = _url;
info.Status = 0;
}
else
{
if (dic_appDoc.ContainsKey(info.Document_Id))
{
info.Filename = dic_appDoc[info.Document_Id].Filename;
info.Url_Hardcopy = dic_appDoc[info.Document_Id].Url_Hardcopy;
info.Status = dic_appDoc[info.Document_Id].Status;
}
}
info.App_Header_Id = pInfo.Id;
info.Document_Filing_Date = CommonFuc.CurrentDate();
info.Language_Code = language;
}
pReturn = objDoc.AppDocumentInsertBath(pAppDocumentInfo, pInfo.Id);
}
}
#endregion
#region Thêm thông tin class
if (pReturn >= 0 && pAppClassInfo != null)
{
//Xoa cac class cu di
pReturn = objClassDetail.AppClassDetailDeleted(pInfo.Id, language);
pReturn = objClassDetail.AppClassDetailInsertBatch(pAppClassInfo, pInfo.Id, language);
}
//end
#endregion
if (pReturn < 0)
{
Transaction.Current.Rollback();
return(Json(new { status = -1 }));
}
else
{
scope.Complete();
_IsOk = true;
}
}
// tự động update todo
return(Json(new { status = pInfo.Id }));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(Json(new { status = ErrorCode.Error }));
}
}
public ActionResult AppDonDangKyInsert(ApplicationHeaderInfo pInfo, App_Detail_TM06DKQT_Info pDetail, List <AppDocumentInfo> pAppDocumentInfo,
List <AppDocumentOthersInfo> pAppDocOtherInfo, List <AppClassDetailInfo> pAppClassInfo)
{
try
{
//List<AppFeeFixInfo> pFeeFixInfo
Application_Header_BL objBL = new Application_Header_BL();
AppDetail06DKQT_BL objDetailBL = new AppDetail06DKQT_BL();
AppClassDetailBL objClassDetail = new AppClassDetailBL();
AppDocumentBL objDoc = new AppDocumentBL();
AppFeeFixBL objFeeFixBL = new AppFeeFixBL();
if (pInfo == null || pDetail == null)
{
return(Json(new { status = ErrorCode.Error }));
}
string language = AppsCommon.GetCurrentLang();
var CreatedBy = SessionData.CurrentUser.Username;
var CreatedDate = SessionData.CurrentUser.CurrentDate;
int pReturn = ErrorCode.Success;
int pAppHeaderID = 0;
string p_case_code = "";
List <AppFeeFixInfo> pFeeFixInfo = CommonFunction.Call_Fee.CallFee_C06(pDetail);
pDetail.LEPHI = (pFeeFixInfo[0] as AppFeeFixInfo).Amount;
using (var scope = new TransactionScope())
{
//
pInfo.Languague_Code = language;
if (pInfo.Created_By == null || pInfo.Created_By == "0" || pInfo.Created_By == "")
{
pInfo.Created_By = CreatedBy;
}
pInfo.Created_Date = CreatedDate;
//TRA RA ID CUA BANG KHI INSERT
pAppHeaderID = objBL.AppHeaderInsert(pInfo, ref p_case_code);
//Gán lại khi lấy dl
if (pAppHeaderID >= 0)
{
pReturn = objFeeFixBL.AppFeeFixInsertBath(pFeeFixInfo, p_case_code);
}
else
{
Transaction.Current.Rollback();
}
if (pReturn >= 0)
{
pDetail.Appcode = pInfo.Appcode;
pDetail.LANGUAGE_CODE = language;
pDetail.APP_HEADER_ID = pAppHeaderID;
if (pDetail.pfileLogo != null)
{
pDetail.LOGOURL = AppLoadHelpers.PushFileToServer(pDetail.pfileLogo, AppUpload.Logo);
}
pReturn = objDetailBL.App_Detail_06TMDKQT_Insert(pDetail);
//Thêm thông tin class
if (pReturn >= 0)
{
pReturn = objClassDetail.AppClassDetailInsertBatch(pAppClassInfo, pAppHeaderID, language);
}
}
//Tai lieu dinh kem
if (pReturn >= 0 && pAppDocumentInfo != null)
{
if (pAppDocumentInfo.Count > 0)
{
foreach (var info in pAppDocumentInfo)
{
if (SessionData.CurrentUser.chashFile.ContainsKey(info.keyFileUpload))
{
string _url = (string)SessionData.CurrentUser.chashFile[info.keyFileUpload];
string[] _arr = _url.Split('/');
string _filename = WebApps.Resources.Resource.FileDinhKem;
if (_arr.Length > 0)
{
_filename = _arr[_arr.Length - 1];
}
info.Filename = _filename;
info.Url_Hardcopy = _url;
info.Status = 0;
}
info.App_Header_Id = pAppHeaderID;
info.Document_Filing_Date = CommonFuc.CurrentDate();
info.Language_Code = language;
}
pReturn = objDoc.AppDocumentInsertBath(pAppDocumentInfo, pAppHeaderID);
}
}
//tai lieu khac
//tai lieu khac
if (pReturn >= 0 && pAppDocOtherInfo != null && pAppDocOtherInfo.Count > 0)
{
#region Tài liệu khác
int check = 0;
foreach (var info in pAppDocOtherInfo)
{
string _keyfileupload = "";
if (info.keyFileUpload != null)
{
_keyfileupload = info.keyFileUpload;
}
if (SessionData.CurrentUser.chashFile.ContainsKey(_keyfileupload))
{
var _updateitem = SessionData.CurrentUser.chashFile[info.keyFileUpload];
if (_updateitem.GetType() == typeof(string))
{
string _url = (string)_updateitem;
info.Filename = _url;
check = 1;
}
}
info.App_Header_Id = pAppHeaderID;
info.Language_Code = language;
}
if (check == 1)
{
pReturn = objDoc.AppDocumentOtherInsertBatch(pAppDocOtherInfo);
}
#endregion
}
//end
if (pReturn < 0)
{
Transaction.Current.Rollback();
}
else
{
scope.Complete();
}
}
return(Json(new { status = pAppHeaderID }));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(Json(new { status = ErrorCode.Error }));
}
}
