public App_Detail_PLD01_HDCN_Info GetByID(decimal p_app_header_id, string p_language_code, ref ApplicationHeaderInfo applicationHeaderInfo, ref List <AppDocumentInfo> appDocumentInfos, ref List <AppFeeFixInfo> appFeeFixInfos) { try { var objData = new App_Detail_PLD01_HDCN_DA(); DataSet dataSet = objData.GetByID(p_app_header_id, p_language_code); App_Detail_PLD01_HDCN_Info _App_Detail_PLB02_CGD_Info = CBO <App_Detail_PLD01_HDCN_Info> .FillObjectFromDataSet(dataSet); if (dataSet != null && dataSet.Tables.Count == 4) { applicationHeaderInfo = CBO <ApplicationHeaderInfo> .FillObjectFromDataTable(dataSet.Tables[1]); appDocumentInfos = CBO <AppDocumentInfo> .FillCollectionFromDataTable(dataSet.Tables[2]); appFeeFixInfos = CBO <AppFeeFixInfo> .FillCollectionFromDataTable(dataSet.Tables[3]); } return(_App_Detail_PLB02_CGD_Info); } catch (Exception ex) { Logger.LogException(ex); return(new App_Detail_PLD01_HDCN_Info()); } }
public ActionResult ExportData_IU(ApplicationHeaderInfo pInfo, App_Detail_PLD01_HDCN_Info pDetail, List <AppDocumentInfo> pAppDocumentInfo, List <AppFeeFixInfo> pFeeFixInfo) { try { string language = AppsCommon.GetCurrentLang(); // Fill export_header string fileName_docx = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "D01_VI_" + TradeMarkAppCode.AppCode_TM_4C2_PLD_01_HDCN + ".docx"); AppsCommon.Prepare_Data_Export_D01(ref pDetail, pInfo, pAppDocumentInfo, pFeeFixInfo); List <App_Detail_PLD01_HDCN_Info> _lst = new List <App_Detail_PLD01_HDCN_Info>(); _lst.Add(pDetail); DataSet _ds_all = ConvertData.ConvertToDataSet <App_Detail_PLD01_HDCN_Info>(_lst, false); _ds_all.Tables[0].TableName = "Table_4c2"; CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); string _tempfile = "TM_PLD01_HDCN.rpt"; string _datetimenow = DateTime.Now.ToString("ddMMyyyyHHmm"); string fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "D01_VN_" + _datetimenow + ".pdf"); if (language == Language.LangVI) { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "D01_VN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "D01_VN_" + _datetimenow + ".pdf"; } else { _tempfile = "TM_PLD01_HDCN_EN.rpt"; // tiếng anh fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "D01_EN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "D01_EN_" + _datetimenow + ".pdf"; } oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), _tempfile)); //oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), "TM_PLD01_HDCN.rpt")); if (_ds_all != null) { oRpt.SetDataSource(_ds_all); } oRpt.Refresh(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); System.IO.Stream oStream = oRpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); byte[] byteArray = new byte[oStream.Length]; oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1)); System.IO.File.WriteAllBytes(fileName_pdf, byteArray.ToArray()); // Requires System.Linq return(Json(new { success = 0 })); } catch (Exception ex) { Logger.LogException(ex); return(Json(new { success = 0 })); } }
public C08_Info_Export GetByID_Exp(decimal p_app_header_id, string p_language_code, ref ApplicationHeaderInfo applicationHeaderInfo, ref List <AppDocumentInfo> appDocumentInfos, ref List <AppFeeFixInfo> appFeeFixInfos, ref List <Other_MasterInfo> pOther_MasterInfo, ref List <AppDocumentOthersInfo> pAppDocOtherInfo) { try { C08_DA _obj_da = new C08_DA(); DataSet dataSet = _obj_da.GetByID(p_app_header_id, p_language_code); C08_Info_Export _C08_Info = CBO <C08_Info_Export> .FillObjectFromDataSet(dataSet); if (dataSet != null && dataSet.Tables.Count == 6) { applicationHeaderInfo = CBO <ApplicationHeaderInfo> .FillObjectFromDataTable(dataSet.Tables[1]); appDocumentInfos = CBO <AppDocumentInfo> .FillCollectionFromDataTable(dataSet.Tables[2]); appFeeFixInfos = CBO <AppFeeFixInfo> .FillCollectionFromDataTable(dataSet.Tables[3]); pOther_MasterInfo = CBO <Other_MasterInfo> .FillCollectionFromDataTable(dataSet.Tables[4]); pAppDocOtherInfo = CBO <AppDocumentOthersInfo> .FillCollectionFromDataTable(dataSet.Tables[5]); } return(_C08_Info); } catch (Exception ex) { Logger.LogException(ex); return(new C08_Info_Export()); } }
public ApplicationHeaderInfo Get_Info_After_Filling(string p_case_code, string p_user_name, string p_language_code, ref List <B_Todos_Info> b_Todos_Infos, ref List <Billing_Header_Info> billing_Header_Infos, ref List <Docking_Info> docking_Infos, ref List <App_Notice_Info> app_Notice_Infos, ref List <B_Remind_Info> b_Remind_Infos) { try { Application_Header_DA _da = new Application_Header_DA(); DataSet _ds = _da.Get_Info_After_Filling(p_case_code, p_user_name, p_language_code); ApplicationHeaderInfo _ApplicationHeaderInfo = CBO <ApplicationHeaderInfo> .FillObjectFromDataTable(_ds.Tables[0]); b_Todos_Infos = CBO <B_Todos_Info> .FillCollectionFromDataTable(_ds.Tables[1]); billing_Header_Infos = CBO <Billing_Header_Info> .FillCollectionFromDataTable(_ds.Tables[2]); docking_Infos = CBO <Docking_Info> .FillCollectionFromDataTable(_ds.Tables[3]); app_Notice_Infos = CBO <App_Notice_Info> .FillCollectionFromDataTable(_ds.Tables[4]); b_Remind_Infos = CBO <B_Remind_Info> .FillCollectionFromDataTable(_ds.Tables[5]); return(_ApplicationHeaderInfo); } catch (Exception ex) { Logger.LogException(ex); return(new ApplicationHeaderInfo()); } }
void Get_AppHeaderbyId(decimal p_AppHeaderId = 0) { try { Application_Header_BL _Application_Header_BL = new Application_Header_BL(); c_ApplicationHeaderInfo = _Application_Header_BL.GetApplicationHeader_ById(p_AppHeaderId, AppsCommon.GetCurrentLang()); } catch (Exception ex) { Logger.LogException(ex); } }
public int AppHeaderUpdate(ApplicationHeaderInfo pInfo) { try { Application_Header_DA objData = new Application_Header_DA(); return(objData.AppHeaderUpdate(pInfo)); } catch (Exception ex) { Logger.LogException(ex); return(ErrorCode.Error); } }
/// <summary> /// /// </summary> /// <param name="pInfo"></param> /// <returns>TRA RA ID CUA BANG KHI INSERT THANH CONG</returns> public int AppHeaderInsert(ApplicationHeaderInfo pInfo, ref string p_case_code) { try { Application_Header_DA objData = new Application_Header_DA(); return(objData.AppHeaderInsert(pInfo, ref p_case_code)); } catch (Exception ex) { Logger.LogException(ex); return(ErrorCode.Error); } }
public ActionResult FillTT_Header(string appno) { try { Application_Header_BL objBL = new Application_Header_BL(); ApplicationHeaderInfo _applicationheaderinfo = objBL.GetMasterByAppNo(appno, "", ""); ViewBag.objAppHeaderInfo = _applicationheaderinfo; return(PartialView("~/Areas/TradeMark/Views/Shared/_PartialThongTinDaiDienChuDon.cshtml", "2")); } catch (Exception ex) { Logger.LogException(ex); return(PartialView("~/Areas/TradeMark/Views/Shared/_PartialThongTinDaiDienChuDon.cshtml", "2")); } }
public ActionResult GetFee(ApplicationHeaderInfo pInfo, App_Detail_PLD01_HDCN_Info pDetail, List <AppFeeFixInfo> pFeeFixInfo) { try { List <AppFeeFixInfo> _lstFeeFix = Call_Fee.CallFee_D01(pDetail, pFeeFixInfo); 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 GetFee_View(ApplicationHeaderInfo pInfo) { try { AppFeeFixBL _AppFeeFixBL = new AppFeeFixBL(); List<AppFeeFixInfo> _lstFeeFix = _AppFeeFixBL.GetByCaseCode(pInfo.Case_Code); 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 A01_Info_Export GetByID_Exp(decimal p_app_header_id, string p_language_code, ref ApplicationHeaderInfo applicationHeaderInfo, ref List <AppDocumentInfo> appDocumentInfos, ref List <AppFeeFixInfo> appFeeFixInfos, ref List <AuthorsInfo> pAppAuthorsInfo, ref List <Other_MasterInfo> pOther_MasterInfo, ref List <AppClassDetailInfo> appClassDetailInfos, ref List <AppDocumentOthersInfo> pAppDocOtherInfo, ref List <UTienInfo> pUTienInfo, ref List <AppDocumentOthersInfo> pLstImagePublic) { try { A01_DA _obj_da = new A01_DA(); DataSet dataSet = _obj_da.GetByID(p_app_header_id, p_language_code); A01_Info_Export _A01_Info = CBO <A01_Info_Export> .FillObjectFromDataSet(dataSet); if (dataSet != null && dataSet.Tables.Count == 10) { applicationHeaderInfo = CBO <ApplicationHeaderInfo> .FillObjectFromDataTable(dataSet.Tables[1]); appDocumentInfos = CBO <AppDocumentInfo> .FillCollectionFromDataTable(dataSet.Tables[2]); appFeeFixInfos = CBO <AppFeeFixInfo> .FillCollectionFromDataTable(dataSet.Tables[3]); pOther_MasterInfo = CBO <Other_MasterInfo> .FillCollectionFromDataTable(dataSet.Tables[4]); pAppAuthorsInfo = CBO <AuthorsInfo> .FillCollectionFromDataTable(dataSet.Tables[5]); appClassDetailInfos = CBO <AppClassDetailInfo> .FillCollectionFromDataTable(dataSet.Tables[6]); pAppDocOtherInfo = CBO <AppDocumentOthersInfo> .FillCollectionFromDataTable(dataSet.Tables[7]); pUTienInfo = CBO <UTienInfo> .FillCollectionFromDataTable(dataSet.Tables[8]); pLstImagePublic = CBO <AppDocumentOthersInfo> .FillCollectionFromDataTable(dataSet.Tables[9]); } return(_A01_Info); } catch (Exception ex) { Logger.LogException(ex); return(new A01_Info_Export()); } }
public ActionResult GetFee(ApplicationHeaderInfo pInfo, App_Detail_PLB01_SDD_Info pDetail, List <AppDocumentInfo> pAppDocumentInfo, List <UTienInfo> pUTienInfo, List <AppDocumentOthersInfo> pLstImagePublic) { try { //AppsCommon.Prepare_Data_Export_3B(ref pDetail, pInfo, pAppDocumentInfo); List <AppFeeFixInfo> _lstFeeFix = Call_Fee.CallFee_3B(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); //return PartialView("~/Areas/Patent/Views/A01/_PartialTableListFees.cshtml"); }
public Billing_Header_Info Billing_GetBy_Code(string p_case_code, string p_language_code, ref ApplicationHeaderInfo applicationHeaderInfo, ref List <Billing_Detail_Info> p_lst_billing_detail) { try { Billing_DA _da = new Billing_DA(); DataSet _ds = _da.Billing_GetBy_Code(p_case_code, p_language_code); p_lst_billing_detail = CBO <Billing_Detail_Info> .FillCollectionFromDataTable(_ds.Tables[1]); applicationHeaderInfo = CBO <ApplicationHeaderInfo> .FillObjectFromDataTable(_ds.Tables[2]); return(CBO <Billing_Header_Info> .FillObjectFromDataTable(_ds.Tables[0])); } catch (Exception ex) { Logger.LogException(ex); return(new Billing_Header_Info()); } }
public ActionResult getMasterByAppNo(string p_appNo) { try { Application_Header_BL _bl = new Application_Header_BL(); ApplicationHeaderInfo objAppHeaderInfo = _bl.GetMasterByAppNo(p_appNo, SessionData.CurrentUser.Username, AppsCommon.GetCurrentLang()); ViewBag.objAppHeaderInfo = objAppHeaderInfo; var PartialThongTinChuDon = AppsCommon.RenderRazorViewToString(this.ControllerContext, "~/Areas/TradeMark/Views/Shared/_PartialThongTinChuDon.cshtml", "1"); var PartialThongTinDaiDienChuDon = AppsCommon.RenderRazorViewToString(this.ControllerContext, "~/Areas/TradeMark/Views/Shared/_PartialThongTinDaiDienChuDon.cshtml", "2"); var json = Json(new { PartialThongTinChuDon, PartialThongTinDaiDienChuDon }); return(json); } catch (Exception ex) { Logger.LogException(ex); return(PartialView("~/Areas/TradeMark/Views/Shared/_PartialThongTinChuDon.cshtml")); } }
public A02_Info GetByID(decimal p_app_header_id, string p_language_code, ref ApplicationHeaderInfo applicationHeaderInfo, ref List <AppDocumentInfo> appDocumentInfos, ref List <AppFeeFixInfo> appFeeFixInfos, ref List <AuthorsInfo> pAppAuthorsInfo, ref List <Other_MasterInfo> pOther_MasterInfo, ref List <AppDocumentOthersInfo> pAppDocOtherInfo, ref List <AppDocumentOthersInfo> pAppDocDesign) { try { A02_DA _obj_da = new A02_DA(); DataSet dataSet = _obj_da.GetByID(p_app_header_id, p_language_code); A02_Info _A02_Info = CBO <A02_Info> .FillObjectFromDataSet(dataSet); if (dataSet != null && dataSet.Tables.Count == 8) { applicationHeaderInfo = CBO <ApplicationHeaderInfo> .FillObjectFromDataTable(dataSet.Tables[1]); appDocumentInfos = CBO <AppDocumentInfo> .FillCollectionFromDataTable(dataSet.Tables[2]); appFeeFixInfos = CBO <AppFeeFixInfo> .FillCollectionFromDataTable(dataSet.Tables[3]); pOther_MasterInfo = CBO <Other_MasterInfo> .FillCollectionFromDataTable(dataSet.Tables[4]); pAppAuthorsInfo = CBO <AuthorsInfo> .FillCollectionFromDataTable(dataSet.Tables[5]); pAppDocOtherInfo = CBO <AppDocumentOthersInfo> .FillCollectionFromDataTable(dataSet.Tables[6]); pAppDocDesign = CBO <AppDocumentOthersInfo> .FillCollectionFromDataTable(dataSet.Tables[7]); } return(_A02_Info); } catch (Exception ex) { Logger.LogException(ex); return(new A02_Info()); } }
public ActionResult ExportDataNew(ApplicationHeaderInfo pInfo, AppTM06DKQTInfoExport pDetail, List <AppDocumentInfo> pAppDocumentInfo, List <AppClassDetailInfo> pAppClassInfo) { try { // AppTM06DKQTInfoExport pDetail= new AppTM06DKQTInfoExport(); string _fileTemp = System.Web.HttpContext.Current.Server.MapPath("/Content/AppForms/C06_Request for_international_trademark_registration_vi_exp.doc"); // Fill export_header string fileName = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C06_Request_for_international_trademark_registration_vi_exp_" + pInfo.Appcode + ".pdf"); // Fill export_detail pDetail.Status = 254; pDetail.Status_Form = 252; pDetail.Relationship = "11"; pDetail.strNgayNopDon = pDetail.NGAYNOPDON.ToDateStringN0(); if (pDetail.REF_APPNO_TEXT != null) { pDetail.REF_APPNO_TEXT = pDetail.REF_APPNO_TEXT.Trim(); } pDetail = CreateInstanceTM06DKQT.CopyAppHeaderInfo(pDetail, pInfo); if (pAppClassInfo != null) { Hashtable _hsGroupclass = new Hashtable(); foreach (var item in pAppClassInfo) { AppClassDetailInfo _newinfo = new AppClassDetailInfo(); _newinfo.CloneObj(); if (_hsGroupclass.ContainsKey(item.Code.Substring(0, 2))) { _newinfo = (AppClassDetailInfo)_hsGroupclass[item.Code.Substring(0, 2)]; } _newinfo.Code = item.Code; _newinfo.Textinput += item.Textinput + ", "; _newinfo.IntTongSanPham++; _hsGroupclass[item.Code.Substring(0, 2)] = _newinfo; } List <AppClassDetailInfo> _listApp = new List <AppClassDetailInfo>(); foreach (DictionaryEntry item in _hsGroupclass) { _listApp.Add((AppClassDetailInfo)item.Value); } foreach (AppClassDetailInfo item in _listApp.OrderBy(m => m.Code)) { pDetail.strListClass += "Nhóm " + item.Code.Substring(0, 2) + ": " + item.Textinput.Trim().Trim(',') + " (" + (item.IntTongSanPham < 10 ? "0" + item.IntTongSanPham.ToString() : item.IntTongSanPham.ToString()) + " sản phẩm)" + "\n"; } } // đẩy file lên server if (pDetail.pfileLogo != null) { pDetail.LOGOURL = AppLoadHelpers.PushFileToServer(pDetail.pfileLogo, AppUpload.Logo); } if (!string.IsNullOrEmpty(pDetail.LOGOURL)) { //Kết xuất ảnh } #region hiển thị tài liệu đính kèm if (pAppDocumentInfo == null) { pAppDocumentInfo = new List <AppDocumentInfo>(); } foreach (AppDocumentInfo item in pAppDocumentInfo) { if (item.Document_Id == "C06DKQT_D_01") { pDetail.TOKHAI_USED = item.Isuse.ToString(); pDetail.TOKHAI_SOTRANG = item.CHAR01; pDetail.TOKHAI_SOBAN = item.CHAR02; continue; } if (item.Document_Id == "C06DKQT_D_02") { pDetail.MAUDK_VPQT_USED = item.Isuse.ToString(); pDetail.MAUDK_VPQT_SO = item.CHAR01; pDetail.MAUDK_VPQT_NGONNGU = item.CHAR02; pDetail.MAUDK_VPQT_SOTRANG = item.CHAR03; pDetail.MAUDK_VPQT_SOBAN = item.CHAR04; continue; } if (item.Document_Id == "C06DKQT_D_03") { pDetail.MAUNDH_USED = item.Isuse.ToString(); pDetail.MAUNDH_SOMAU = item.CHAR01; continue; } if (item.Document_Id == "C06DKQT_D_04") { pDetail.BANSAO_TOKHAI_USED = item.Isuse.ToString(); continue; } if (item.Document_Id == "C06DKQT_D_05") { pDetail.BANSAO_GIAYDK_NHCS_USED = item.Isuse.ToString(); continue; } if (item.Document_Id == "C06DKQT_D_06") { pDetail.BAN_CK_SD_NGANHANG_USED = item.Isuse.ToString(); continue; } if (item.Document_Id == "C06DKQT_D_07") { pDetail.GIAY_UQ_USED = item.Isuse.ToString(); pDetail.GIAY_UQ_NGONNGU = item.CHAR01; continue; } if (item.Document_Id == "C06DKQT_D_08") { pDetail.GIAY_UQ_BANDICH_USED = item.Isuse.ToString(); pDetail.GIAY_UQ_BANDICH_SOTRANG = item.CHAR01; continue; } if (item.Document_Id == "C06DKQT_D_09") { pDetail.GIAY_UQ_BANDICH_BANGOC_USED = item.Isuse.ToString(); continue; } if (item.Document_Id == "C06DKQT_D_010") { pDetail.GIAY_UQ_BANDICH_BANSAO_USED = item.Isuse.ToString(); continue; } if (item.Document_Id == "C06DKQT_D_011") { pDetail.GIAY_UQ_BANGOCNOPSAU_USED = item.Isuse.ToString(); continue; } if (item.Document_Id == "C06DKQT_D_012") { pDetail.GIAY_UQ_BANGOCNOP_THEOSO_USED = item.Isuse.ToString(); pDetail.GIAY_UQ_BANGOCNOP_THEOSO = item.CHAR01; continue; } if (item.Document_Id == "C06DKQT_D_013") { pDetail.CHUNGTU_LEPHI_USED = item.Isuse.ToString(); continue; } if (item.Document_Id == "C06DKQT_D_014") { pDetail.TAILIEUBOSUNG_USED = item.Isuse.ToString(); pDetail.TAILIEUBOSUNG = item.CHAR01; continue; } } #endregion List <AppFeeFixInfo> pFeeFixInfo = CommonFunction.Call_Fee.CallFee_C06(pDetail); pDetail.LEPHI = (pFeeFixInfo[0] as AppFeeFixInfo).Amount; if (pInfo.Languague_Code == Language.LangEN) { pDetail.LEPHI = (pFeeFixInfo[0] as AppFeeFixInfo).Amount_Usd; } List <AppTM06DKQTInfoExport> _lst = new List <AppTM06DKQTInfoExport>(); pDetail.LOGOURL = Server.MapPath(pDetail.LOGOURL); _lst.Add(pDetail); DataSet _ds_all = ConvertData.ConvertToDataSet <AppTM06DKQTInfoExport>(_lst, false); CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); string _tempfile = "C06.rpt"; //if(AppsCommon.GetCurrentLang() == Language.LangEN) if (pInfo.Languague_Code != Language.LangVI) { _tempfile = "C06.rpt"; } oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), _tempfile), OpenReportMethod.OpenReportByTempCopy); // _ds_all.WriteXmlSchema(@"C:\Users\user\Desktop\LEGALTECH\XMLFILE\TM06DKQT.xml"); //Logger.LogInfo("b3: "); CrystalDecisions.CrystalReports.Engine.PictureObject _pic01; _pic01 = (CrystalDecisions.CrystalReports.Engine.PictureObject)oRpt.ReportDefinition.Sections[0].ReportObjects["Picture1"]; _pic01.Width = 200; _pic01.Height = 200; System.IO.FileInfo file = new System.IO.FileInfo(pDetail.LOGOURL); Bitmap img = new Bitmap(pDetail.LOGOURL); try { double _Const = 6.666666666666 / 2; int _left = 0, _top = 0, _marginleft = 225, _margintop = 5580; int _h = 600; double _d1 = (_h - img.Width) / 2; _d1 = _Const * _d1; _left = _marginleft + Convert.ToInt32(_d1); if (_left < 0) { _left = _marginleft; } _pic01.Left = _left; // top _d1 = (_h - img.Height) / 2; _d1 = _Const * _d1; _top = _margintop + Convert.ToInt32(_d1); if (_top < 0) { _top = _margintop; } _pic01.Top = _top; } catch (Exception) { } finally { img.Dispose(); } if (_ds_all != null) { _ds_all.Tables[0].TableName = "Table1"; oRpt.SetDataSource(_ds_all); } oRpt.Refresh(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); System.IO.Stream oStream = oRpt.ExportToStream(ExportFormatType.PortableDocFormat); byte[] byteArray = new byte[oStream.Length]; oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1)); System.IO.File.WriteAllBytes(fileName, byteArray.ToArray()); // Requires System.Linq return(Json(new { success = 0 })); } catch (Exception ex) { Logger.LogException(ex); return(Json(new { success = 0 })); } }
public ActionResult App_Re_Grant2Lawer() { try { if (SessionData.CurrentUser == null) { return(Redirect("/")); } string p_case_code = ""; if (RouteData.Values.ContainsKey("id")) { p_case_code = RouteData.Values["id"].ToString(); } // action là view hay sửa decimal _operator_type = Convert.ToDecimal(Common.CommonData.CommonEnums.Operator_Type.Update); if (RouteData.Values.ContainsKey("id1")) { _operator_type = Convert.ToDecimal(RouteData.Values["id1"].ToString()); } ViewBag.Operator_Type = _operator_type; Application_Header_BL _objBl = new Application_Header_BL(); ApplicationHeaderInfo _ApplicationHeaderInfo = _objBl.GetApp_By_Case_Code_Todo(p_case_code, SessionData.CurrentUser.Username, AppsCommon.GetCurrentLang()); string pAppCode = _ApplicationHeaderInfo.Appcode; SessionData.CurrentUser.chashFile.Clear(); ViewBag.Appcode = pAppCode; ViewBag.Currstatus = (int)_ApplicationHeaderInfo.Status; ViewBag.objAppHeaderInfo = _ApplicationHeaderInfo; // ép cứng đến 1 trạng thái ViewBag.Re_Grant = 1; if (RouteData.Values.ContainsKey("id2")) { ViewBag.Hard_Status = Convert.ToDecimal(RouteData.Values["id2"].ToString()); } // lấy dữ liệu lịch sử giao dịch B_Todos_BL _B_Todos_BL = new B_Todos_BL(); List <B_Remind_Info> _ListRemind = new List <B_Remind_Info>(); List <B_Todos_Info> _Listtodo = _B_Todos_BL.NotifiGetByCasecode(p_case_code, ref _ListRemind); ViewBag.ListTodo = _Listtodo; ViewBag.ListRemind = _ListRemind; // sau advise filing if (_ApplicationHeaderInfo.Status >= (decimal)CommonEnums.App_Status.AdminGuiKetQuaNopDon && _ApplicationHeaderInfo.Status != (decimal)CommonEnums.App_Status.AdminTuChoiKetQuaNopDon) { // LẤY THÔNG TIN CỦA THẰNG NOTICE APP App_Notice_Info_BL _notice_BL = new App_Notice_Info_BL(); App_Notice_Info _App_Notice_Info = _notice_BL.App_Notice_GetBy_CaseCode(p_case_code); ViewBag.App_Notice_Info = _App_Notice_Info; return(View("/Areas/TradeMark/Views/Shared/AppDetail/AppDetails_After_Filing.cshtml")); } else { return(View("/Areas/TradeMark/Views/Shared/AppDetail/AppDetails.cshtml")); } } catch (Exception ex) { Logger.LogException(ex); return(View("/Areas/TradeMark/Views/Shared/AppDetail/AppDetails.cshtml")); } }
public static void Prepare_Data_Export_C07(ref C07_Info_Export app_Detail, ApplicationHeaderInfo applicationHeaderInfo, List<AppDocumentInfo> appDocumentInfos, List<AppFeeFixInfo> _lst_appFeeFixInfos, List<Other_MasterInfo> _lst_Other_MasterInfo, List<AppDocumentOthersInfo> _LstDocumentOthersInfo, List<AppClassDetailInfo> appClassDetailInfos) { try { // copy Header C07_Info_Export.CopyAppHeaderInfo(ref app_Detail, applicationHeaderInfo); // copy class // copy tác giả // copy chủ đơn khác if (_lst_Other_MasterInfo != null && _lst_Other_MasterInfo.Count > 1) { C07_Info_Export.CopyOther_MasterInfo(ref app_Detail, _lst_Other_MasterInfo[0], 0); } else { C07_Info_Export.CopyOther_MasterInfo(ref app_Detail, null, 0); } if (_lst_Other_MasterInfo != null && _lst_Other_MasterInfo.Count > 2) { C07_Info_Export.CopyOther_MasterInfo(ref app_Detail, _lst_Other_MasterInfo[1], 1); } else { C07_Info_Export.CopyOther_MasterInfo(ref app_Detail, null, 1); } #region Tài liệu có trong đơn if (_LstDocumentOthersInfo != null) { foreach (var item in _LstDocumentOthersInfo) { if (!string.IsNullOrEmpty(item.Documentname)) { app_Detail.strDanhSachFileDinhKem += item.Documentname + " ; "; } } if (!string.IsNullOrEmpty(app_Detail.strDanhSachFileDinhKem)) { app_Detail.strDanhSachFileDinhKem = app_Detail.strDanhSachFileDinhKem.Substring(0, app_Detail.strDanhSachFileDinhKem.Length - 2); } } if (appDocumentInfos != null) { foreach (AppDocumentInfo item in appDocumentInfos) { if (item.Document_Id == "C07_00") { app_Detail.Doc_Id_0 = item.CHAR01; app_Detail.Doc_Id_002 = item.CHAR02; app_Detail.Doc_Id_0_Check = item.Isuse; } if (item.Document_Id == "C07_01") { app_Detail.Doc_Id_1 = item.CHAR01; app_Detail.Doc_Id_102 = item.CHAR02; app_Detail.Doc_Id_1_Check = item.Isuse; } else if (item.Document_Id == "C07_02") { app_Detail.Doc_Id_2 = item.CHAR01; app_Detail.Doc_Id_202 = item.CHAR02; app_Detail.Doc_Id_2_Check = item.Isuse; } else if (item.Document_Id == "C07_03") { app_Detail.Doc_Id_3_Check = item.Isuse; app_Detail.Doc_Id_3 = item.CHAR01; app_Detail.Doc_Id_302 = item.CHAR02; } else if (item.Document_Id == "C07_04") { app_Detail.Doc_Id_4 = item.CHAR01; app_Detail.Doc_Id_4_Check = item.Isuse; app_Detail.Doc_Id_402 = item.CHAR02; } else if (item.Document_Id == "C07_05") { app_Detail.Doc_Id_5_Check = item.Isuse; app_Detail.Doc_Id_5 = item.CHAR01; } else if (item.Document_Id == "C07_06") { app_Detail.Doc_Id_6_Check = item.Isuse; app_Detail.Doc_Id_6 = item.CHAR01; } else if (item.Document_Id == "C07_07") { app_Detail.Doc_Id_7_Check = item.Isuse; app_Detail.Doc_Id_7 = item.CHAR01; } else if (item.Document_Id == "C07_08") { app_Detail.Doc_Id_8_Check = item.Isuse; app_Detail.Doc_Id_8 = item.CHAR01; } else if (item.Document_Id == "C07_09") { app_Detail.Doc_Id_9 = item.CHAR01; app_Detail.Doc_Id_9_Check = item.Isuse; } else if (item.Document_Id == "C07_10") { app_Detail.Doc_Id_10_Check = item.Isuse; app_Detail.Doc_Id_10 = item.CHAR01; } else if (item.Document_Id == "C07_11") { app_Detail.Doc_Id_11_Check = item.Isuse; app_Detail.Doc_Id_11 = item.CHAR01; } } } #endregion #region Fee if (_lst_appFeeFixInfos.Count > 0) { foreach (var item in _lst_appFeeFixInfos) { if (item.Fee_Id == 1) { app_Detail.Fee_Id_1 = item.Isuse == 0 ? "" : item.Number_Of_Patent.ToString(); app_Detail.Fee_Id_1_Check = item.Isuse; app_Detail.Fee_Id_1_Val = item.Amount.ToString("#,##0.##"); } else if (item.Fee_Id == 2) { app_Detail.Fee_Id_2 = item.Isuse == 0 ? "" : item.Number_Of_Patent.ToString(); app_Detail.Fee_Id_2_Check = item.Isuse; app_Detail.Fee_Id_2_Val = item.Amount.ToString("#,##0.##"); } else if (item.Fee_Id == 21) { app_Detail.Fee_Id_21 = item.Isuse == 0 ? "" : item.Number_Of_Patent.ToString(); app_Detail.Fee_Id_21_Check = item.Isuse; app_Detail.Fee_Id_21_Val = item.Amount.ToString("#,##0.##"); } else if (item.Fee_Id == 3) { app_Detail.Fee_Id_3 = item.Isuse == 0 ? "" : item.Number_Of_Patent.ToString(); app_Detail.Fee_Id_3_Check = item.Isuse; app_Detail.Fee_Id_3_Val = item.Amount.ToString("#,##0.##"); } else if (item.Fee_Id == 4) { app_Detail.Fee_Id_4 = item.Isuse == 0 ? "" : item.Number_Of_Patent.ToString(); app_Detail.Fee_Id_4_Check = item.Isuse; app_Detail.Fee_Id_4_Val = item.Amount.ToString("#,##0.##"); } else if (item.Fee_Id == 41) { app_Detail.Fee_Id_41 = item.Isuse == 0 ? "" : item.Number_Of_Patent.ToString(); app_Detail.Fee_Id_41_Check = item.Isuse; app_Detail.Fee_Id_41_Val = item.Amount.ToString("#,##0.##"); } else if (item.Fee_Id == 5) { app_Detail.Fee_Id_5 = item.Isuse == 0 ? "" : item.Number_Of_Patent.ToString(); app_Detail.Fee_Id_5_Check = item.Isuse; app_Detail.Fee_Id_5_Val = item.Amount.ToString("#,##0.##"); } else if (item.Fee_Id == 51) { app_Detail.Fee_Id_51 = item.Isuse == 0 ? "" : item.Number_Of_Patent.ToString(); app_Detail.Fee_Id_51_Check = item.Isuse; app_Detail.Fee_Id_51_Val = item.Amount.ToString("#,##0.##"); } app_Detail.Total_Fee = app_Detail.Total_Fee + item.Amount; app_Detail.Total_Fee_Str = app_Detail.Total_Fee.ToString("#,##0.##"); } } #endregion #region class foreach (AppClassDetailInfo item in appClassDetailInfos.OrderBy(m => m.Code)) { // nếu là tiếng việt thì hiện tiếng anh if (AppsCommon.GetCurrentLang() == "VI_VN") { app_Detail.strListClass += "Nhóm" + item.Code.Substring(0, 2) + ": " + item.Textinput.Trim().Trim(',') + " (" + (item.IntTongSanPham < 10 ? "0" + item.IntTongSanPham.ToString() : item.IntTongSanPham.ToString()) + " " + "sản phẩm" + " )" + "\n"; } else { app_Detail.strListClass += "Class " + item.Code.Substring(0, 2) + ": " + item.Textinput.Trim().Trim(',') + " (" + (item.IntTongSanPham < 10 ? "0" + item.IntTongSanPham.ToString() : item.IntTongSanPham.ToString()) + " " + "gooods" + " )" + "\n"; } } #endregion } catch (Exception ex) { Logger.LogException(ex); } }
public ActionResult Register(ApplicationHeaderInfo pInfo, C07_Info pDetail, List<AppDocumentInfo> pAppDocumentInfo, List<AppFeeFixInfo> pFeeFixInfo, List<Other_MasterInfo> pOther_MasterInfo, List<AppDocumentOthersInfo> pAppDocOtherInfo, List<AppClassDetailInfo> pAppClassInfo) { try { Application_Header_BL objBL = new Application_Header_BL(); AppFeeFixBL objFeeFixBL = new AppFeeFixBL(); C07_BL objDetail = new C07_BL(); AppDocumentBL objDoc = new AppDocumentBL(); Other_Master_BL _Other_Master_BL = new Other_Master_BL(); Author_BL _Author_BL = new Author_BL(); AppClassDetailBL objClassDetail = new AppClassDetailBL(); 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; int pAppHeaderID = 0; string p_case_code = ""; 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; pInfo.Send_Date = DateTime.Now; //TRA RA ID CUA BANG KHI INSERT pAppHeaderID = objBL.AppHeaderInsert(pInfo, ref p_case_code); if (pAppHeaderID < 0) goto Commit_Transaction; // detail if (pAppHeaderID >= 0) { pDetail.Appcode = pInfo.Appcode; pDetail.Language_Code = language; pDetail.App_Header_Id = pAppHeaderID; pDetail.Case_Code = p_case_code; if (pDetail.pfileLogo != null) { pDetail.LOGOURL = AppLoadHelpers.PushFileToServer(pDetail.pfileLogo, AppUpload.Logo); } pReturn = objDetail.Insert(pDetail); if (pReturn < 0) goto Commit_Transaction; // thêm thông tin class pReturn = objClassDetail.AppClassDetailInsertBatch(pAppClassInfo, pAppHeaderID, language); if (pReturn < 0) goto Commit_Transaction; } if (pOther_MasterInfo != null && pOther_MasterInfo.Count > 0) { foreach (var item in pOther_MasterInfo) { item.Case_Code = p_case_code; item.App_Header_Id = pAppHeaderID; } decimal _re = _Other_Master_BL.Insert(pOther_MasterInfo); if (_re <= 0) goto Commit_Transaction; } //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 } #region tính phí List<AppFeeFixInfo> _lstFeeFix = Call_Fee.CallFee_C07(pDetail, pAppClassInfo); if (_lstFeeFix.Count > 0) { AppFeeFixBL _AppFeeFixBL = new AppFeeFixBL(); pReturn = _AppFeeFixBL.AppFeeFixInsertBath(_lstFeeFix, p_case_code); if (pReturn < 0) goto Commit_Transaction; } #endregion #region 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)) { var _updateitem = SessionData.CurrentUser.chashFile[info.keyFileUpload]; if (_updateitem.GetType() == typeof(string)) { string _url = (string)_updateitem; 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); } } #endregion //end Commit_Transaction: if (pReturn < 0) { Transaction.Current.Rollback(); return Json(new { status = -1 }); } else { scope.Complete(); } } return Json(new { status = pAppHeaderID }); } catch (Exception ex) { Logger.LogException(ex); return Json(new { status = ErrorCode.Error }); } }
public ActionResult ExportData_View(decimal pAppHeaderId, string p_appCode, string p_Language) { try { string _datetimenow = DateTime.Now.ToString("ddMMyyyyHHmm"); string language = AppsCommon.GetCurrentLang(); var objBL = new C07_BL(); List<C07_Info_Export> _lst = new List<C07_Info_Export>(); List<AppDocumentInfo> appDocumentInfos = new List<AppDocumentInfo>(); List<AppFeeFixInfo> _lst_appFeeFixInfos = new List<AppFeeFixInfo>(); ApplicationHeaderInfo applicationHeaderInfo = new ApplicationHeaderInfo(); List<Other_MasterInfo> _lst_Other_MasterInfo = new List<Other_MasterInfo>(); List<AppDocumentOthersInfo> _LstDocumentOthersInfo = new List<AppDocumentOthersInfo>(); List<AppClassDetailInfo> appClassDetailInfos = new List<AppClassDetailInfo>(); C07_Info_Export pDetail = objBL.GetByID_Exp(pAppHeaderId, language, ref applicationHeaderInfo, ref appDocumentInfos, ref _lst_appFeeFixInfos, ref _lst_Other_MasterInfo, ref _LstDocumentOthersInfo, ref appClassDetailInfos); pDetail.LOGOURL = Server.MapPath(pDetail.LOGOURL); string fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C07_VN_" + _datetimenow + ".pdf"); if (pDetail.Languague_Code == Language.LangVI) { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C07_VN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "C07_VN_" + _datetimenow + ".pdf"; } else { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C07_EN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "C07_EN_" + _datetimenow + ".pdf"; } Prepare_Data_Export_C07(ref pDetail, applicationHeaderInfo, appDocumentInfos, _lst_appFeeFixInfos, _lst_Other_MasterInfo, _LstDocumentOthersInfo, appClassDetailInfos); _lst.Add(pDetail); DataSet _ds_all = ConvertData.ConvertToDataSet<C07_Info_Export>(_lst, false); try { _ds_all.WriteXml(@"C:\inetpub\C07.xml", XmlWriteMode.WriteSchema); } catch (Exception ex) { Logger.LogException(ex); } CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); string _tempfile = "C07.rpt"; if (p_Language == Language.LangEN) { _tempfile = "C07_EN.rpt"; } oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), _tempfile)); #region Set vị trí ảnh CrystalDecisions.CrystalReports.Engine.PictureObject _pic01; _pic01 = (CrystalDecisions.CrystalReports.Engine.PictureObject)oRpt.ReportDefinition.Sections[0].ReportObjects["Picture1"]; _pic01.Width = 200; _pic01.Height = 200; try { Bitmap img = new Bitmap(pDetail.LOGOURL); try { double _Const = 6.666666666666/2; int _left = 0, _top = 0, _marginleft = 225, _margintop = 5580; int _h = 600; double _d1 = (_h - img.Width) / 2; _d1 = _Const * _d1; _left = _marginleft + Convert.ToInt32(_d1); if (_left < 0) { _left = _marginleft; } _pic01.Left = _left; // top _d1 = (_h - img.Height) / 2; _d1 = _Const * _d1; _top = _margintop + Convert.ToInt32(_d1); if (_top < 0) { _top = _margintop; } _pic01.Top = _top; } catch (Exception ex) { Logger.LogException(ex); } finally { img.Dispose(); } } catch (Exception ex) { } System.IO.FileInfo file = new System.IO.FileInfo(pDetail.LOGOURL); #endregion if (_ds_all != null) { _ds_all.Tables[0].TableName = "Table"; oRpt.SetDataSource(_ds_all); } oRpt.Refresh(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); //oRpt.ExportToDisk(ExportFormatType.PortableDocFormat, fileName_pdf); System.IO.Stream oStream = oRpt.ExportToStream(ExportFormatType.PortableDocFormat); byte[] byteArray = new byte[oStream.Length]; oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1)); System.IO.File.WriteAllBytes(fileName_pdf, byteArray.ToArray()); // Requires System.Linq return Json(new { success = 0 }); } catch (Exception ex) { Logger.LogException(ex); return Json(new { success = 0 }); } }
public ActionResult Edit(ApplicationHeaderInfo pInfo, C07_Info pDetail, List<AppDocumentInfo> pAppDocumentInfo, List<AppFeeFixInfo> pFeeFixInfo, List<Other_MasterInfo> pOther_MasterInfo, List<AppDocumentOthersInfo> pAppDocOtherInfo, List<AppClassDetailInfo> pAppClassInfo) { try { Application_Header_BL objBL = new Application_Header_BL(); AppFeeFixBL objFeeFixBL = new AppFeeFixBL(); C07_BL objDetail = new C07_BL(); AppClassDetailBL objClassDetail = new AppClassDetailBL(); if (pInfo == null || pDetail == null) return Json(new { status = ErrorCode.Error }); string language = AppsCommon.GetCurrentLang(); decimal pReturn = ErrorCode.Success; int pAppHeaderID = (int)pInfo.Id; string p_case_code = pInfo.Case_Code; 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 = ""; //TRA RA ID CUA BANG KHI INSERT pReturn = objBL.AppHeaderUpdate(pInfo); if (pReturn < 0) goto Commit_Transaction; // detail if (pAppHeaderID >= 0) { pDetail.Appcode = pInfo.Appcode; pDetail.Language_Code = language; pDetail.App_Header_Id = pAppHeaderID; pDetail.Case_Code = p_case_code; if (pDetail.pfileLogo != null) { pDetail.LOGOURL = AppLoadHelpers.PushFileToServer(pDetail.pfileLogo, AppUpload.Logo); } else { pDetail.LOGOURL = pDetail.IMG_URLOrg; } pReturn = objDetail.UpDate(pDetail); if (pReturn < 0) goto Commit_Transaction; #region Thêm thông tin class if (pReturn >= 0 && pAppClassInfo != null) { //Xoa cac class cu di pReturn = objClassDetail.AppClassDetailDeleted(pInfo.Id, language); if (pReturn < 0) goto Commit_Transaction; pReturn = objClassDetail.AppClassDetailInsertBatch(pAppClassInfo, pInfo.Id, language); if (pReturn < 0) goto Commit_Transaction; } #endregion } // ok Other_Master_BL _Other_Master_BL = new Other_Master_BL(); _Other_Master_BL.Deleted(pInfo.Case_Code, language); if (pOther_MasterInfo != null && pOther_MasterInfo.Count > 0) { foreach (var item in pOther_MasterInfo) { item.Case_Code = pInfo.Case_Code; item.App_Header_Id = pAppHeaderID; } decimal _re = _Other_Master_BL.Insert(pOther_MasterInfo); if (_re <= 0) goto Commit_Transaction; } //tai lieu khac #region Tài liệu khác AppDocumentBL 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 = pAppHeaderID; info.Language_Code = language; } if (check == 1) { pReturn = objDoc.AppDocumentOtherInsertBatch(pAppDocOtherInfo); } } #endregion #region tính phí // xóa đi AppFeeFixBL _AppFeeFixBL = new AppFeeFixBL(); _AppFeeFixBL.AppFeeFixDelete(pInfo.Case_Code, language); List<AppFeeFixInfo> _lstFeeFix = Call_Fee.CallFee_C07(pDetail, pAppClassInfo); if (_lstFeeFix.Count > 0) { pReturn = _AppFeeFixBL.AppFeeFixInsertBath(_lstFeeFix, p_case_code); if (pReturn < 0) goto Commit_Transaction; } #endregion #region Tai lieu dinh kem if (pReturn >= 0 && pAppDocumentInfo != null && 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) { info.App_Header_Id = pDetail.App_Header_Id; if (SessionData.CurrentUser.chashFile.ContainsKey(info.keyFileUpload)) { var _updateitem = SessionData.CurrentUser.chashFile[info.keyFileUpload]; if (_updateitem.GetType() == typeof(string)) { string _url = (string)_updateitem; 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 = pAppHeaderID; info.Document_Filing_Date = CommonFuc.CurrentDate(); info.Language_Code = language; } pReturn = objDoc.AppDocumentInsertBath(pAppDocumentInfo, pAppHeaderID); } #endregion //end Commit_Transaction: if (pReturn < 0) { Transaction.Current.Rollback(); return Json(new { status = -1 }); } else { scope.Complete(); } } return Json(new { status = pAppHeaderID }); } catch (Exception ex) { Logger.LogException(ex); return Json(new { status = ErrorCode.Error }); } }
public ActionResult ExportData_IU(ApplicationHeaderInfo pInfo, App_Detail_PLB01_SDD_Info pDetail, List <AppDocumentInfo> pAppDocumentInfo, List <AppFeeFixInfo> pFeeFixInfo) { try { string language = AppsCommon.GetCurrentLang(); //string language = pInfo.View_Language_Report; string _fileTemp = System.Web.HttpContext.Current.Server.MapPath("/Content/AppForms/B01_VI.docx"); DocumentModel document = DocumentModel.Load(_fileTemp); // Fill export_header AppsCommon.Prepare_Data_Export_3B(ref pDetail, pInfo, pAppDocumentInfo); List <App_Detail_PLB01_SDD_Info> _lst = new List <App_Detail_PLB01_SDD_Info>(); _lst.Add(pDetail); DataSet _ds_all = ConvertData.ConvertToDataSet <App_Detail_PLB01_SDD_Info>(_lst, false); //_ds_all.Tables[0].TableName = "Table"; //_ds_all.WriteXml(@"C:\inetpub\B01.xml", XmlWriteMode.WriteSchema); CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); string _tempfile = "TM_PLB01SDD.rpt"; string _datetimenow = DateTime.Now.ToString("ddMMyyyyHHmm"); string fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "B01_VN_" + _datetimenow + ".pdf"); if (language == Language.LangVI) { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "B01_VN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "B01_VN_" + _datetimenow + ".pdf"; } else { _tempfile = "TM_PLB01SDD_EN.rpt"; // tiếng anh fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "B01_EN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "B01_EN_" + _datetimenow + ".pdf"; } oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), _tempfile)); if (_ds_all != null) { _ds_all.Tables[0].TableName = "Table"; oRpt.Database.Tables["Table"].SetDataSource(_ds_all.Tables[0]); //oRpt.SetDataSource(_ds_all); } oRpt.Refresh(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); System.IO.Stream oStream = oRpt.ExportToStream(ExportFormatType.PortableDocFormat); byte[] byteArray = new byte[oStream.Length]; oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1)); System.IO.File.WriteAllBytes(fileName_pdf, byteArray.ToArray()); // Requires System.Linq return(Json(new { success = 0 })); } catch (Exception ex) { Logger.LogException(ex); return(Json(new { success = 0 })); } }
public ActionResult Register_C01(ApplicationHeaderInfo pInfo, App_Detail_C01_Info pDetail, List <AppDocumentInfo> pAppDocumentInfo, List <AppFeeFixInfo> pFeeFixInfo, List <AppDocumentOthersInfo> pAppDocOtherInfo, List <AppDocumentOthersInfo> pLstImagePublic) { try { Application_Header_BL objBL = new Application_Header_BL(); AppFeeFixBL objFeeFixBL = new AppFeeFixBL(); App_Detail_C01_BL objDetail = new App_Detail_C01_BL(); AppDocumentBL objDoc = new AppDocumentBL(); 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; int pAppHeaderID = 0; string p_case_code = ""; 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; pInfo.Send_Date = DateTime.Now; //TRA RA ID CUA BANG KHI INSERT pAppHeaderID = objBL.AppHeaderInsert(pInfo, ref p_case_code); if (pAppHeaderID < 0) { goto Commit_Transaction; } // detail if (pAppHeaderID >= 0) { pDetail.Appcode = pInfo.Appcode; pDetail.Language_Code = language; pDetail.App_Header_Id = pAppHeaderID; pDetail.Case_Code = p_case_code; pReturn = objDetail.Insert(pDetail); if (pReturn <= 0) { goto Commit_Transaction; } } //tai lieu khac if (pReturn >= 0 && pAppDocOtherInfo != null) { if (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; } info.App_Header_Id = pAppHeaderID; info.Language_Code = language; } if (check == 1) { pReturn = objDoc.AppDocumentOtherInsertBatch(pAppDocOtherInfo); } } } #region hình công bố if (pReturn >= 0 && pLstImagePublic != null) { if (pLstImagePublic.Count > 0) { int check = 0; foreach (var info in pLstImagePublic) { if (SessionData.CurrentUser.chashFile.ContainsKey(info.keyFileUpload)) { string _url = (string)SessionData.CurrentUser.chashFile[info.keyFileUpload]; info.Filename = _url; check = 1; } info.App_Header_Id = pAppHeaderID; info.Language_Code = language; } if (check == 1) { AppImageBL _AppImageBL = new AppImageBL(); pReturn = _AppImageBL.AppImageInsertBatch(pLstImagePublic); } } } #endregion #region Phí cố định List <AppFeeFixInfo> _lstFeeFix = Call_Fee.CallFee_C01(pDetail, pAppDocumentInfo, pLstImagePublic); if (_lstFeeFix.Count > 0) { AppFeeFixBL _AppFeeFixBL = new AppFeeFixBL(); pReturn = _AppFeeFixBL.AppFeeFixInsertBath(_lstFeeFix, p_case_code); if (pReturn < 0) { goto Commit_Transaction; } } #endregion //tai lieu khac if (pReturn >= 0 && pAppDocOtherInfo != null) { if (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; } info.App_Header_Id = pAppHeaderID; info.Language_Code = language; } if (check == 1) { pReturn = objDoc.AppDocumentOtherInsertBatch(pAppDocOtherInfo); } } } #region 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); } } #endregion //end Commit_Transaction: if (pReturn < 0) { Transaction.Current.Rollback(); } else { scope.Complete(); } } return(Json(new { status = pReturn })); } catch (Exception ex) { Logger.LogException(ex); return(Json(new { status = ErrorCode.Error })); } }
public ActionResult Edit_C01(ApplicationHeaderInfo pInfo, App_Detail_C01_Info pDetail, List <AppDocumentInfo> pAppDocumentInfo, List <AppFeeFixInfo> pFeeFixInfo, List <AppDocumentOthersInfo> pAppDocOtherInfo, List <AppDocumentOthersInfo> pLstImagePublic) { try { Application_Header_BL objBL = new Application_Header_BL(); AppFeeFixBL objFeeFixBL = new AppFeeFixBL(); App_Detail_C01_BL objDetail = new App_Detail_C01_BL(); AppDocumentBL objDoc = new AppDocumentBL(); 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; bool _IsOk = false; using (var scope = new TransactionScope()) { // pInfo.Languague_Code = language; pInfo.Modify_By = CreatedBy; pInfo.Modify_Date = CreatedDate; pInfo.Send_Date = DateTime.Now; pInfo.DDSHCN = ""; pInfo.MADDSHCN = ""; //TRA RA ID CUA BANG KHI INSERT pReturn = objBL.AppHeaderUpdate(pInfo); if (pReturn < 0) { goto Commit_Transaction; } // detail if (pReturn >= 0) { pDetail.Appcode = pInfo.Appcode; pDetail.Language_Code = language; pDetail.App_Header_Id = pInfo.Id; pDetail.Case_Code = pInfo.Case_Code; pReturn = objDetail.Update(pDetail); if (pReturn <= 0) { goto Commit_Transaction; } } #region hình công bố if (pReturn >= 0 && pLstImagePublic != null) { if (pLstImagePublic.Count > 0) { AppImageBL _AppImageBL = new AppImageBL(); List <AppDocumentOthersInfo> Lst_ImagePublic_Old = _AppImageBL.GetByAppHeader(pInfo.Id, language); Dictionary <decimal, AppDocumentOthersInfo> _dic_image = new Dictionary <decimal, AppDocumentOthersInfo>(); foreach (AppDocumentOthersInfo item in Lst_ImagePublic_Old) { _dic_image[item.Id] = item; } // xóa đi trước insert lại sau _AppImageBL.AppImageDeletedByApp(pInfo.Id, language); int check = 0; foreach (AppDocumentOthersInfo info in pLstImagePublic) { if (SessionData.CurrentUser.chashFile.ContainsKey(info.keyFileUpload)) { string _url = (string)SessionData.CurrentUser.chashFile[info.keyFileUpload]; info.Filename = _url; check = 1; } else if (_dic_image.ContainsKey(info.Id)) { info.Filename = _dic_image[info.Id].Filename; check = 1; } info.App_Header_Id = pInfo.Id; info.Language_Code = language; } if (check == 1) { pReturn = _AppImageBL.AppImageInsertBatch(pLstImagePublic); } } } #endregion #region Phí cố định // xóa đi AppFeeFixBL _AppFeeFixBL = new AppFeeFixBL(); _AppFeeFixBL.AppFeeFixDelete(pDetail.Case_Code, language); // insert lại fee List <AppFeeFixInfo> _lstFeeFix = Call_Fee.CallFee_C01(pDetail, pAppDocumentInfo, pLstImagePublic); if (_lstFeeFix.Count > 0) { pReturn = _AppFeeFixBL.AppFeeFixInsertBath(_lstFeeFix, pInfo.Case_Code); if (pReturn < 0) { goto Commit_Transaction; } } #endregion //tai lieu khac if (pReturn >= 0 && pAppDocOtherInfo != null) { List <AppDocumentOthersInfo> Lst_Doc_Others_Old = objDoc.DocumentOthers_GetByAppHeader(pInfo.Id, language); 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(pInfo.Id, language); if (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); } } } #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 = _AppDocumentBL.AppDocumentInsertBath(pAppDocumentInfo, pInfo.Id); } } #endregion //end Commit_Transaction: if (pReturn < 0) { Transaction.Current.Rollback(); return(Json(new { status = pReturn })); } else { scope.Complete(); _IsOk = true; } } // tự động update todo if (pInfo.UpdateToDo == 1 && _IsOk == true) { if (pInfo.Status == (int)CommonEnums.App_Status.ChoKHConfirm) { Application_Header_BL _obj_bl = new Application_Header_BL(); decimal _status = (decimal)CommonEnums.App_Status.KhacHangDaConfirm; string _note = "Xác nhận nộp đơn"; if (AppsCommon.GetCurrentLang() != "VI_VN") { _note = "confirmation for filing"; } int _ck = _obj_bl.AppHeader_Update_Status(pInfo.Case_Code, _status, _note, SessionData.CurrentUser.Username, DateTime.Now, AppsCommon.GetCurrentLang()); } } return(Json(new { status = pInfo.Id })); } 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 })); } }
public ActionResult ExportData_View(decimal pAppHeaderId, string p_appCode, decimal p_View_Translate) { try { string language = AppsCommon.GetCurrentLang(); App_Detail_C01_BL objBL = new App_Detail_C01_BL(); ApplicationHeaderInfo applicationHeaderInfo = new ApplicationHeaderInfo(); App_Detail_C01_Info app_Detail = new App_Detail_C01_Info(); List <AppFeeFixInfo> appFeeFixInfos = new List <AppFeeFixInfo>(); List <AppDocumentInfo> appDocumentInfos = new List <AppDocumentInfo>(); List <AppDocumentOthersInfo> _LstDocumentOthersInfo = new List <AppDocumentOthersInfo>(); List <AppDocumentOthersInfo> pLstImagePublic = new List <AppDocumentOthersInfo>(); app_Detail = objBL.GetByID(pAppHeaderId, language, ref applicationHeaderInfo, ref appDocumentInfos, ref appFeeFixInfos, ref _LstDocumentOthersInfo, ref pLstImagePublic); AppsCommon.Prepare_Data_Export_C01(ref app_Detail, applicationHeaderInfo, appDocumentInfos, pLstImagePublic); if (_LstDocumentOthersInfo != null) { foreach (var item in _LstDocumentOthersInfo) { app_Detail.Note += item.Documentname + " ; "; } if (_LstDocumentOthersInfo.Count > 0) { app_Detail.Note = app_Detail.Note.Substring(0, app_Detail.Note.Length - 2); } } List <App_Detail_C01_Info> _lst = new List <App_Detail_C01_Info>(); _lst.Add(app_Detail); DataSet _ds_all = ConvertData.ConvertToDataSet <App_Detail_C01_Info>(_lst, false); CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); string _datetimenow = DateTime.Now.ToString("ddMMyyyyHHmm"); string _tempfile = "C01.rpt"; string fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C01_VN_" + _datetimenow + ".pdf"); if (p_View_Translate == 1) { // nếu là tiếng việt thì xem bản tiếng anh và ngược lại if (applicationHeaderInfo.Languague_Code == Language.LangVI) { _tempfile = "C01_EN.rpt"; // tiếng anh fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C01_EN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "C01_EN_" + _datetimenow + ".pdf"; } else { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C01_VN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "C01_VN_" + _datetimenow + ".pdf"; } } else { if (applicationHeaderInfo.Languague_Code == Language.LangVI) { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C01_VN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "C01_VN_" + _datetimenow + ".pdf"; } else { _tempfile = "C01_EN.rpt"; // tiếng anh fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C01_EN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "C01_EN_" + _datetimenow + ".pdf"; } } oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), _tempfile)); if (_ds_all != null) { _ds_all.Tables[0].TableName = "Table"; //_ds_all.WriteXml(@"C:\inetpub\C01.xml", XmlWriteMode.WriteSchema); // đè các bản dịch lên if (p_View_Translate == 1) { // nếu là bản xem của thằng dịch App_Translate_BL _App_Translate_BL = new App_Translate_BL(); List <App_Translate_Info> _lst_translate = _App_Translate_BL.App_Translate_GetBy_AppId(pAppHeaderId); AppsCommon.Overwrite_DataSouce_Export(ref _ds_all, _lst_translate); } oRpt.SetDataSource(_ds_all); } oRpt.Refresh(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); System.IO.Stream oStream = oRpt.ExportToStream(ExportFormatType.PortableDocFormat); byte[] byteArray = new byte[oStream.Length]; oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1)); System.IO.File.WriteAllBytes(fileName_pdf, byteArray.ToArray()); // Requires System.Linq return(Json(new { success = 0 })); } catch (Exception ex) { Logger.LogException(ex); return(Json(new { success = 0 })); } }
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 ExportData_View_IU(ApplicationHeaderInfo pInfo, App_Detail_C01_Info pDetail, List <AppDocumentInfo> pAppDocumentInfo, List <AppFeeFixInfo> pFeeFixInfo, List <AppDocumentOthersInfo> pAppDocOtherInfo, List <AppDocumentOthersInfo> pLstImagePublic) { try { string _datetimenow = DateTime.Now.ToString("ddMMyyyyHHmm"); string language = AppsCommon.GetCurrentLang(); List <App_Detail_C01_Info> _lst = new List <App_Detail_C01_Info>(); string fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C01_VN_" + _datetimenow + ".pdf"); if (language == Language.LangVI) { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C01_VN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "C01_VN_" + _datetimenow + ".pdf"; } else { fileName_pdf = System.Web.HttpContext.Current.Server.MapPath("/Content/Export/" + "C01_EN_" + _datetimenow + ".pdf"); SessionData.CurrentUser.FilePreview = "/Content/Export/" + "C01_EN_" + _datetimenow + ".pdf"; } AppsCommon.Prepare_Data_Export_C01(ref pDetail, pInfo, pAppDocumentInfo, pLstImagePublic); if (pAppDocOtherInfo != null) { foreach (var item in pAppDocOtherInfo) { pDetail.Note += item.Documentname + " ; "; } if (pAppDocOtherInfo.Count > 0) { pDetail.Note = pDetail.Note.Substring(0, pDetail.Note.Length - 2); } } _lst.Add(pDetail); DataSet _ds_all = ConvertData.ConvertToDataSet <App_Detail_C01_Info>(_lst, false); //_ds_all.WriteXml(@"C:\inetpub\A01.xml", XmlWriteMode.WriteSchema); CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); string _tempfile = "C01.rpt"; if (language == Language.LangEN) { _tempfile = "C01_EN.rpt"; } oRpt.Load(Path.Combine(Server.MapPath("~/Report/"), _tempfile)); if (_ds_all != null) { _ds_all.Tables[0].TableName = "Table"; oRpt.SetDataSource(_ds_all); } oRpt.Refresh(); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); //oRpt.ExportToDisk(ExportFormatType.PortableDocFormat, fileName_pdf); System.IO.Stream oStream = oRpt.ExportToStream(ExportFormatType.PortableDocFormat); byte[] byteArray = new byte[oStream.Length]; oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1)); System.IO.File.WriteAllBytes(fileName_pdf, byteArray.ToArray()); // Requires System.Linq return(Json(new { success = 0 })); } catch (Exception ex) { Logger.LogException(ex); return(Json(new { success = 0 })); } }
public ActionResult Translate_PLB_01_SDD(ApplicationHeaderInfo pInfo, App_Detail_PLB01_SDD_Info pDetail, List <AppDocumentInfo> pAppDocumentInfo, List <AppFeeFixInfo> pFeeFixInfo) { try { Application_Header_BL objBL = new Application_Header_BL(); AppFeeFixBL objFeeFixBL = new AppFeeFixBL(); App_Detail_PLB01_SDD_BL objDetail = new App_Detail_PLB01_SDD_BL(); AppDocumentBL objDoc = new AppDocumentBL(); 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; decimal pReturn = ErrorCode.Success; int pAppHeaderID = 0; string prefCaseCode = ""; decimal pIDHeaderRootLang = pInfo.Id; 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; pInfo.Send_Date = DateTime.Now; //pInfo.Status = (decimal)CommonEnums.App_Status.DaGui_ChoPhanLoai; //TRA RA ID CUA BANG KHI INSERT //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); } if (pAppHeaderID < 0) { goto Commit_Transaction; } // detail if (pAppHeaderID >= 0) { pDetail.Appcode = pInfo.Appcode; pDetail.Language_Code = language; pDetail.App_Header_Id = pAppHeaderID; pDetail.Case_Code = prefCaseCode; pReturn = objDetail.Insert(pDetail); if (pReturn <= 0) { goto Commit_Transaction; } } #region Phí cố định // xóa đi AppFeeFixBL _AppFeeFixBL = new AppFeeFixBL(); _AppFeeFixBL.AppFeeFixDelete(prefCaseCode, language); // insert lại fee List <AppFeeFixInfo> _lstFeeFix = Call_Fee.CallFee_3B(pDetail); if (_lstFeeFix.Count > 0) { pReturn = _AppFeeFixBL.AppFeeFixInsertBath(_lstFeeFix, prefCaseCode); if (pReturn < 0) { goto Commit_Transaction; } } #endregion #region Tai lieu dinh kem if (pReturn >= 0 && pAppDocumentInfo != null) { if (pAppDocumentInfo.Count > 0) { pReturn = objDoc.AppDocumentTranslate(language, pIDHeaderRootLang, pAppHeaderID); } } #endregion //end Commit_Transaction: 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 })); } }