private void InitializeJob(Object sender, ElapsedEventArgs e) { // Verifica se o job já foi iniciado if (jobController != null) { startupTrigger.Stop(); return; } // Abre a conexão com o banco DataAccess dataAccess = DataAccess.Instance; dataAccess.MountConnection(FileResource.MapDesktopResource("DataAccess.xml"), DatabaseEnum.PrintAccounting); dataAccess.OpenConnection(); // Busca os parâmetros de execução no banco ApplicationParamDAO applicationParamDAO = new ApplicationParamDAO(dataAccess.GetConnection()); Dictionary <String, NameValueCollection> appParams = applicationParamDAO.GetParamsGroupByTask(); double interval = Double.Parse(appParams["reportMailing"]["interval"]); // Fecha a conexão com o banco dataAccess.CloseConnection(); // Cria a lista sem nenhum parâmetro ( a classe reportMailingTask não necessita parâmetros por enquanto) NameValueCollection taskParams = new NameValueCollection(); IPeriodicTask reportMailingTask = new ReportMailingTask(); jobController = new JobController(reportMailingTask, taskParams, dataAccess, interval); jobController.Start(); }
private void InitializeJob(Object sender, ElapsedEventArgs e) { // Verifica se o job já foi iniciado if (jobController != null) { startupTrigger.Stop(); return; } // Abre a conexão com o banco DataAccess dataAccess = DataAccess.Instance; dataAccess.MountConnection(FileResource.MapDesktopResource("DataAccess.xml"), DatabaseEnum.PrintAccounting); dataAccess.OpenConnection(); // Busca os parâmetros de execução no banco ApplicationParamDAO applicationParamDAO = new ApplicationParamDAO(dataAccess.GetConnection()); NameValueCollection taskParams = applicationParamDAO.GetTaskParams("printLogImport"); double interval = double.Parse(taskParams["interval"]); // Fecha a conexão com o banco dataAccess.CloseConnection(); IPeriodicTask printLogImportTask = new PrintLogImportTask(); jobController = new JobController(printLogImportTask, taskParams, dataAccess, interval); jobController.Start(); }
private void button2_Click(object sender, EventArgs e) { // Abre a conexão com o banco DataAccess dataAccess = DataAccess.Instance; dataAccess.MountConnection(FileResource.MapDesktopResource("DataAccess.xml"), DatabaseEnum.PrintAccounting); dataAccess.OpenConnection(); // Busca os parâmetros de execução no banco ApplicationParamDAO applicationParamDAO = new ApplicationParamDAO(dataAccess.GetConnection()); Dictionary <String, NameValueCollection> appParams = applicationParamDAO.GetParamsGroupByTask(); double interval = Double.Parse(appParams["reportMailing"]["interval"]); NameValueCollection taskParams = new NameValueCollection(); // Executa a tarefa ReportMailingTask task = new ReportMailingTask(); task.InitializeTaskState(taskParams, dataAccess); task.Execute(); // Fecha a conexão com o banco dataAccess.CloseConnection(); // ReportMailingController controller = new ReportMailingController(); }
/// <summary> /// Recupera a data de último acesso do banco ( tarefa = printLogImport ) /// </summary> public DateTime GetLastAccess() { ApplicationParamDAO applicationParamDAO = new ApplicationParamDAO(sqlConnection); ApplicationParam lastAccessParam = applicationParamDAO.GetParam("lastAccess", "printLogImport"); return(DateTime.Parse(lastAccessParam.value)); }
protected void Page_Load(Object sender, EventArgs e) { if (!Authentication.IsAuthenticated(Session)) { Response.Redirect("LoginPage.aspx"); } Tenant tenant = (Tenant)Session["tenant"]; if (tenant == null) { EmbedClientScript.ShowErrorMessage(this, "Sessão inválida.", true); return; } int licenseId; Boolean isNumeric = int.TryParse(Request.QueryString["licenseId"], out licenseId); if (!isNumeric) { EmbedClientScript.ShowErrorMessage(this, "Os parâmetros passados para a página não estão em um formato válido.", true); return; } // Abre a conexão com o banco DataAccess dataAccess = DataAccess.Instance; dataAccess.MountConnection(FileResource.MapWebResource(this.Page.Server, "DataAccess.xml"), DatabaseEnum.PrintAccounting); dataAccess.OpenConnection(); ApplicationParamDAO appParamDAO = new ApplicationParamDAO(dataAccess.GetConnection()); ApplicationParam urlParam = appParamDAO.GetParam("url", "webAccounting"); // Fecha a conexão com o banco dataAccess.CloseConnection(); dataAccess = null; if (urlParam == null) { EmbedClientScript.ShowErrorMessage(this, "Falha ao buscar url do sistema no banco.", true); return; } String serviceUrl = urlParam.value + "/JobRoutingService.aspx"; DateTime oneYearFromNow = DateTime.Now.AddYears(1); DateTime expirationDate = new DateTime(oneYearFromNow.Year, oneYearFromNow.Month, oneYearFromNow.Day, 0, 0, 0); this.Response.Clear(); this.Response.ContentType = "application/octet-stream"; this.Response.AddHeader("content-disposition", "attachment; filename=ProductKey.bin"); String licenseKey = LicenseKeyMaker.GenerateKey(serviceUrl, tenant.id, licenseId, expirationDate); Response.Write(licenseKey); this.Response.End(); }
/// <summary> /// Armazena a data de último acesso no banco ( tarefa = printLogImport ) /// </summary> public void SetLastAccess(DateTime date) { ApplicationParamDAO applicationParamDAO = new ApplicationParamDAO(sqlConnection); ApplicationParam lastAccessParam = applicationParamDAO.GetParam("lastAccess", "printLogImport"); lastAccessParam.value = date.ToShortDateString(); applicationParamDAO.SetParam(lastAccessParam); }
private void FinishDBAccess() { // Fecha a conexão com o banco dataAccess.CloseConnection(); dataAccess = null; // Finaliza o objeto de acesso ao banco applicationParamDAO = null; }
private void StartDBAccess() { // Abre a conexão com o banco dataAccess = DataAccess.Instance; dataAccess.MountConnection(FileResource.MapDesktopResource("DataAccess.xml"), DatabaseEnum.PrintAccounting); dataAccess.OpenConnection(); // Inicia o objeto de acesso ao banco applicationParamDAO = new ApplicationParamDAO(dataAccess.GetConnection()); }