public bool Handle(BackgroundTask task, BackgroundTaskService.BackgroundTaskLog log)
{
bool res = true;
try
{
var data = task.GetData <DatabaseUpdateTaskData>();
var sl = ServiceLocatorFactory.CreateMasterSysAdmin();
var districts = sl.DistrictService.GetDistricts();
var masterSqls = data.Sqls.Where(x => x.RunOnMaster).ToList();
var districtSqls = data.Sqls.Where(x => !x.RunOnMaster).ToList();
using (var uow = new UnitOfWork(Settings.MasterConnectionString, true))
{
foreach (var updateSql in masterSqls)
{
var cmd = uow.GetTextCommandWithParams(updateSql.Sql, new Dictionary <string, object>());
cmd.CommandTimeout = Settings.DbUpdateTimeout;
cmd.ExecuteNonQuery();
}
uow.Commit();
}
foreach (var dbServer in Settings.ChalkableSchoolDbServers)
{
using (var uow = new UnitOfWork(Settings.GetSchoolTemplateConnectionString(dbServer), true))
{
foreach (var updateSql in districtSqls)
{
var cmd = uow.GetTextCommandWithParams(updateSql.Sql, new Dictionary <string, object>());
cmd.CommandTimeout = Settings.DbUpdateTimeout;
cmd.ExecuteNonQuery();
}
uow.Commit();
}
}
var runer = new AllSchoolRunner <IEnumerable <UpdateSql> >();
if (!runer.Run(districts, districtSqls, log, ExecSql, task1 => AllSchoolRunner <IEnumerable <UpdateSql> > .TaskStatusEnum.Completed))
{
res = false;
}
}
catch (Exception ex)
{
while (ex != null)
{
log.LogError("Error during database update");
log.LogError(ex.Message);
log.LogError(ex.StackTrace);
ex = ex.InnerException;
}
res = false;
}
return(res);
}
private static string Restore(AllSchoolRunner <long> .Task task)
{
string connectionString = Settings.GetSchoolConnectionString(task.Server, "Master");
using (var uow = new UnitOfWork(connectionString, false))
{
var cmd = uow.GetTextCommandWithParams(string.Format("drop database [{0}]", task.Database),
new Dictionary <string, object>());
cmd.ExecuteNonQuery();
}
return(BackupHelper.DoImport(task.Data, task.Server, task.Database));
}
private static AllSchoolRunner <long> .TaskStatusEnum CheckStatus(AllSchoolRunner <long> .Task task)
{
var statuses = BackupHelper.CheckRequestStatus(task.TrackingGuid, task.Server);
if (statuses.Any(x => x.Status == "Failed"))
{
task.ErrorMessage = statuses.First(x => x.Status == "Failed").ErrorMessage;
return(AllSchoolRunner <long> .TaskStatusEnum.Failed);
}
if (statuses.Any(x => x.Status == "Completed"))
{
return(AllSchoolRunner <long> .TaskStatusEnum.Completed);
}
return(AllSchoolRunner <long> .TaskStatusEnum.Running);
}
private string ExecSql(AllSchoolRunner <IEnumerable <UpdateSql> > .Task task)
{
string connectionString = Settings.GetSchoolConnectionString(task.Server, task.Database);
using (var uow = new UnitOfWork(connectionString, true))
{
foreach (var updateSql in task.Data)
{
var cmd = uow.GetTextCommandWithParams(updateSql.Sql, new Dictionary <string, object>());
cmd.CommandTimeout = Settings.DbUpdateTimeout;
cmd.ExecuteNonQuery();
}
uow.Commit();
}
return(string.Empty);
}
public bool Handle(BackgroundTask task, BackgroundTaskService.BackgroundTaskLog log)
{
var sl = ServiceLocatorFactory.CreateMasterSysAdmin();
var data = task.GetData <DatabaseBackupRestoreTaskData>();
if (data.BackupMaster)
{
var c = new SqlConnection(sl.Context.MasterConnectionString);
var t = new AllSchoolRunner <long> .Task
{
Database = c.Database,
Server = c.DataSource,
Data = data.Time,
Success = false,
Completed = false
};
if (backup)
{
AllSchoolRunner <long> .Run(new List <AllSchoolRunner <long> .Task> {
t
}, x => BackupHelper.DoExport(x.Data, x.Server, x.Database), CheckStatus);
}
else
{
AllSchoolRunner <long> .Run(new List <AllSchoolRunner <long> .Task> {
t
}, Restore, CheckStatus);
}
if (!t.Success)
{
log.LogError($"Db {actionName} error: Master Database");
if (t.ErrorMessage != null)
{
log.LogError(t.ErrorMessage);
}
return(false);
}
}
string[] serversForTemplateDbs = Settings.ChalkableSchoolDbServers;
if (backup)
{
serversForTemplateDbs = serversForTemplateDbs.Take(1).ToArray();
}
foreach (var dbServer in serversForTemplateDbs)
{
var c = new SqlConnection(Settings.GetSchoolTemplateConnectionString(dbServer));
var t = new AllSchoolRunner <long> .Task
{
Database = c.Database,
Server = c.DataSource,
Data = data.Time,
Success = false,
Completed = false
};
if (backup)
{
AllSchoolRunner <long> .Run(new List <AllSchoolRunner <long> .Task> {
t
}, x => BackupHelper.DoExport(x.Data, x.Server, x.Database), CheckStatus);
}
else
{
AllSchoolRunner <long> .Run(new List <AllSchoolRunner <long> .Task> {
t
}, Restore, CheckStatus);
}
if (!t.Success)
{
log.LogError(string.Format("Db {0} error: Template Database", actionName));
if (t.ErrorMessage != null)
{
log.LogError(t.ErrorMessage);
}
return(false);
}
}
var schools = sl.DistrictService.GetDistricts();
var runer = new AllSchoolRunner <long>();
bool res;
if (backup)
{
res = runer.Run(schools, data.Time, log, t => BackupHelper.DoExport(t.Data, t.Server, t.Database), CheckStatus);
}
else
{
res = runer.Run(schools, data.Time, log, Restore, CheckStatus);
}
return(res);
}
