public SqlContentRepository(string workspace, string connectionString)
{
this.Workspace = workspace;
this._observerManager = new SqlObserverManager();
DataContext = new DataContext(connectionString, new RepositoryMappingSource(Workspace));
this._queryManager = new SqlQueryManager(workspace, DataContext);
}
public static FileService CreateService(ApplicationDbContext context, IConfiguration configuration)
{
var sqlManager = new SqlQueryManager(configuration);
var repositoryFileType = new EfAppRepository <TbDomFileType>(context);
var serviceDocument = new DocumentService(repositoryFileType);
var repositoryAgrs = new AgreementsRepository(context);
var repositoryFile = new EfAppRepository <TbFile>(context);
var service = new FileService(sqlManager, serviceDocument, repositoryAgrs, repositoryFile);
return(service);
}
public async Task Execute(IJobExecutionContext context)
{
var schedulerName = context.Scheduler.SchedulerName;
var scheduleName = context.Scheduler.SchedulerName;
var jobName = context.JobDetail.Key.Name;
var jobGroup = context.JobDetail.Key.Group;
var trgName = context.Trigger.Key.Name;
var trgGroup = context.Trigger.Key.Group;
var jobDataKeys = context.JobDetail.JobDataMap.GetKeys();
var customFormDataModel = new ScriptExecuterViewModel();
if (jobDataKeys.Contains(ConstantHelper.CustomData))
{
var customFormData = context.JobDetail.JobDataMap.GetString(ConstantHelper.CustomData);
customFormDataModel = JsonConvert.DeserializeObject <ScriptExecuterViewModel>(customFormData);
}
LoggerService.GetLogger(ConstantHelper.JobLog).Log(new LogItem()
{
LoggerName = ConstantHelper.JobLog,
Title = "ScriptExecuterJobDefinition Started",
Message = "ScriptExecuterJobDefinition Started",
LogItemProperties = new List <LogItemProperty>()
{
new LogItemProperty("ServiceName", ConstantHelper.JobLog),
new LogItemProperty("ScheduleName", scheduleName),
new LogItemProperty("JobName", jobName),
new LogItemProperty("JobGroup", jobGroup),
new LogItemProperty("TriggerName", trgName),
new LogItemProperty("TriggerGroup", trgGroup)
},
LogLevel = LogLevel.Info
});
if (customFormDataModel != null)
{
Stopwatch stopwatch = new Stopwatch();
stopwatch.Start();
try
{
#region Get CustomFormDataModel Props
var scriptType = customFormDataModel.ScriptType;
var scriptSource = customFormDataModel.ScriptSource;
var conStr = customFormDataModel.ConnectionString;
#endregion
#region Execute Script
switch (scriptType)
{
case ScriptType.TSql:
var res = await SqlQueryManager.ExecuteQuery(conStr, scriptSource);
LoggerService.GetLogger(ConstantHelper.JobLog).Log(new LogItem()
{
LoggerName = ConstantHelper.JobLog,
Title = $"ScriptExecuterJobDefinition Call Finished",
Message = "ScriptExecuterJobDefinition Finished",
LogItemProperties = new List <LogItemProperty>()
{
new LogItemProperty("ServiceName", ConstantHelper.JobLog),
new LogItemProperty("ScheduleName", scheduleName),
new LogItemProperty("JobName", jobName),
new LogItemProperty("JobGroup", jobGroup),
new LogItemProperty("TriggerName", trgName),
new LogItemProperty("TriggerGroup", trgGroup),
new LogItemProperty("ExecutionStatus", res),
new LogItemProperty("FormData", new { CustomFormDataModel = customFormDataModel })
},
LogLevel = LogLevel.Info
});
break;
default:
break;
}
#endregion
}
catch (Exception ex)
{
LoggerService.GetLogger(ConstantHelper.JobLog).Log(new LogItem()
{
LoggerName = ConstantHelper.JobLog,
Title = "ScriptExecuterJobDefinition Execution Error",
Message = ex.Message,
LogItemProperties = new List <LogItemProperty>()
{
new LogItemProperty("ServiceName", ConstantHelper.JobLog),
new LogItemProperty("ScheduleName", scheduleName),
new LogItemProperty("JobName", jobName),
new LogItemProperty("JobGroup", jobGroup),
new LogItemProperty("TriggerName", trgName),
new LogItemProperty("TriggerGroup", trgGroup),
new LogItemProperty("ActionName", "ExecuteQuery"),
new LogItemProperty("FormData", new { CustomFormDataModel = customFormDataModel }),
},
LogLevel = LogLevel.Error,
Exception = ex
});
}
stopwatch.Stop();
}
}
