public void Setup()
{
_schedulerService = new DefaultJobSchedulerService();
_schedulerService.UnitOfWork = new UnitOfWork();
ISchedulerFactory sf = new StdSchedulerFactory();
((DefaultJobSchedulerService)_schedulerService).Scheduler = sf.GetScheduler();
_schedulerService.Start();
_sqlJobTrigger = new SqlJobTrigger
{
CreatedBy = "Pepe",
CreatedDate = DateTime.Now,
Enabled = true,
JobLogs = new List<JobLog>(),
JobTriggerStatus = JobTriggerStatus.NoAgendado,
XmlFormInputValues = "<prueba>Prueba</prueba>",
};
_sqlJob = new SqlJob
{
Comments = "blabla",
CreatedBy = "sdsd",
DatabaseName = "CGControlPanel3",
CreatedDate = DateTime.Now,
Deleted = false,
DeletedBy = string.Empty,
Description = "Descripcion",
IsFavorite = true,
ExecutionDays = 1,
Group = "Replicación",
Name = "Job Replicación 1",
JobType = JobType.Automatico,
InputSchemaProcedure = "wdwdsadsa",
JOB_GROUP = "wwww",
JOB_NAME = "adasas",
JobStatus = JobStatus.Scheduled,
JobStatusEnum = 1,
JobTypeEnum = 1,
Password = "******",
Logs = new List<JobLog>(),
Triggers = new List<JobTrigger>
{
_sqlJobTrigger
},
SCHED_NAME = "asdsdsa",
LastExecutionStatus = LastExecutionStatus.Success,
LastExecutionStatusEnum = 1,
ServerName = @".\SQLEXPRESS",
UserName = "******",
ExecProcedure = "OP_PROCESO_EJEMPLO_EXEC",
};
_sqlJobTrigger.Job = _sqlJob;
}
public void Setup()
{
stream = new FileStream(@"C:\test.xlsx", FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
excelReader.IsFirstRowAsColumnNames = true;
DataSet result = excelReader.AsDataSet();
ISchedulerFactory sf = new StdSchedulerFactory();
if (_schedulerService == null)
{
_schedulerService = new DefaultJobSchedulerService();
((DefaultJobSchedulerService)_schedulerService).Scheduler = sf.GetScheduler();
}
_unitOfWork = new UnitOfWork();
_schedulerService.UnitOfWork = _unitOfWork;
//_schedulerService.Resume();
_sqlJobTrigger = new SqlJobTrigger
{
CreatedBy = "Pepe",
CreatedDate = DateTime.Now,
Enabled = true,
JobTriggerStatus = JobTriggerStatus.NoAgendado,
InputFormXmlValues = "<prueba>Prueba</prueba>",
ScheduledStartExecutionDate = DateTime.Now
};
_sqlJob = new SqlJob
{
Comments = "blabla",
CreatedBy = "sdsd",
DatabaseName = "cgQuartz",
CreatedDate = DateTime.Now,
Deleted = false,
DeletedBy = string.Empty,
Description = "Descripcion",
IsFavorite = true,
Group = "Replicación",
Name = "Job Replicación 1",
JobType = JobType.Automático,
InputSchemaProcedure = "wdwdsadsa",
JobTypeEnum = 1,
Password = "******",
ServerName = @".\SQLEXPRESS",
UserName = "******",
ExecProcedure = "OP_PROCESO_QUARTZ_EXEC",
};
_sqlJobTrigger2 = new SqlJobTrigger
{
CreatedBy = "Pepe",
CreatedDate = DateTime.Now,
Enabled = true,
JobTriggerStatus = JobTriggerStatus.NoAgendado,
InputFormXmlValues = "<prueba>Prueba2</prueba>",
ScheduledStartExecutionDate = DateTime.Now
};
_sqlJobTrigger3 = new SqlJobTrigger
{
CreatedBy = "Pepe",
CreatedDate = DateTime.Now,
Enabled = true,
JobTriggerStatus = JobTriggerStatus.NoAgendado,
InputFormXmlValues = "<prueba>Prueba2</prueba>",
ScheduledStartExecutionDate = DateTime.Now
};
_sqlJobTrigger4 = new SqlJobTrigger
{
CreatedBy = "Pepe",
CreatedDate = DateTime.Now,
Enabled = true,
JobTriggerStatus = JobTriggerStatus.NoAgendado,
InputFormXmlValues = "<prueba>Prueba2</prueba>",
ScheduledStartExecutionDate = DateTime.Now
};
_sqlJobTrigger5 = new SqlJobTrigger
{
CreatedBy = "Pepe",
CreatedDate = DateTime.Now,
Enabled = true,
JobTriggerStatus = JobTriggerStatus.NoAgendado,
InputFormXmlValues = "<prueba>Prueba2</prueba>",
ScheduledStartExecutionDate = DateTime.Now
};
_sqlJobTrigger6 = new SqlJobTrigger
{
CreatedBy = "Pepe",
CreatedDate = DateTime.Now,
Enabled = true,
JobTriggerStatus = JobTriggerStatus.NoAgendado,
InputFormXmlValues = "<prueba>Prueba2</prueba>",
ScheduledStartExecutionDate = DateTime.Now
};
_sqlJob2 = new SqlJob
{
Comments = "blabla2",
CreatedBy = "sdsd2",
DatabaseName = "cgQuartz",
CreatedDate = DateTime.Now,
Deleted = false,
DeletedBy = string.Empty,
Description = "Descripcion",
IsFavorite = true,
Group = "Replicación",
Name = "Job Replicación 2",
JobType = JobType.Automático,
InputSchemaProcedure = "wdwdsadsa2",
JobTypeEnum = 1,
Password = "******",
ServerName = @".\SQLEXPRESS",
UserName = "******",
ExecProcedure = "OP_PROCESO_QUARTZ_EXEC2",
};
_sqlJob3 = new SqlJob
{
Comments = "blabla3",
CreatedBy = "sdsd3",
DatabaseName = "cgQuartz",
CreatedDate = DateTime.Now,
Deleted = false,
DeletedBy = string.Empty,
Description = "Descripcion",
IsFavorite = true,
Group = "Replicación",
Name = "Job Replicación 3",
JobType = JobType.Automático,
InputSchemaProcedure = "wdwdsadsa3",
JobTypeEnum = 1,
Password = "******",
ServerName = @".\SQLEXPRESS",
UserName = "******",
ExecProcedure = "OP_PROCESO_QUARTZ_EXEC3",
};
_sqlJob4 = new SqlJob
{
Comments = "blabla4",
CreatedBy = "sdsd4",
DatabaseName = "cgQuartz",
CreatedDate = DateTime.Now,
Deleted = false,
DeletedBy = string.Empty,
Description = "Descripcion",
IsFavorite = true,
Group = "Replicación",
Name = "Job Replicación 4",
JobType = JobType.Automático,
InputSchemaProcedure = "wdwdsadsa4",
JobTypeEnum = 1,
Password = "******",
ServerName = @".\SQLEXPRESS",
UserName = "******",
ExecProcedure = "OP_PROCESO_QUARTZ_EXEC4",
};
_sqlJob4 = new SqlJob
{
Comments = "blabla5",
CreatedBy = "sdsd5",
DatabaseName = "cgQuartz",
CreatedDate = DateTime.Now,
Deleted = false,
DeletedBy = string.Empty,
Description = "Descripcion",
IsFavorite = true,
Group = "Replicación",
Name = "Job Replicación 5",
JobType = JobType.Automático,
InputSchemaProcedure = "wdwdsadsa5",
JobTypeEnum = 1,
Password = "******",
ServerName = @".\SQLEXPRESS",
UserName = "******",
ExecProcedure = "OP_PROCESO_QUARTZ_EXEC5",
};
_sqlJob5 = new SqlJob
{
Comments = "blabla6",
CreatedBy = "sdsd6",
DatabaseName = "cgQuartz",
CreatedDate = DateTime.Now,
Deleted = false,
DeletedBy = string.Empty,
Description = "Descripcion",
IsFavorite = true,
Group = "Replicación",
Name = "Job Replicación 6",
JobType = JobType.Automático,
InputSchemaProcedure = "wdwdsadsa6",
JobTypeEnum = 1,
Password = "******",
ServerName = @".\SQLEXPRESS",
UserName = "******",
ExecProcedure = "OP_PROCESO_QUARTZ_EXEC6",
};
}
public void GetJobs_Mehtod_Should_Return_A_Job_List()
{
var schedulerService = new DefaultJobSchedulerService();
var jobs = schedulerService.GetJobs();
Assert.IsTrue(jobs.Count > 0);
}
