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());
}
