/// <summary> /// 开启服务 /// </summary> /// <param name="appPath">程序路径</param> public static void StartService() { m_staffService = new StaffService(); m_awardService = new AwardService(); m_bsStockService = new BSStockService(); m_businessCardService = new BusinessCardService(); m_calendarService = new CalendarService(); m_clueService = new ClueService(); m_dialogService = new DialogService(); m_dimensionService = new DimensionService(); m_exportService = new ExportService(); m_followService = new FollowService(); m_gitService = new GitService(); m_jidianService = new JidianService(); m_levelService = new LevelService(); m_masterService = new MasterService(); m_opinionService = new OpinionService(); m_personalService = new PersonalService(); m_projectService = new ProjectService(); m_remoteService = new RemoteService(); m_examService = new ExamService(); m_securityService = new SecurityService(); m_serverService = new ServerService(); SecurityService.Start(); }
private async void Export() { // #TODO: Make this a proper service, not the crap that it used to be try { bool success = await ExportService.ExportTextToSpeechFile(Text, SelectedVoice.Voice); if (success == true) { // Show UX message telling exporting was successful // #TODO Replace this with better UX MessageService.ShowExportSuccessfulMessage(); } else { // Show UX message telling exporting failed // #TODO Replace this with better UX MessageService.ShowExportFailedMessage(); } } catch (Exception ex) { Debug.WriteLine("MainViewModel - Export - Failed - " + ex); // Show UX message telling exporting failed // #TODO Replace this with better UX MessageService.ShowExportFailedMessage(); } }
public void ExportToPortableObjectReturnsNullNoUser() { //Arrage var loggerMock = new Mock <ILoggerFactory>(); var userRepoMock = new Mock <IUserRepository>(); var workoutRepoMock = new Mock <IWorkoutRepository>(); var exerciseRepoMock = new Mock <IExerciseRepository>(); var mapperMock = new Mock <IMapper>(); var fileProviderMock = new Mock <IFIleProvider <PortableUserDto> >(); var logger = new Mock <ILogger>(); loggerMock.Setup(l => l.CreateLogger(It.IsAny <string>())).Returns(logger.Object); userRepoMock.Setup(r => r.FindAsync(It.IsAny <int>())).ReturnsAsync((User)null); var SUT = new ExportService(loggerMock.Object, userRepoMock.Object, mapperMock.Object, fileProviderMock.Object, workoutRepoMock.Object, exerciseRepoMock.Object); var userid = Guid.NewGuid(); //Act var result = SUT.ExportToPortableObjectAsync(userid).Result; Assert.Null(result); }
public ActionResult <string> Get(int id) { var invocing = new ExportService(); invocing.ExportInvoice(null, null); return("value"); }
public ActionResult Index() { ExportService <Feature> exportService = new ExportService <Feature>(); ViewBag.ExportColumns = exportService.GetSelectList(); return(View(featRepo.GetAll().ToList())); }
public async Task ExportControllerTest__ThumbFalse_AddXmpFile_CreateListToExport() { var storage = new FakeIStorage(new List <string> { "/" }, new List <string> { _appSettings.DatabasePathToFilePath("/test.dng", false), _appSettings.DatabasePathToFilePath("/test.xmp", false), "/test.dng", "/test.xmp" }); var selectorStorage = new FakeSelectorStorage(storage); var fileIndexResultsList = new List <FileIndexItem> { new FileIndexItem { FileName = "test.dng", ParentDirectory = "/", FileHash = "FileHash", Status = FileIndexItem.ExifStatus.Ok } }; var fakeQuery = new FakeIQuery(fileIndexResultsList); var export = new ExportService(fakeQuery, _appSettings, selectorStorage, new FakeIWebLogger()); var filePaths = await export.CreateListToExport(fileIndexResultsList, false); Assert.AreEqual(true, filePaths[0].Contains("test.dng")); Assert.AreEqual(true, filePaths[1].Contains("test.xmp")); }
static void Main(string[] args) { if (!new CliParser().Parse(args, out var product, out var license)) { return; } var exportService = new ExportService(); try { Console.WriteLine(exportService.Export(product, license)); } catch (Exception e) { if (e is System.Security.Cryptography.CryptographicException) { Console.WriteLine("The key is not complete\n" + "\tMaybe the public key was provided!"); } else if (e is System.Xml.XmlException) { Console.WriteLine("The key is not a valid RSA xml key!"); } else { Console.WriteLine($"Unknown error\nError message:\n{e.Message}"); } } }
public void ExportControllerTest__ThumbTrue__FilePathToFileName() { var storage = new StorageSubPathFilesystem(_appSettings, new FakeIWebLogger()); var selectorStorage = new FakeSelectorStorage(storage); var export = new ExportService(_query, _appSettings, selectorStorage, new FakeIWebLogger()); var filePaths = new List <string> { Path.Combine("test", "thumb.jpg") }; _query.AddItem(new FileIndexItem { FileName = "file.jpg", ParentDirectory = "/test", FileHash = "thumb" }); var fileNames = export.FilePathToFileName(filePaths, true); Assert.AreEqual("file.jpg", fileNames.FirstOrDefault()); // This is a strange one: // We use thumb as base32 fileHashes but export // as file.jpg or the nice original name }
public async Task ExportControllerTest__ThumbFalse_CreateListToExport() { var selectorStorage = _serviceProvider.GetRequiredService <ISelectorStorage>(); var hostFileSystemStorage = selectorStorage.Get(SelectorStorage.StorageServices .HostFilesystem); var export = new ExportService(_query, _appSettings, selectorStorage, new FakeIWebLogger()); var createAnImageNoExif = new CreateAnImageNoExif(); var item = new FileIndexItem { FileName = createAnImageNoExif.FileName, ParentDirectory = "/", FileHash = createAnImageNoExif.FileName.Replace(".jpg", "-test"), Status = FileIndexItem.ExifStatus.Ok }; await _query.AddItemAsync(item); var fileIndexResultsList = new List <FileIndexItem> { item }; var filePaths = await export.CreateListToExport(fileIndexResultsList, false); Assert.AreEqual(true, filePaths.FirstOrDefault().Contains(item.FileName)); Assert.AreEqual(FolderOrFileModel.FolderOrFileTypeList.File, hostFileSystemStorage.IsFolderOrFile(filePaths.FirstOrDefault())); hostFileSystemStorage.FileDelete(createAnImageNoExif.FullFilePathWithDate); }
private void ExecuteExportListCmd(object obj) { DataGrid d = (DataGrid)obj; List <ExportMeta> l = new List <ExportMeta>(); if (d.SelectedItems == null || d.SelectedItems.Count == 0) { MessageBox.Show("您还未选择导出任务"); return; } foreach (var item in d.SelectedItems) { l.Add(item as ExportMeta); } foreach (var item in l) { Debug.WriteLine("选择任务:{0},任务编号:{1}", item.TaskCode, item.VideoId); } Debug.WriteLine("输出位置:{0}", TargetSource); //send Message //按钮禁止点击 //显示进度条 Messenger.Default.Send("exportIsRunning", "EVM2EV"); //load metadata abnormaldata abnormaltype from database exportDatas = ExportService.GetService().GetExportListData(l); typeDict = AbnormalService.GetService().GetAbnormalTypeModelsToDict(); worker.RunWorkerAsync(); }
public void ShareOnFacebook(InkCanvas canvas) { Canvas = canvas; var imageStream = new MemoryStream(); ExportService.ExportWithoutSaving(canvas, ImageFormat.Jpeg, imageStream); if (string.IsNullOrWhiteSpace(AuthService.FacebookAccessToken)) { if (BrowserWindow?.IsVisible ?? false) { return; } BrowserWindow = new BrowserView(FacebookAPI.FacebookAuthenticationUri); BrowserWindow.FacebookConnected += (s, e) => { var args = e as ConnectedEventArgs; AuthService.FacebookAccessToken = args.ConnectionToken; BrowserWindow.Close(); GetFacebookCaption(imageStream); }; BrowserWindow.Show(); return; } GetFacebookCaption(imageStream); }
protected async Task ExportChannelAsync(IConsole console, Channel channel) { // Configure settings if (!string.IsNullOrWhiteSpace(DateFormat)) { SettingsService.DateFormat = DateFormat !; } console.Output.Write($"Exporting channel [{channel.Name}]... "); var progress = console.CreateProgressTicker(); // Get chat log var chatLog = await DataService.GetChatLogAsync(GetToken(), channel, After, Before, progress); // Generate file path if not set or is a directory var filePath = OutputPath; if (string.IsNullOrWhiteSpace(filePath) || ExportHelper.IsDirectoryPath(filePath)) { // Generate default file name var fileName = ExportHelper.GetDefaultExportFileName(ExportFormat, chatLog.Guild, chatLog.Channel, After, Before); // Combine paths filePath = Path.Combine(filePath ?? "", fileName); } // Export await ExportService.ExportChatLogAsync(chatLog, filePath, ExportFormat, PartitionLimit); console.Output.WriteLine(); }
// This method gets called by the runtime. Use this method to add services to the container. // For more information on how to configure your application, visit https://go.microsoft.com/fwlink/?LinkID=398940 public void ConfigureServices(IServiceCollection services) { var exportService = new ExportService(new ExportService.Config { ReadyDirectory = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), ApplicationRomingFolderName, "exportReady"), WorkingDirectory = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), ApplicationRomingFolderName, "exportPrepare"), }); var persistenceFacade = new PersistenceFacade(persistenceConfig); var dbTemplateService = new DBTemplateService(persistenceFacade); services.AddRazorPages(); services.AddServerSideBlazor(); services.AddMvc().SetCompatibilityVersion(Microsoft.AspNetCore.Mvc.CompatibilityVersion.Version_3_0); services.AddSingleton <DBTemplateService>(dbTemplateService); services.AddSingleton <ExportService>(exportService); services.AddSingleton <ExportController>(new ExportController(dbTemplateService, exportService)); services.AddSingleton <PersistenceFacade>(persistenceFacade); services.AddSingleton <DatabaseModelImportService>(new DatabaseModelImportService(new ImporterProxy(), persistenceFacade)); services.AddLogging(); }
public void ExportGrid(ExportType fileType) { switch (fileType) { case ExportType.XLSX: SaveFileDialogService.DefaultExt = "xlsx"; SaveFileDialogService.Filter = "Excel 2007+|*.xlsx"; break; case ExportType.PDF: SaveFileDialogService.DefaultExt = "pdf"; SaveFileDialogService.Filter = "PDF|*.pdf"; break; } if (SaveFileDialogService.ShowDialog()) { var fileName = SaveFileDialogService.GetFullFileName(); ExportService.ExportTo(fileType, fileName); if (MessageBoxService.ShowMessage("Would you like to open the file?", "Export finished", MessageButton.YesNo) == MessageResult.Yes) { Process.Start(fileName); } } }
public void Exports_With_User_Defined_KeyValues_When_Available() { var service = new ExportService() as IExportService; var product = new Product { Id = Guid.NewGuid(), Name = "My Product", }; var license = new License { LicenseType = LicenseType.Standard, OwnerName = "License Owner", ExpirationDate = null, }; license.Data.Add(new UserData { Key = "KeyOne", Value = "ValueOne" }); license.Data.Add(new UserData { Key = "KeyTwo", Value = "ValueTwo" }); var path = Path.GetTempFileName(); var file = new FileInfo(path); service.Export(product, license, file); var reader = file.OpenText(); var content = reader.ReadToEnd(); Assert.NotNull(content); Assert.Contains("KeyOne=\"ValueOne\"", content); Assert.Contains("KeyTwo=\"ValueTwo\"", content); }
public ActionResult ExportQuery(string databaseName, string query, string languages, bool includeStandardFields) { VerifyImportExportPermissions(); Assert.IsNotNullOrEmpty(databaseName, "databaseName was not provided"); Assert.IsNotNullOrEmpty(query, "query was not provided"); try { var database = Sitecore.Data.Database.GetDatabase(databaseName); DataTable dataTable; if (string.IsNullOrEmpty(languages)) { languages = Sitecore.Context.Language.Name; } var parsedLanguages = ParseLanguages(languages); var exportService = new ExportService(database, parsedLanguages, includeStandardFields); dataTable = exportService.RetrieveItemsByQuery(query); WriteCsvToStream(Response.OutputStream, dataTable); } catch (Exception ex) { Sitecore.Diagnostics.Log.Error("Failure while exporting from BulkManager", ex); return(Content(ex.Message)); } return(Content("")); }
public App() { var waypointsService = new WaypointsService(); var groupsService = new GroupsService(waypointsService); GeoLayoutBuildingService = new GeoLayoutBuildingService(waypointsService, groupsService); SettingsService = new SettingsService(); var importService = new ImportService( new List <IGeoImporter>(new [] { new GpxImporter() }), new MultiFileDialogService(Current.MainWindow), waypointsService); var exportService = new ExportService( new List <IGeoExporter>(new [] { new GpxExporter() }), new SaveFileDialogService(Current.MainWindow), waypointsService); MainViewModel = new MainViewModel(importService, exportService, waypointsService, groupsService, GeoLayoutBuildingService); MapViewModel = new MapViewModel(waypointsService, groupsService, GeoLayoutBuildingService); GroupsViewModel = new GroupsViewModel(groupsService, waypointsService); }
public HttpResponseMessage Export() { var response = new HttpResponseMessage(HttpStatusCode.OK); List <ProductDTO> products = _unitOfWork.ProductRepository .Get() .Select(p => new ProductDTO() { ID = p.ID, Name = p.Name, Description = p.Description, PurchasePrice = p.PurchasePrice, SalesPrice = p.SalesPrice, SpoilDate = p.SpoilDate, UnitsAvailable = p.UnitsAvailable }).ToList(); MediaTypeHeaderValue mediaType = new MediaTypeHeaderValue("application/octet-stream"); MemoryStream memoryStream = new MemoryStream(ExportService.ExcelReport(products)); response.Content = new StreamContent(memoryStream); response.Content.Headers.ContentType = mediaType; response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("fileName") { FileName = "myReport.xls" }; return(response); }
public ActionResult Index() { ExportService <Member> exportService = new ExportService <Member>(); ViewBag.ExportColumns = exportService.GetSelectList(); return(View(memberRepo.GetAll().ToList())); }
static void Main(string[] args) { AskInformation(ref appId, "Please provide your application id or EXIT:"); AskInformation(ref appKey, "Please provide your application key or EXIT:"); AskInformation(ref appVersion, "Please provide your app version or EXIT:"); AskInformation(ref filePath, "Please provide your csv file path or EXIT:"); var exportService = new ExportService(appId, appKey, appVersion); var data = exportService.Export().Result; var sb = new StringBuilder(); sb.AppendLine("intent;utterance"); data.ForEach(item => { sb.AppendLine($"{item.Item1};{item.Item2}".Replace("\n", "")); }); using (var writer = new StreamWriter(filePath, false, Encoding.UTF8)) { writer.Write(sb.ToString()); } System.Console.WriteLine($"{data.Count} lines wrote in {filePath}"); System.Console.ReadLine(); }
/// <summary> /// 启动服务 /// </summary> /// <param name="fileName">文件名</param> public static void startService() { readPlots(); m_userCookieService = new UserCookieService(); m_exportService = new ExportService(); m_userSecurityService = new UserSecurityService(); SecurityService.start(); }
public JsonResult Export(Guid id) { var service = new ExportService(Db); var prog = service.GetProgram(id, 33); return(Json(prog, JsonRequestBehavior.AllowGet)); }
public ChamadosController(RelProdContext context, UsuarioServices usuarioService, BuscaService buscaService, ExportService exportService, ChamadoService chamadoService) { _context = context; _usuarioServices = usuarioService; _buscaService = buscaService; _exportService = exportService; _ChamadoService = chamadoService; }
private async void cbtnExport_Click(object sender, RoutedEventArgs e) { ExportService exportHelper = new ExportService(); var cbItem = (ComboBoxItem)cboxVoices.SelectedItem; var voice = (VoiceInformation)cbItem.Tag; await exportHelper.ExportSpeechToFile(txtTextToSay.Text, voice); }
public PowerBiController(EmbedService embedService, ExportService exportService, IMemoryCache cache, ILogger<PowerBiController> logger) { this.embedService = embedService; this.exportService = exportService; // Get service cache this.cache = cache; this.logger = logger; }
public void TestGetZipFileString() { var exportDeviceName = "testDevice"; var exportDeviceBayId = "testBayId"; var exportDateTime = new DateTime(2018, 5, 25, 14, 30, 46); Assert.Equal($"20180525,143046000,{exportDeviceBayId},{exportDeviceName}.zip", ExportService.GetZipFileName(exportDeviceName, exportDeviceBayId, exportDateTime)); }
void SetDefaultReport(IReportInfo reportInfo) { if (this.IsInDesignMode()) { return; } ExportService.SetDefaultReport(reportInfo); PrintService.SetDefaultReport(reportInfo); }
public ProductionDataController(IContext context, IHostingEnvironment hostingEnvironment) { _context = context; productionDataService = new ProductionDataService(_context); bulkInsertService = new BulkInsertService(_context); exportService = new ExportService(_context); loginService = new LoginService(_context); _hostingEnvironment = hostingEnvironment; }
void OnStartExport() { var scs = CheckSqlServerConnection("Source", _sourceServer, _sourceDatabase, _sourceUserName, GetPassword(true), false); if (string.IsNullOrEmpty(scs)) { return; } var dcs = CheckSqlServerConnection("Destination", _destinationServer, _destinationDatabase, _destinationUserName, GetPassword(false), false); if (string.IsNullOrEmpty(dcs)) { return; } if (_task != null && (_task.Status == TaskStatus.Running || _task.Status == TaskStatus.WaitingToRun || _task.Status == TaskStatus.WaitingForActivation)) { return; } if (_tokenSource != null) { _tokenSource.Dispose(); } _tokenSource = new CancellationTokenSource(); var token = _tokenSource.Token; _task = Task.Run(() => { ExportService es = new ExportService(scs, dcs, ListOfExported, token, TableName, LogInfo); es.Run(); }, token); /* * try * { * t.Wait(); * } * catch (AggregateException e) * { * var em = $"{e.Message} "; * foreach (var ie in e.InnerExceptions) * em = $" {em}{ie.GetType().Name},{ie.Message}"; * * ListOfExported.Add(WorkReader.CreateInfo("", 0, 0, em)); * } * finally * { * _tokenSource.Dispose(); * }*/ //_tokenSource.Dispose(); }
public void SetupDirectoriesAndFiles() { Directory.CreateDirectory("C:\\Temp\\UnitTestingOfPhilipp\\Repository\\2020"); ConfigurationManager.AppSettings.Set("RepositoryDir", "C:\\Temp\\UnitTestingOfPhilipp\\Repository"); var exportService = new ExportService(); exportService.CreateXml(new MetadataItem(Guid.Parse("3fc6a223-369b-4efd-a0c4-f563ee6d67f8"), "Username", "Dokumenten Bezeichnung", DateTime.Parse("01.01.2020 19:00:00"), "Verträge", "Notiz", DateTime.Parse("30.06.2020 00:00:00"), "document.docx")); }
/// <summary> /// SCORM Engine Service constructor that takes a single configuration parameter /// </summary> /// <param name="config">The Configuration object to be used to configure the Scorm Engine Service client</param> public ScormEngineService(Configuration config) { System.Net.ServicePointManager.Expect100Continue = false; configuration = config; courseService = new CourseService(configuration, this); dispatchService = new DispatchService(configuration, this); registrationService = new RegistrationService(configuration, this); invitationService = new InvitationService(configuration, this); uploadService = new UploadService(configuration, this); ftpService = new FtpService(configuration, this); exportService = new ExportService(configuration, this); reportingService = new ReportingService(configuration, this); debugService = new DebugService(configuration, this); }
public void TestAllExportsCompletedEventIsReported() { AutoResetEvent evt = new AutoResetEvent(false); bool _allExportsDone = false; IExportService es = new ExportService(Dispatcher.CurrentDispatcher); MemberListExport mle = new MemberListExport(); mle.Members = _handler.Database.MemberSet.AsEnumerable(); mle.OutputPath = _testOutputName; Assert.IsFalse(es.ExportInProgress); es.AllExportsCompleted += delegate { _allExportsDone = true; evt.Set(); }; es.QueueExportJob(mle); DispatcherUtil.DoEventsUntil(evt); Assert.IsTrue(_allExportsDone); }
public ActionResult ExportHistoryApproveECLAIMByTemplate([DataSourceRequest] DataSourceRequest request, FIN_HistoryApproveECLAIMSearchModel model) { string status = string.Empty; var baseService = new BaseService(); var isDataTable = false; object obj = new FIN_HistoryApproveECLAIMModel(); ListQueryModel lstModel = new ListQueryModel { PageSize = int.MaxValue - 1, PageIndex = 1, Filters = ExtractFilterAttributes(request), Sorts = ExtractSortAttributes(request), AdvanceFilters = ExtractAdvanceFilterAttributes(model) }; var result = baseService.GetData<FIN_HistoryApproveECLAIMModel>(lstModel, ConstantSql.hrm_hr_sp_get_HistoryApprovedClaim, UserLogin, ref status); if (model != null && model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = new FIN_HistoryApproveECLAIMModel(), FileName = "FIN_HistoryApproveECLAIM", OutPutPath = path, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (model.ExportId != Guid.Empty) { var fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public void TestQueueingSeveralExportsReportsOnlyOneExportCompleted() { AutoResetEvent evt = new AutoResetEvent(false); bool _allExportsDone = false; IExportService es = new ExportService(Dispatcher.CurrentDispatcher); IPdfExport export = new FakeExport(); export.OutputPath = _testOutputName; Assert.IsFalse(es.ExportInProgress); es.AllExportsCompleted += delegate { Assert.IsFalse(_allExportsDone); _allExportsDone = true; // this should be called only once evt.Set(); }; for (int i = 0; i < 15; ++i) es.QueueExportJob(export); DispatcherUtil.DoEventsUntil(evt, 8000); Assert.IsTrue(_allExportsDone); }
public ActionResult ExportPersionalInformation([DataSourceRequest] DataSourceRequest request, Hre_PersionalInfoSearchModel model) { var service = new Hre_ProfileServices(); ListQueryModel lstModel = new ListQueryModel { PageIndex = request.Page, PageSize = request.PageSize, Filters = ExtractFilterAttributes(request), Sorts = ExtractSortAttributes(request) }; var isDataTable = false; object obj = new DataTable(); var result = service.GetPersionalInfo(model.id, UserLogin, model.IsCreateTemplate); if (model.IsCreateTemplateForDynamicGrid) { obj = result; isDataTable = true; } if (model != null && model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = obj, FileName = "Hre_PersionalInformationModel", OutPutPath = path, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (model.ExportId != Guid.Empty) { var fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult GetDateEndAccidentTypeList([DataSourceRequest] DataSourceRequest request, Hre_AccidentModel model) { #region Validate string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Hre_AccidentModel>(model, "Hre_ReportAccident", ref message); if (!checkValidate) { return Json(message); } //DateTime From = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); //DateTime To = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).AddDays(-1); #endregion HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = model.DateFrom != null ? model.DateFrom.Value : DateTime.Now }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = model.DateTo != null ? model.DateTo.Value : DateTime.Now }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; var service = new ActionService(UserLogin); List<object> listObj = new List<object>(); DateTime? From = SqlDateTime.MinValue.Value; DateTime? To = SqlDateTime.MaxValue.Value; List<Guid?> OrgIds = new List<Guid?>(); if (model.DateFrom != null) { From = model.DateFrom.Value; } if (model.DateTo != null) { To = model.DateTo.Value; } listObj.Add(From); listObj.Add(To); string strOrgIDs = null; if (!string.IsNullOrEmpty(model.OrgStructureID)) { strOrgIDs = model.OrgStructureID; } listObj.Add(strOrgIDs); Guid? Acctype = Guid.Empty; if (model.AccidentTypeID != Guid.Empty) { Acctype = model.AccidentTypeID; } listObj.Add(Acctype); string status = string.Empty; var result = service.GetData<Hre_AccidentEntity>(listObj, ConstantSql.hrm_hr_sp_get_DateEndAccidentTypeList, ref status).ToList().Translate<Hre_AccidentModel>(); if (model != null && model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = new Hre_AccidentModel(), FileName = "Hre_ReportAccident", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = false }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(model.ExportID, result, listHeaderInfo, model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); //return GetListDataAndReturn<Hre_AccidentModel, Hre_AccidentEntity, Hre_ReportAccidentSearchModel>(request, model, ConstantSql.hrm_hr_sp_get_DateEndAccidentTypeList); }
public ActionResult GetReportBirthday([DataSourceRequest] DataSourceRequest request, Hre_ReportBirthdayModel Model) { HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateFrom != null ? Model.DateFrom.Value : DateTime.Now }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateTo != null ? Model.DateTo.Value : DateTime.Now }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; #region Tạo Template if (Model != null && Model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = new Hre_ReportBirthdayModel(), FileName = "Hre_ReportBirthday", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = false }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } #endregion #region Validate string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Hre_ReportBirthdayModel>(Model, "Hre_ReportBirthday", ref message); if (!checkValidate) { return Json(message); } #endregion var service = new Hre_ReportServices(); var actionServices = new ActionService(UserLogin); List<object> listObj = new List<object>(); List<Guid?> OrgIds = new List<Guid?>(); listObj.Add(Model.DateFrom); listObj.Add(Model.DateTo); listObj.Add(Model.OrgStructureID); listObj.Add(Model.DateQuitFrom); listObj.Add(Model.DateQuitTo); listObj.Add(Model.WorkPlaceID); string status = string.Empty; var result = actionServices.GetData<Hre_ReportBirthdayEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptBirthday, ref status).ToList().Translate<Hre_ReportBirthdayModel>(); if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult GetReportProfileDiscipline([DataSourceRequest] DataSourceRequest request, Hre_ReportProfileDisciplineModel Model) { #region Code cũ //var service = new Hre_ReportServices(); //var hrService = new Hre_ProfileServices(); //var isDataTable = false; //object obj = new Hre_ReportProfileDisciplineModel(); //List<object> listObj = new List<object>(); //DateTime From = SqlDateTime.MinValue.Value; //DateTime To = SqlDateTime.MaxValue.Value; //List<Guid?> OrgIds = new List<Guid?>(); //if (Model.DateFrom != null) //{ // From = Model.DateFrom.Value; // listObj.Add(From); //} //else //{ // listObj.Add(null); //} //if (Model.DateTo != null) //{ // To = Model.DateTo.Value; // listObj.Add(To); //} //else //{ // listObj.Add(null); //} //string strOrgIDs = null; //if (!string.IsNullOrEmpty(Model.OrgStructureID)) //{ // strOrgIDs = Model.OrgStructureID; //} //listObj.Add(strOrgIDs); //string status = string.Empty; //var result = hrService.GetData<Hre_ReportProfileDisciplineEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptDiscripline, ref status).ToList().Translate<Hre_ReportProfileDisciplineModel>(); //if (Model.IsCreateTemplateForDynamicGrid) //{ // obj = result; // isDataTable = true; //} //if (Model != null && Model.IsCreateTemplate) //{ // var path = Common.GetPath("Templates"); // ExportService exportService = new ExportService(); // ConfigExport cfgExport = new ConfigExport() // { // Object = obj, // FileName = "Hre_ReportProfileDisciplineModel", // OutPutPath = path, // DownloadPath = Hrm_Main_Web + "Templates", // IsDataTable = isDataTable // }; // var str = exportService.CreateTemplate(cfgExport); // return Json(str); //} //if (Model.ExportID != Guid.Empty) //{ // if (result != null && result.Count > 0) // { // #region lấy Org và OrgType // var orgServices = new Cat_OrgStructureServices(); // var lstObjOrg = new List<object>(); // lstObjOrg.Add(null); // lstObjOrg.Add(null); // lstObjOrg.Add(null); // lstObjOrg.Add(1); // lstObjOrg.Add(int.MaxValue - 1); // var lstOrg = orgServices.GetData<Cat_OrgStructureEntity>(lstObjOrg, ConstantSql.hrm_cat_sp_get_OrgStructure, ref status).ToList(); // var orgTypeService = new Cat_OrgStructureTypeServices(); // var lstObjOrgType = new List<object>(); // lstObjOrgType.Add(null); // lstObjOrgType.Add(null); // lstObjOrgType.Add(1); // lstObjOrgType.Add(int.MaxValue - 1); // var lstOrgType = orgTypeService.GetData<Cat_OrgStructureTypeEntity>(lstObjOrgType, ConstantSql.hrm_cat_sp_get_OrgStructureType, ref status).ToList(); // #endregion // foreach (var item in result) // { // Guid? orgId = item.OrgStructureID1; // var org = lstOrg.FirstOrDefault(s => s.ID == item.OrgStructureID1); // var orgBranch = LibraryService.GetNearestParentEntity(orgId, OrgUnit.E_BRANCH, lstOrg, lstOrgType); // var orgGroup = LibraryService.GetNearestParentEntity(orgId, OrgUnit.E_GROUP, lstOrg, lstOrgType); // var orgOrg = LibraryService.GetNearestParentEntity(orgId, OrgUnit.E_DEPARTMENT, lstOrg, lstOrgType); // var orgTeam = LibraryService.GetNearestParentEntity(orgId, OrgUnit.E_TEAM, lstOrg, lstOrgType); // var orgSection = LibraryService.GetNearestParentEntity(orgId, OrgUnit.E_SECTION, lstOrg, lstOrgType); // var orgDivision = LibraryService.GetNearestParentEntity(orgId, OrgUnit.E_DIVISION, lstOrg, lstOrgType); // item.BranchName = orgBranch != null ? orgBranch.OrgStructureName : string.Empty; // item.GroupName = orgGroup != null ? orgGroup.OrgStructureName : string.Empty; // item.DepartmentName = orgOrg != null ? orgOrg.OrgStructureName : string.Empty; // item.TeamName = orgTeam != null ? orgTeam.OrgStructureName : string.Empty; // item.SectionName = orgSection != null ? orgSection.OrgStructureName : string.Empty; // item.DivisionName = orgDivision != null ? orgDivision.OrgStructureName : string.Empty; // item.DisciplineCount = result.Where(s => s.ProfileID == item.ProfileID).Count(); // } // } // string[] valueField = null; // if (Model.ValueFields != null) // { // valueField = Model.ValueFields.Split(','); // } // var fullPath = ExportService.Export(Model.ExportID, result, null, Model.ExportType); // return Json(fullPath); //} //return Json(result.ToDataSourceResult(request)); #endregion HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateFrom ?? DateTime.Now }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateTo ?? DateTime.Now }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; if (Model != null && Model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = new Hre_ReportProfileDisciplineModel(), FileName = "Hre_ReportProfileDiscipline", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = false }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } #region Validate string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Hre_ReportProfileDisciplineModel>(Model, "Hre_ReportProfileDiscipline", ref message); if (!checkValidate) { return Json(message); } #endregion var service = new Hre_ReportServices(); var actionServices = new ActionService(UserLogin); List<object> listObj = new List<object>(); listObj.Add(Model.DateFrom); listObj.Add(Model.DateTo); listObj.Add(Model.OrgStructureID); string status = string.Empty; var result = actionServices.GetData<Hre_ReportProfileDisciplineEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptDiscripline, ref status).ToList().Translate<Hre_ReportProfileDisciplineModel>(); var lstprofileids = result.Select(s => s.ProfileID).ToList(); foreach (var item in result) { Guid profileID = item.ProfileID; item.count = result.Count(s => s.ProfileID == profileID); } if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult GetDateEndInfoListss([DataSourceRequest] DataSourceRequest request, Hre_VisaInfoSearchModel Model) { HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateEnd ?? DateTime.Now }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateTo ?? DateTime.Now }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; if (Model != null && Model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = new Hre_VisaInfoModel(), FileName = "Hre_VisaInfoModel", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = false }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } var service = new ActionService(UserLogin); List<object> listObj = new List<object>(); listObj.Add(Model.DateEnd); listObj.Add(Model.DateTo); listObj.Add(null); listObj.Add(null); string status = string.Empty; var result = service.GetData<Hre_VisaInfoEntity>(listObj, ConstantSql.hrm_hr_sp_get_VisaInfoDateEndList, ref status).ToList().Translate<Hre_VisaInfoModel>(); var lstprofileids = result.Select(s => s.Visa_ID).ToList(); foreach (var item in result) { Guid profileID = item.Visa_ID; // item.Visa_ID. = result.Count(s => s.Visa_ID == profileID); } if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult GetReportHDTJob([DataSourceRequest] DataSourceRequest request, Hre_ReportHDTJobModel model) { HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = DateTime.Now }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = DateTime.Now }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; if (model != null && model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = new Hre_ReportHDTJobModel(), FileName = "Hre_ReportHDTJob", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = false }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } #region Validate string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Hre_ReportHDTJobModel>(model, "Hre_ReportHDTJob", ref message); if (!checkValidate) { return Json(message); } #endregion var actionServices = new ActionService(UserLogin); var hrService = new Hre_ProfileServices(); DateTime From = SqlDateTime.MinValue.Value; DateTime To = SqlDateTime.MaxValue.Value; if (model.DateFrom != null) { From = model.DateFrom.Value; } if (model.DateTo != null) { To = model.DateTo.Value; } string status = string.Empty; var hdtJobServices = new Hre_HDTJobServices(); List<object> listObjHDTJob = new List<object>(); listObjHDTJob.Add(model.OrgStructureID); listObjHDTJob.Add(model.DateFrom); listObjHDTJob.Add(model.DateTo); var result = actionServices.GetData<Hre_ReportHDTJobEntity>(listObjHDTJob, ConstantSql.hrm_hr_sp_get_RptHDTJob, ref status).ToList().Translate<Hre_ReportHDTJobModel>(); if (model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(model.ExportID, result, listHeaderInfo, null, model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult ExportPurchaseRequest(string purchaseID, Guid? exportID, bool isCreateTemplate, bool isCreateTemplateForDynamicGrid) { string status = string.Empty; var baseService = new BaseService(); ExportFileType exportFileType = ExportFileType.Excel; var actionServices = new ActionService(UserLogin); var objs = new List<object>(); objs.Add(Common.ConvertToGuid(purchaseID)); var entityPR = actionServices.GetByIdUseStore<Fin_PurchaseRequestModel>(Common.ConvertToGuid(purchaseID), ConstantSql.hrm_hr_sp_get_PurchaseRequestById, ref status); var lstPRItem = actionServices.GetData<Fin_PurchaseRequestItemModel>(objs, ConstantSql.hrm_cat_sp_get_PRItemByPRID, ref status); DataTable table = new DataTable("Fin_PurchaseRequestModel"); if (entityPR != null && lstPRItem != null) { table.Columns.Add("FunctionName"); table.Columns.Add("BudgetOwnerName"); table.Columns.Add("ChannelName"); table.Columns.Add("BudgetChargedIn"); table.Columns.Add("From"); table.Columns.Add("To"); table.Columns.Add("SupplierName"); table.Columns.Add("Description"); table.Columns.Add("Code"); table.Columns.Add("CateCodeType"); table.Columns.Add("Name"); table.Columns.Add("ProjectName"); table.Columns.Add("PurchaseItemName"); table.Columns.Add("PurchaseItemCost"); table.Columns.Add("Quantity", typeof(double)); table.Columns.Add("UnitPrice", typeof(double)); table.Columns.Add("Amount", typeof(double)); foreach (var item in lstPRItem) { DataRow dr = table.NewRow(); dr["FunctionName"] = entityPR.FunctionName; dr["BudgetOwnerName"] = entityPR.BudgetOwnerName; dr["ChannelName"] = entityPR.ChannelName; dr["BudgetChargedIn"] = entityPR.BudgetChargedIn == null ? string.Empty : entityPR.BudgetChargedIn.Value.ToShortDateString(); dr["From"] = entityPR.From == null ? string.Empty : entityPR.From.Value.ToShortDateString(); ; dr["To"] = entityPR.To == null ? string.Empty : entityPR.To.Value.ToShortDateString(); dr["SupplierName"] = entityPR.SupplierName; dr["Description"] = entityPR.Description; dr["Code"] = item.Code == null ? string.Empty : item.Code; dr["CateCodeType"] = item.CateCodeType == null ? string.Empty : item.CateCodeType; dr["Name"] = item.Name == null ? string.Empty : item.Name; dr["ProjectName"] = item.ProjectName == null ? string.Empty : item.ProjectName; dr["PurchaseItemName"] = item.PurchaseItemName == null ? string.Empty : item.PurchaseItemName; dr["PurchaseItemCost"] = item.PurchaseItemCost == null ? string.Empty : item.PurchaseItemCost; dr["Quantity"] = item.Quantity == null ? 0 : item.Quantity.Value; dr["UnitPrice"] = item.UnitPrice == null ? 0 : item.UnitPrice.Value; dr["Amount"] = item.Amount == null ? 0 : item.Amount.Value; table.Rows.Add(dr); } var result = table; object obj = new Fin_PurchaseRequestModel(); var isDataTable = false; if (isCreateTemplateForDynamicGrid) { obj = result; isDataTable = true; } if (isCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = obj, FileName = "Fin_PurchaseRequestModel", OutPutPath = path, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } } if (exportID != null) { var fullPath = ExportService.Export((Guid)exportID, table, exportFileType); return Json(fullPath); } return null; }
public ActionResult GetReportWorkHistoryDept([DataSourceRequest] DataSourceRequest request, Hre_ReportWorkHistoryDeptModel Model) { #region Validate string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Hre_ReportWorkHistoryDeptModel>(Model, "Hre_ReportWorkHistoryDept", ref message); if (!checkValidate) { return Json(message); } #endregion var actionServices = new ActionService(UserLogin); var profileServices = new Hre_ProfileServices(); var rptServices = new Hre_ReportServices(); List<object> listObj = new List<object>(); listObj.Add(Model.DateFrom); listObj.Add(Model.DateTo); listObj.Add(Model.ProfileName); listObj.Add(Model.CodeEmp); listObj.Add(Model.JobTitleID); listObj.Add(Model.PositionID); listObj.Add(Model.OrgStructureIDs); listObj.Add(Model.TypeOfTransferID); listObj.Add(Model.SalaryClassID); listObj.Add(Model.WorkPlaceID); listObj.Add(Model.Status); listObj.Add(1); listObj.Add(int.MaxValue - 1); string status = string.Empty; var result = actionServices.GetData<Hre_ReportWorkHistoryDeptEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptWorkHistoryDept, ref status).ToList().Translate<Hre_ReportWorkHistoryDeptModel>(); HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateFrom != null ? Model.DateFrom : DateTime.Now }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateTo != null ? Model.DateTo : DateTime.Now }; HeaderInfo headerInfo3 = new HeaderInfo() { Name = "WorkPlaceName", Value = ((result != null && result.FirstOrDefault() != null) && result.FirstOrDefault().WorkPlaceName != null) ? result.FirstOrDefault().WorkPlaceName : "" }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2, headerInfo3 }; if (Model != null && Model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = new Hre_ReportWorkHistoryDeptModel(), FileName = "Hre_ReportWorkHistoryDept", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = false }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } bool isgroup = profileServices.IsGroupByOrgProfileQuit(); if (isgroup == true) { List<Hre_ReportWorkHistoryDeptModel> resultNew = new List<Hre_ReportWorkHistoryDeptModel>(); if (result.Count > 0) { var orgServices = new Cat_OrgStructureServices(); var lstObjOrg = new List<object>(); lstObjOrg.Add(null); lstObjOrg.Add(null); lstObjOrg.Add(null); lstObjOrg.Add(1); lstObjOrg.Add(int.MaxValue - 1); var lstOrg = actionServices.GetData<Cat_OrgStructureEntity>(lstObjOrg, ConstantSql.hrm_cat_sp_get_OrgStructure, ref status).ToList(); var orgTypeService = new Cat_OrgStructureTypeServices(); var lstObjOrgType = new List<object>(); lstObjOrgType.Add(null); lstObjOrgType.Add(null); lstObjOrgType.Add(1); lstObjOrgType.Add(int.MaxValue - 1); var lstOrgType = actionServices.GetData<Cat_OrgStructureTypeEntity>(lstObjOrgType, ConstantSql.hrm_cat_sp_get_OrgStructureType, ref status).ToList(); foreach (var item in result) { var orgName = new List<string>(); if (item.OrgStructureID != null) { orgName = rptServices.GetParentOrgName(lstOrg, lstOrgType, item.OrgStructureID); if (orgName.Count < 3) { orgName.Insert(0, string.Empty); if (orgName.Count < 3) { orgName.Insert(0, string.Empty); } } } if (orgName.Count > 0) { item.Channel = orgName[2]; item.Region = orgName[1]; item.Area = orgName[0]; } resultNew.Add(item); } } if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, resultNew, listHeaderInfo, Model.ExportType); return Json(fullPath); } return Json(resultNew.ToDataSourceResult(request)); } if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
//public ActionResult CreateTemplate(CreateTemplateModel model) //{ // if (model != null) // { // var service = new BaseService(); // Cat_ExportEntity exportEntity = new Cat_ExportEntity() // { // ExportName = model.TemplateName, // IsColumnDynamic = model.IsDynamic, // ScreenName = model.ScreenName, // TemplateFile = model.TemplateFile // }; // service.Add(exportEntity); // } // return Json(""); //} public ActionResult GetReportHCGender([DataSourceRequest] DataSourceRequest request, Hre_ReportHCGenderModel model) { var service = new Hre_ReportServices(); var hrService = new Hre_ProfileServices(); object obj = new Hre_ReportHCGenderModel(); var isDataTable = false; HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = DateTime.Now }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = DateTime.Now }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; var result = service.GetReportHCGender(model.MonthSearch, model.JobtitleID, model.OrgStructureID, model.OrgStructureTypeID, model.Gender, model.isIncludeQuitEmp, model.IsCreateTemplate, UserLogin); if (model.IsCreateTemplateForDynamicGrid) { var col = result.Columns.Count; result.Columns.RemoveAt(col - 1); obj = result; isDataTable = true; } if (model != null && model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = obj, FileName = "Hre_ReportHCGenderModel", OutPutPath = path, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (model.ExportID != Guid.Empty) { result.Rows[0].Delete(); var col = result.Columns.Count; result.Columns.RemoveAt(col - 1); // var row = result.Rows.Count; // result.Rows[row - 1].Delete(); string[] valueField = null; if (model.ValueFields != null) { valueField = model.ValueFields.Split(','); } var fullPath = ExportService.Export(model.ExportID, result, listHeaderInfo, model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult GetReportPrenancy([DataSourceRequest] DataSourceRequest request, Hre_ReportPregnancyModel Model) { #region Validate string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Hre_ReportPregnancyModel>(Model, "Hre_ReportPregnancy", ref message); if (!checkValidate) { return Json(message); } #endregion var service = new Hre_ReportServices(); var actionServices = new ActionService(UserLogin); string status = string.Empty; DateTime From = SqlDateTime.MinValue.Value; DateTime To = SqlDateTime.MaxValue.Value; if (Model.DateStart != null) { From = Model.DateStart.Value; } if (Model.DateEnd != null) { To = Model.DateEnd.Value; } var isDataTable = false; object obj = new Hre_ReportPregnancyModel(); List<object> listObj = new List<object>(); listObj.Add(Model.DateStart); listObj.Add(Model.DateEnd); listObj.Add(Model.OrgStructureID); listObj.Add(Model.ProfileName); listObj.Add(Model.CodeEmp); var result = actionServices.GetData<Hre_ReportPregnancyEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptPrenancy, ref status).ToList(); var orgServices = new Cat_OrgStructureServices(); var lstObjOrg = new List<object>(); lstObjOrg.Add(null); lstObjOrg.Add(null); lstObjOrg.Add(null); lstObjOrg.Add(1); lstObjOrg.Add(int.MaxValue - 1); var lstOrg = actionServices.GetData<Cat_OrgStructureEntity>(lstObjOrg, ConstantSql.hrm_cat_sp_get_OrgStructure, ref status).ToList(); var orgTypeService = new Cat_OrgStructureTypeServices(); var lstObjOrgType = new List<object>(); lstObjOrgType.Add(null); lstObjOrgType.Add(null); lstObjOrgType.Add(1); lstObjOrgType.Add(int.MaxValue - 1); var lstOrgType = actionServices.GetData<Cat_OrgStructureTypeEntity>(lstObjOrgType, ConstantSql.hrm_cat_sp_get_OrgStructureType, ref status).ToList(); var lstRptPrenancyEntity = new List<Hre_ReportPregnancyEntity>(); foreach (var item in result) { var pregnancyEntity = new Hre_ReportPregnancyEntity(); var orgName = service.GetParentOrgName(lstOrg, lstOrgType, item.OrgID); if (orgName.Count < 3) { orgName.Insert(0, string.Empty); if (orgName.Count < 3) { orgName.Insert(0, string.Empty); } } pregnancyEntity = item.CopyData<Hre_ReportPregnancyEntity>(); pregnancyEntity.Channel = orgName[2]; pregnancyEntity.Region = orgName[1]; pregnancyEntity.Area = orgName[0]; lstRptPrenancyEntity.Add(pregnancyEntity); } var lstRptPrenancyModel = lstRptPrenancyEntity.Translate<Hre_ReportPregnancyModel>(); if (Model.IsCreateTemplateForDynamicGrid) { obj = lstRptPrenancyModel; isDataTable = true; } if (Model != null && Model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = obj, FileName = "Hre_ReportPregnancyModel", OutPutPath = path, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (Model.ExportID != Guid.Empty) { string[] valueField = null; if (Model.ValueFields != null) { valueField = Model.ValueFields.Split(','); } var fullPath = ExportService.Export(Model.ExportID, lstRptPrenancyModel, null, Model.ExportType); return Json(fullPath); } return Json(lstRptPrenancyModel.ToDataSourceResult(request)); }
public ActionResult GetReportProfileNew([DataSourceRequest] DataSourceRequest request, Hre_ReportProfileNewModel Model) { string status = string.Empty; var services = new Hre_ReportServices(); var isDataTable = false; object obj = new Hre_ReportProfileNewModel(); #region Validate HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateFrom }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateTo }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Hre_ReportProfileNewModel>(Model, "Hre_ReportProfileNew", ref message); if (!checkValidate) { return Json(message, JsonRequestBehavior.AllowGet); } DateTime From = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); DateTime To = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).AddDays(-1); #endregion if (Model.DateFrom != null) { From = Model.DateFrom.Value; } if (Model.DateTo != null) { To = Model.DateTo.Value; } var result = services.GetReportProfileNew( From, To, Model.OrgStructureID, Model.IsCreateTemplate, Model.CodeEmp, Model.ProfileName, Model.SalaryClassID, Model.CodeCandidate, Model.WorkPlaceID, Model.EmpTypeID, UserLogin ); if (Model != null && Model.IsCreateTemplateForDynamicGrid) { obj = result; isDataTable = true; } if (Model != null && Model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = new Hre_ReportProfileNewModel(), FileName = "Hre_ReportProfileNew", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = false }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult GetReportReward([DataSourceRequest] DataSourceRequest request, Hre_ReportRewardModel Model) { #region Validate string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Hre_ReportRewardModel>(Model, "Hre_ReportReward", ref message); if (!checkValidate) { return Json(message); } #endregion var service = new Hre_ReportServices(); var actionServices = new ActionService(UserLogin); var isDataTable = false; object obj = new Hre_ReportRewardModel(); List<object> listObj = new List<object>(); DateTime From = SqlDateTime.MinValue.Value; DateTime To = SqlDateTime.MaxValue.Value; List<Guid?> OrgIds = new List<Guid?>(); if (Model.DateFrom != null) { From = Model.DateFrom.Value; listObj.Add(From); } else { listObj.Add(null); } if (Model.DateTo != null) { To = Model.DateTo.Value; listObj.Add(To); } else { listObj.Add(null); } string strOrgIDs = null; if (!string.IsNullOrEmpty(Model.OrgStructureID)) { strOrgIDs = Model.OrgStructureID; } listObj.Add(strOrgIDs); HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = From }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = To }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; string status = string.Empty; var result = actionServices.GetData<Hre_ReportRewardEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptReward, ref status).ToList().Translate<Hre_ReportRewardModel>(); if (Model.IsCreateTemplateForDynamicGrid) { obj = result; isDataTable = true; } if (Model != null && Model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = obj, FileName = "Hre_ReportReward", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult GetReportEducationCharList([DataSourceRequest] DataSourceRequest request, Hre_ReportEducationChartListModel Model) { HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateFrom != null ? Model.DateFrom : DateTime.Now }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateTo != null ? Model.DateTo : DateTime.Now }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; if (Model != null && Model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = new Hre_ReportEducationChartListModel(), FileName = "Hre_ReportEducationChartList", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = false }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } #region Validate string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Hre_ReportEducationChartListModel>(Model, "Hre_ReportProfileNew", ref message); if (!checkValidate) { return Json(message); } DateTime From = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); DateTime To = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).AddDays(-1); #endregion if (Model.DateFrom != null) { From = Model.DateFrom.Value; } if (Model.DateTo != null) { To = Model.DateTo.Value; } var service = new Hre_ReportServices(); var actionServices = new ActionService(UserLogin); List<object> strOrgIDs = new List<object>(); strOrgIDs.AddRange(new object[3]); strOrgIDs[0] = (object)Model.OrgStructureID; string status = string.Empty; List<Guid> lstProfileIDs = actionServices.GetData<Hre_ProfileIdEntity>(strOrgIDs, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, ref status).Select(s => s.ID).ToList(); var result = service.GetReportEducationCharList(From, To, lstProfileIDs, Model.AppliedForThisPeriod).ToList().Translate<Hre_ReportEducationChartListModel>(); if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, result, Model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult GetReportHCSales([DataSourceRequest] DataSourceRequest request, Hre_ReportHCSalesModel model) { var service = new Hre_ReportServices(); var eva_Service = new Eva_ReportServices(); var hrService = new Hre_ProfileServices(); //List<object> listObj = new List<object>(); //listObj.Add(model.OrgStructureID); //listObj.Add(string.Empty); //listObj.Add(string.Empty); //string status = string.Empty; //var listEntity = hrService.GetData<Hre_ProfileIdEntity>(listObj, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrgStructure, ref status).Select(s => s.ID).ToList(); var result = eva_Service.GetReportHCSales(model.dateSearch, model.OrgStructureID, model.IsCreateTemplate, UserLogin); //var rs = result.Translate<Hre_ReportMonthlyHCModel>(); HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = DateTime.Now }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = DateTime.Now }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; object obj = new Hre_ReportHCSalesModel(); var isDataTable = false; if (model.IsCreateTemplateForDynamicGrid) { var col = result.Columns.Count; result.Columns.RemoveAt(col - 1); obj = result; isDataTable = true; } if (model != null && model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = obj, FileName = "Hre_ReportHCSalesModel", OutPutPath = path, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (model.ExportID != Guid.Empty) { //var row = result.Rows.Count; // result.Rows[row - 1].Delete(); var col = result.Columns.Count; result.Columns.RemoveAt(col - 1); var fullPath = ExportService.Export(model.ExportID, result, listHeaderInfo, model.ExportType); return Json(fullPath); } //0string dataReturn = result.ConvertDataTabletoString(); return Json(result.ToDataSourceResult(request)); }
public ActionResult GetReportProfileComeBack([DataSourceRequest] DataSourceRequest request, Hre_ReportProfileComeBackModel Model) { string status = string.Empty; var actionServices = new ActionService(UserLogin); var contractServices = new Hre_ContractServices(); HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateFrom }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateTo }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; #region Validate string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Hre_ReportProfileComeBackModel>(Model, "Hre_ReportProfileComeBack", ref message); if (!checkValidate) { return Json(message); } #endregion List<object> lstpara = new List<object>(); lstpara.Add(Model.DateFrom); lstpara.Add(Model.DateTo); lstpara.Add(Model.OrgStructureIDs); lstpara.Add(Model.ProfileName); lstpara.Add(Model.CodeEmp); lstpara.Add(Model.RankID); lstpara.Add(Model.WorkPlaceID); var result = actionServices.GetData<Hre_ReportProfileComeBackModel>(lstpara, ConstantSql.hrm_hr_sp_get_RptProfileComBack, ref status); var lstResultEntity = result.Translate<Hre_ReportProfileComeBackEntity>(); var dataResult = contractServices.GetDataContractByProfileID(lstResultEntity, UserLogin); var isDataTable = false; DataTable obj = null; if (Model.IsCreateTemplateForDynamicGrid) { obj = dataResult; isDataTable = true; } if (Model != null && Model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = obj, FileName = "Hre_ReportProfileComeBackEntity", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = true }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, dataResult, listHeaderInfo, Model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult GetReportMonthlyHC([DataSourceRequest] DataSourceRequest request, Hre_ReportMonthlyHCModel model) { var service = new Hre_ReportServices(); var hrService = new Hre_ProfileServices(); object obj = new Hre_ReportMonthlyHCModel(); var isDataTable = false; //List<object> listObj = new List<object>(); //listObj.Add(model.OrgStructureID); //listObj.Add(string.Empty); //listObj.Add(string.Empty); //string status = string.Empty; //var listEntity = hrService.GetData<Hre_ProfileIdEntity>(listObj, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrgStructure, ref status).Select(s => s.ID).ToList(); var result = service.GetReportMonthlyHC(model.dateSearch, model.JobtitleID, model.OrgStructureID, model.OrgStructureTypeID, model.IsCreateTemplate, UserLogin); var rs = result.Translate<Hre_ReportMonthlyHCModel>(); if (model.IsCreateTemplateForDynamicGrid) { obj = result; isDataTable = true; } if (model != null && model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = obj, FileName = "Hre_ReportMonthlyHCModel", OutPutPath = path, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(model.ExportID, result, null, model.ExportType); return Json(fullPath); } //0string dataReturn = result.ConvertDataTabletoString(); return Json(rs.ToDataSourceResult(request)); }
public ActionResult GetReportCodeNotInSystem([DataSourceRequest] DataSourceRequest request, Hre_ReportCodeNotInSystemModel Model) { HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateFrom != null ? Model.DateFrom : DateTime.Now }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateTo != null ? Model.DateTo : DateTime.Now }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; if (Model != null && Model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = new Hre_ReportCodeNotInSystemModel(), FileName = " Hre_ReportCodeNotInSystem", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = false }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } var actionServices = new ActionService(UserLogin); var hrService = new Hre_ProfileServices(); //ListQueryModel lstModel = new ListQueryModel //{ // PageIndex = request.Page, // Filters = ExtractFilterAttributes(request), // Sorts = ExtractSortAttributes(request) //}; List<object> listobj = new List<object>(); DateTime From = SqlDateTime.MinValue.Value; DateTime To = SqlDateTime.MaxValue.Value; if (Model.DateFrom != null) { From = Model.DateFrom.Value; } if (Model.DateTo != null) { To = Model.DateTo.Value; } listobj.Add(From); listobj.Add(To); string status = string.Empty; var result = actionServices.GetData<Hre_ReportCodeNotInSystemEntity>(listobj, ConstantSql.hrm_hr_sp_get_RptCodeNotInSystem, ref status).ToList().Translate<Hre_ReportCodeNotInSystemModel>(); //var result = service.GetReportCodeNotInSystem(From, To).ToList().Translate<Hre_ReportCodeNotInSystemModel>(); if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, result, Model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult ExportRelativesListByTemplate([DataSourceRequest] DataSourceRequest request, Hre_RelativesSearchModel model) { string status = string.Empty; var isDataTable = false; object obj = new Hre_RelativesModel(); var actionServices = new ActionService(UserLogin); var result = GetListData<Hre_RelativesModel, Hre_RelativesEntity, Hre_RelativesSearchModel>(request, model, ConstantSql.hrm_hr_sp_get_Relatives, ref status); if (model.IsCreateTemplateForDynamicGrid) { obj = result; isDataTable = false; } if (model != null && model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = obj, FileName = "Hre_RelativesModel", OutPutPath = path, // HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = false }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (model.ExportId != Guid.Empty) { var fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); //return GetListDataAndReturn<Hre_RelativesModel, Hre_RelativesEntity, Hre_RelativesSearchModel>(request, model, ConstantSql.hrm_hr_sp_get_Relatives); }
public ActionResult GetReportProfileQuit([DataSourceRequest] DataSourceRequest request, Hre_ReportProfileQuitModel Model) { HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateStart != null ? Model.DateStart : DateTime.Now }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateEnd != null ? Model.DateEnd : DateTime.Now }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; if (Model != null && Model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = new Hre_ReportProfileQuitModel(), FileName = "Hre_ReportProfileQuit", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = false }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } #region Validate string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Hre_ReportProfileQuitModel>(Model, "Hre_ReportProfileQuit", ref message); if (!checkValidate) { return Json(message); } #endregion var service = new Hre_ReportServices(); var actionServices = new ActionService(UserLogin); //DateTime From = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); //DateTime To = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).AddDays(-1); DateTime From = SqlDateTime.MinValue.Value; DateTime To = SqlDateTime.MaxValue.Value; if (Model.DateStart != null) { From = Model.DateStart.Value; } if (Model.DateEnd != null) { To = Model.DateEnd.Value; } List<object> listObj = new List<object>(); listObj.Add(Model.OrgStructureID); listObj.Add(From); listObj.Add(To); string status = string.Empty; var result = actionServices.GetData<Hre_ReportProfileQuitEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptQuitProfile, ref status).ToList().Translate<Hre_ReportProfileQuitModel>(); if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult ExportHDTJobListByTemplate([DataSourceRequest] DataSourceRequest request, Hre_HDTJobSearchModel model) { HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = model.DateFrom == null ? DateTime.Now : model.DateFrom }; HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = model.DateTo == null ? DateTime.Now : model.DateTo }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 }; string status = string.Empty; var isDataTable = false; object obj = new Hre_ProfileModel(); var actionServices = new ActionService(UserLogin); List<object> lstObjSearch = new List<object>(); lstObjSearch.Add(model.ProfileName); lstObjSearch.Add(model.CodeEmp); lstObjSearch.Add(model.HDTJobTypeID); lstObjSearch.Add(model.JobTitleID); lstObjSearch.Add(model.PositionID); lstObjSearch.Add(model.OrgStructureID); lstObjSearch.Add(model.DateFrom); lstObjSearch.Add(model.DateTo); lstObjSearch.Add(model.Price); lstObjSearch.Add(model.IsCreateTemplate); lstObjSearch.Add(model.ExportId); lstObjSearch.Add(model.ExportType); lstObjSearch.Add(1); lstObjSearch.Add(int.MaxValue - 1); var result = actionServices.GetData<Hre_HDTJobEntity>(lstObjSearch, ConstantSql.hrm_hr_sp_get_HDTJob, ref status); var profileServices = new Hre_ProfileServices(); var listResult = profileServices.getHDTJobByPrice(result, model.DateFrom, model.DateTo).Translate<Hre_HDTJobModel>(); if (model != null && model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = new Hre_HDTJobModel(), FileName = "Hre_HDTJob", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (model.ExportId != Guid.Empty) { if (model.DateFrom != null && model.DateTo != null) { var fullPath = ExportService.Export(model.ExportId, listResult, listHeaderInfo, model.ExportType); return Json(fullPath); } else { var fullPath = ExportService.Export(model.ExportId, listResult, null, model.ExportType); return Json(fullPath); } } return Json(result.ToDataSourceResult(request)); }
public ActionResult GetExpiryContract([DataSourceRequest] DataSourceRequest request, Hre_ReportExpiryContractModel Model) { string status = string.Empty; var service = new Hre_ReportServices(); var actionServices = new ActionService(UserLogin); var profileServices = new Hre_ProfileServices(); var contractServices = new Hre_ContractServices(); BaseService baseServices = new BaseService(); bool isshowloopcontract = profileServices.IsNotUseExpiryContractLoop(); var ShowAfterDate1 = actionServices.GetData<Sys_AllSettingEntity>("HRM_HRE_CONTRACT_ALERT_EXPRIDAY_VALUEAFTE", ConstantSql.hrm_sys_sp_get_AllSettingByKey, ref status).FirstOrDefault(); var ShowBeforDate1 = actionServices.GetData<Sys_AllSettingEntity>("HRM_HRE_CONTRACT_ALERT_EXPRIDAY_VALUEBEFOR", ConstantSql.hrm_sys_sp_get_AllSettingByKey, ref status).FirstOrDefault(); DateTime? dateTo = null; DateTime? dateFrom = null; if (isshowloopcontract == false) { dateTo = DateTime.Now.AddDays(Convert.ToDouble(ShowAfterDate1.Value1)); dateFrom = DateTime.Now.AddDays(-Convert.ToDouble(ShowBeforDate1.Value1)); } var isDataTable = false; object obj = new Hre_ReportExpiryContractModel(); //var lstProfile = new List<Hre_ProfileEntity>(); var objProfile = new List<object>(); objProfile.AddRange(new object[2]); objProfile[0] = 1; objProfile[1] = int.MaxValue - 1; var lstProfile = actionServices.GetData<Hre_ProfileEntity>(objProfile, ConstantSql.hrm_hr_sp_get_ProfileDataAll, ref status).ToList(); var lstObjContractType = new List<object>(); lstObjContractType.Add(null); lstObjContractType.Add(null); lstObjContractType.Add(null); lstObjContractType.Add(null); lstObjContractType.Add(1); lstObjContractType.Add(int.MaxValue - 1); var lstContractType = actionServices.GetData<CatContractTypeModel>(lstObjContractType, ConstantSql.hrm_cat_sp_get_ContractType, ref status).ToList(); List<object> listObj = new List<object>(); listObj.Add(Model.OrgStructureID); listObj.Add(Model.Status); listObj.Add(dateFrom); listObj.Add(dateTo); listObj.Add(Model.CodeEmp); listObj.Add(Model.ProfileName); listObj.Add(Model.IDNo); listObj.Add(Model.WorkPlaceID); listObj.Add(Model.DateSignedFrom); listObj.Add(Model.DateSignedTo); listObj.Add(Model.ContractNo); listObj.Add(1); listObj.Add(int.MaxValue - 1); var result = actionServices.GetData<Hre_ReportExpiryContractEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptExpireContract, ref status).Where(s => s.StatusEvaluation != WorkdayStatus.E_APPROVED.ToString()).ToList().Translate<Hre_ReportExpiryContractModel>(); var objContract = new List<object>(); objContract.AddRange(new object[21]); objContract[19] = 1; objContract[20] = int.MaxValue - 1; var lstContracts = actionServices.GetData<Hre_ContractEntity>(objContract, ConstantSql.hrm_hr_sp_get_Contract, ref status).ToList(); Guid[] _RankDetailForNextContract = null; if (!string.IsNullOrEmpty(Model.RankDetailForNextContractIds)) { _RankDetailForNextContract = Model.RankDetailForNextContractIds.Split(',').Select(s => Guid.Parse(s)).ToArray(); } if (Model.ContractTypeID != null) { result = result.Where(s => s.ContractTypeID == Model.ContractTypeID).ToList(); } if (!string.IsNullOrEmpty(Model.Status)) { result = result.Where(s => s.Status == Model.Status).ToList(); } var lstModel = new List<Hre_ReportExpiryContractModel>(); if (_RankDetailForNextContract != null) { result = result.Where(s => _RankDetailForNextContract.Contains(s.RankDetailForNextContract != null ? s.RankDetailForNextContract.Value : Guid.Empty)).ToList(); } if (Model.EvaType == EnumDropDown.EvaExpiryContract.E_EVA_CONTRACT.ToString()) { result = result.Where(s => s.StatusEvaluation != WorkdayStatus.E_APPROVED.ToString() && s.ContractResult != null).ToList(); if (isshowloopcontract == false) { var model = new Hre_ReportExpiryContractModel(); foreach (var item in result) { var ContractByProfileID = lstContracts.Where(s => s.ProfileID == item.ProfileID).OrderByDescending(s => s.DateCreate).FirstOrDefault(); if (ContractByProfileID != null) { if (ContractByProfileID.DateCreate != null && ContractByProfileID.DateCreate.Value.ToShortDateString() != DateTime.Now.ToShortDateString()) { if (item.DateExtend != null && item.DateExtend >= dateFrom && item.DateExtend <= dateTo) { model = item; lstModel.Add(model); } if (item.DateExtend == null && item.DateEnd != null && item.DateEnd >= dateFrom && item.DateEnd <= dateTo) { model = item; lstModel.Add(model); } } } } } else { foreach (var item in result) { var dateSenior = new TimeSpan(); double monthSenior = 0; var profileEntity = lstProfile.Where(s => s.ID == item.ProfileID).FirstOrDefault(); if (profileEntity != null && profileEntity.DateHire != null && Model.DateEnd != null) { dateSenior = Model.DateEnd.Value.Subtract(profileEntity.DateHire.Value); monthSenior = Math.Floor(dateSenior.TotalDays / 30); } item.MonthSenior = (double?)monthSenior; var dateCheck = DateTime.Now; var model = new Hre_ReportExpiryContractModel(); var contractTypeEntity = lstContractType.Where(s => item.ContractTypeID == s.ID).FirstOrDefault(); if (item.ContractResult == null) { if (contractTypeEntity != null && contractTypeEntity.ExpiryContractLoop != null) { var dateExpiry = dateCheck.AddDays(contractTypeEntity.ExpiryContractLoop.Value); if (item.DateExtend != null && item.DateExtend <= dateExpiry) { model = item; lstModel.Add(model); } if (item.DateExtend == null && item.DateEnd != null && item.DateEnd.Value <= dateExpiry) { model = item; lstModel.Add(model); } } } } } } else if (Model.EvaType == EnumDropDown.EvaExpiryContract.E_NONEEVA_CONTRACT.ToString()) { result = result.Where(s => s.ContractResult == null).ToList(); if (isshowloopcontract == false) { var model = new Hre_ReportExpiryContractModel(); foreach (var item in result) { var ContractByProfileID = lstContracts.Where(s => s.ProfileID == item.ProfileID).OrderByDescending(s => s.DateCreate).FirstOrDefault(); if (ContractByProfileID != null) { if (ContractByProfileID.DateCreate != null && ContractByProfileID.DateCreate.Value.ToShortDateString() != DateTime.Now.ToShortDateString()) { if (item.DateExtend != null && item.DateExtend >= dateFrom && item.DateExtend <= dateTo) { model = item; lstModel.Add(model); } if (item.DateExtend == null && item.DateEnd != null && item.DateEnd >= dateFrom && item.DateEnd <= dateTo) { model = item; lstModel.Add(model); } } } } } else { foreach (var item in result) { var dateSenior = new TimeSpan(); double monthSenior = 0; var profileEntity = lstProfile.Where(s => s.ID == item.ProfileID).FirstOrDefault(); if (profileEntity != null && profileEntity.DateHire != null && Model.DateEnd != null) { dateSenior = Model.DateEnd.Value.Subtract(profileEntity.DateHire.Value); monthSenior = Math.Floor(dateSenior.TotalDays / 30); } item.MonthSenior = (double?)monthSenior; var dateCheck = DateTime.Now; var model = new Hre_ReportExpiryContractModel(); var contractTypeEntity = lstContractType.Where(s => item.ContractTypeID == s.ID).FirstOrDefault(); if (item.ContractResult == null) { if (contractTypeEntity != null && contractTypeEntity.ExpiryContractLoop != null) { var dateExpiry = dateCheck.AddDays(contractTypeEntity.ExpiryContractLoop.Value); if (item.DateExtend != null && item.DateExtend <= dateExpiry) { model = item; lstModel.Add(model); } if (item.DateExtend == null && item.DateEnd != null && item.DateEnd.Value <= dateExpiry) { model = item; lstModel.Add(model); } } } } } } else { if (isshowloopcontract == false) { var model = new Hre_ReportExpiryContractModel(); foreach (var item in result) { var ContractByProfileID = lstContracts.Where(s => s.ProfileID == item.ProfileID).OrderByDescending(s => s.DateCreate).FirstOrDefault(); if (ContractByProfileID != null) { if (ContractByProfileID.DateCreate != null && ContractByProfileID.DateCreate.Value.ToShortDateString() != DateTime.Now.ToShortDateString()) { if (item.DateExtend != null && item.DateExtend >= dateFrom && item.DateExtend <= dateTo) { model = item; lstModel.Add(model); } if (item.DateExtend == null && item.DateEnd != null && item.DateEnd >= dateFrom && item.DateEnd <= dateTo) { model = item; lstModel.Add(model); } } } } } else { foreach (var item in result) { var dateSenior = new TimeSpan(); double monthSenior = 0; var profileEntity = lstProfile.Where(s => s.ID == item.ProfileID).FirstOrDefault(); if (profileEntity != null && profileEntity.DateHire != null && Model.DateEnd != null) { dateSenior = Model.DateEnd.Value.Subtract(profileEntity.DateHire.Value); monthSenior = Math.Floor(dateSenior.TotalDays / 30); } item.MonthSenior = (double?)monthSenior; var dateCheck = DateTime.Now; var model = new Hre_ReportExpiryContractModel(); var contractTypeEntity = lstContractType.Where(s => item.ContractTypeID == s.ID).FirstOrDefault(); if (contractTypeEntity != null && contractTypeEntity.ExpiryContractLoop != null) { var dateExpiry = dateCheck.AddDays(contractTypeEntity.ExpiryContractLoop.Value); if (item.DateExtend != null && item.DateExtend <= dateExpiry) { model = item; lstModel.Add(model); } if (item.DateExtend == null && item.DateEnd != null && item.DateEnd.Value <= dateExpiry) { model = item; lstModel.Add(model); } } } } } #region Lấy phụ lục hợp đông var _ReportService = new Hre_ContractServices(); var lisEntity = result.Translate<Hre_ContractEntity>(); DataTable tb = _ReportService.GetDataContract(lisEntity, UserLogin); #endregion #region Xuất template if (Model != null && Model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = tb, FileName = "Hre_ContractEntity", OutPutPath = path, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = true }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } #endregion if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, tb, Model.ExportType); return Json(fullPath); } return Json(lstModel.ToDataSourceResult(request)); }
public ActionResult GetReportProfileWorking([DataSourceRequest] DataSourceRequest request, Hre_ReportProfileWorkingModel Model) { #region Validate string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Hre_ReportProfileWorkingModel>(Model, "Hre_ReportProfileWorking", ref message); if (!checkValidate) { return Json(message); } #endregion var service = new Hre_ReportServices(); var actionServices = new ActionService(UserLogin); DateTime From = SqlDateTime.MinValue.Value; DateTime To = SqlDateTime.MaxValue.Value; if (Model.DateFrom != null) { From = Model.DateFrom.Value; } if (Model.DateTo != null) { To = Model.DateTo.Value; } var isDataTable = false; object obj = new Hre_ReportProfileWorkingEntity(); List<object> listObj = new List<object>(); listObj.Add(Model.OrgStructureID); listObj.Add(Model.DateFrom); listObj.Add(Model.DateTo); listObj.Add(Model.CodeEmp); string status = string.Empty; var result = actionServices.GetData<Hre_ReportProfileWorkingEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptWorkingProfile, ref status); if (Model.IsCreateTemplateForDynamicGrid) { obj = result; isDataTable = true; } if (Model != null && Model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = obj, FileName = "Hre_ReportProfileWorkingEntity", OutPutPath = path, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (Model.ExportID != Guid.Empty) { string[] valueField = null; if (Model.ValueFields != null) { valueField = Model.ValueFields.Split(','); } var fullPath = ExportService.Export(Model.ExportID, result, null, Model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request), JsonRequestBehavior.AllowGet); }
public ActionResult ExportProfileIsBackList([DataSourceRequest] DataSourceRequest request, Hre_ProfileSearchIsBackListModel model) { #region Validate string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Hre_ProfileSearchIsBackListModel>(model, "Hre_ReportProfileIsBackList", ref message); if (!checkValidate) { return Json(message); } #endregion var service = new Hre_ReportServices(); var hrService = new Hre_ProfileServices(); string status = string.Empty; object obj = new Hre_ProfileSearchIsBackListModel(); ListQueryModel lstModel = new ListQueryModel { PageSize = int.MaxValue - 1, PageIndex = 1, Filters = ExtractFilterAttributes(request), Sorts = ExtractSortAttributes(request), AdvanceFilters = ExtractAdvanceFilterAttributes(model) }; var result = GetListData<Hre_ReportProfileIsBackListModel, Hre_ReportProfileIsBackListEntity, Hre_ProfileSearchIsBackListModel>(request, model, ConstantSql.hrm_hr_sp_get_ProfileIsBackList, ref status); if (model != null && model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = new Hre_ReportProfileIsBackListModel(), FileName = "Hre_ReportProfileIsBackList", OutPutPath = path, //HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = false }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(model.ExportID, result, null, model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult ExportProfileAllListByTemplate([DataSourceRequest] DataSourceRequest request, Hre_ProfileAllSearchModel model) { string status = string.Empty; var isDataTable = false; var service = new BaseService(); object obj = new Hre_ProfileModel(); ListQueryModel lstModel = new ListQueryModel { PageSize = int.MaxValue - 1, PageIndex = 1, Filters = ExtractFilterAttributes(request), Sorts = ExtractSortAttributes(request), AdvanceFilters = ExtractAdvanceFilterAttributes(model) }; var result = GetListData<Hre_ProfileModel, Hre_ProfileEntity, Hre_ProfileAllSearchModel>(request, model, ConstantSql.hrm_hr_sp_get_ProfileAll, ref status); if (model.IsCreateTemplateForDynamicGrid) { obj = result; isDataTable = false; } if (model != null && model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = obj, FileName = "Hre_ProfileModel", OutPutPath = path, // HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (model.ExportId != Guid.Empty) { var fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult GetReportOrgProfle([DataSourceRequest] DataSourceRequest request, CatOrgStructureModel Model) { var service = new Hre_ReportServices(); var actionServices = new ActionService(UserLogin); List<object> listObj = new List<object>(); List<Guid?> OrgIds = new List<Guid?>(); string strOrgIDs = null; if (!string.IsNullOrEmpty(Model.OrgStructureID)) { strOrgIDs = Model.OrgStructureID; } listObj.Add(strOrgIDs); string status = string.Empty; var result = actionServices.GetData<Cat_OrgStructureEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptOrgProfile, ref status).ToList().Translate<CatOrgStructureModel>(); object obj = new CatOrgStructureModel(); var isDataTable = false; if (Model.IsCreateTemplateForDynamicGrid) { obj = result; isDataTable = true; } if (Model != null && Model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = obj, FileName = "CatOrgStructureModel", OutPutPath = path, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = isDataTable }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } if (Model.ExportID != Guid.Empty) { var fullPath = ExportService.Export(Model.ExportID, result, Model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }
public ActionResult GetReportSeniority([DataSourceRequest] DataSourceRequest request, Hre_ReportSeniorityModel Model) { HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateSeniority != null ? Model.DateSeniority.Value : DateTime.Now }; List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1 }; if (Model != null && Model.IsCreateTemplate) { var path = Common.GetPath("Templates"); ExportService exportService = new ExportService(); ConfigExport cfgExport = new ConfigExport() { Object = new Hre_ReportSeniorityModel(), FileName = "Hre_ReportSeniority", OutPutPath = path, HeaderInfo = listHeaderInfo, DownloadPath = Hrm_Main_Web + "Templates", IsDataTable = false }; var str = exportService.CreateTemplate(cfgExport); return Json(str); } #region Validate string message = string.Empty; var checkValidate = ValidatorService.OnValidateData<Hre_ReportSeniorityModel>(Model, "Hre_ReportSeniority", ref message); if (!checkValidate) { return Json(message); } #endregion var service = new Hre_ReportServices(); var actionServices = new ActionService(UserLogin); DateTime DateSeniority = DateTime.Now; List<Guid?> OrgIds = new List<Guid?>(); if (Model.DateSeniority != null) { DateSeniority = Model.DateSeniority.Value; } string strOrgIDs = null; if (!string.IsNullOrEmpty(Model.OrgStructureID)) { strOrgIDs = Model.OrgStructureID; } List<object> listObj = new List<object>(); listObj.Add(strOrgIDs); listObj.Add(string.Empty); listObj.Add(string.Empty); string status = string.Empty; var listEntity = actionServices.GetData<Hre_ProfileEntity>(listObj, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrgStructure, ref status).ToList(); if (listEntity.Count == 0) { return Json(null); } var result = service.GetReportSeniority(DateSeniority, listEntity).ToList().Translate<Hre_ReportSeniorityModel>(); if (Model.ExportID != Guid.Empty) { string[] valueField = null; if (Model.ValueFields != null) { valueField = Model.ValueFields.Split(','); } var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType); return Json(fullPath); } return Json(result.ToDataSourceResult(request)); }