public EzCheckVersionResult(
CheckVersionResult result
)
{
ProjectToken = result.projectToken;
Warnings = new List <EzStatus>();
foreach (var item_ in result.warnings)
{
Warnings.Add(new EzStatus(item_));
}
Errors = new List <EzStatus>();
foreach (var item_ in result.errors)
{
Errors.Add(new EzStatus(item_));
}
}
public CheckVersionResult checkVersion()
{
try
{
var data = new FormUrlEncodedContent(new[]
{
new KeyValuePair <string, string>("version", form.mrtVersion)
});
var response = client.PostAsync(URL + "checkversion.php", data).Result;
string content = response.Content.ReadAsStringAsync().Result;
CheckVersionResult result = JsonConvert.DeserializeObject <CheckVersionResult>(content);
return(result);
}
catch (HttpRequestException)
{
form.showMessageBox("Je hebt een internetverbinding nodig om dit programma te kunnen gebruiken");
return(null);
}
}
// POST: /DBVersions
/// <summary>
/// Checking DB version
/// </summary>
public async Task <IActionResult> Post()
{
var lastestVersion = await _context.DBVersions.MaxAsync(p => p.VersionID);
if (lastestVersion++ < CurrentVersion)
{
while (lastestVersion <= CurrentVersion)
{
var sqlfile = $"hihapi.Sqls.Delta.v{lastestVersion}.sql";
try
{
var asmy = typeof(DBVersionsController).GetTypeInfo().Assembly;
//var resourceNames = asmy.GetManifestResourceNames();
using var stream = asmy.GetManifestResourceStream(sqlfile);
using var reader = new StreamReader(stream, Encoding.UTF8);
var strcontent = reader.ReadToEnd();
if (string.IsNullOrEmpty(strcontent))
{
throw new Exception("Empty file");
}
if (!_context.TestingMode)
{
using var dbContextTransaction = _context.Database.BeginTransaction();
var subcontents = strcontent.Split("GO");
foreach (var content in subcontents)
{
_context.Database.ExecuteSqlRaw(content);
}
dbContextTransaction.Commit();
}
else
{
_context.DBVersions.Add(new DBVersion
{
VersionID = lastestVersion,
AppliedDate = DateTime.Today
});
}
}
catch (Exception exception)
{
System.Diagnostics.Debug.WriteLine(exception.Message);
// ApplicationProvider.WriteToLog<EmbeddedResource>().Error(exception.Message);
throw new Exception($"Failed to read Embedded Resource {sqlfile}, reason: {exception.Message}");
}
++lastestVersion;
}
if (_context.TestingMode)
{
await _context.SaveChangesAsync();
}
}
var dbv = new CheckVersionResult
{
StorageVersion = CurrentVersion.ToString(),
APIVersion = Assembly.GetExecutingAssembly().GetName().Version.ToString()
};
return(Created(dbv));
}
