public bool IsExistingReleaseNote(ReleaseNote releaseNote)
{
using (var db = new ReleaseNotesContext())
{
return(db.ReleaseNotes.Any(x => x.Version == releaseNote.Version));
}
}
public List <ReleaseNote> ReadAllRecords()
{
using (var db = new ReleaseNotesContext())
{
return(db.ReleaseNotes.AsNoTracking().ToList());
}
}
public void CreateRecord(ReleaseNote releaseNote)
{
using (var db = new ReleaseNotesContext())
{
db.ReleaseNotes.Add(releaseNote);
db.SaveChanges();
}
}
public void DeleteReleaseNote(ReleaseNote releaseNote)
{
using (var db = new ReleaseNotesContext())
{
db.Entry(new ReleaseNote {
Version = releaseNote.Version
}).State = EntityState.Deleted;
db.SaveChanges();
}
}
public bool IsCurrentVersionPreReleaes()
{
using (var db = new ReleaseNotesContext())
{
var list = db.ReleaseNotes.OrderByDescending(x => x.DateReleased).Take(1).ToList();
if (list.Count > 0)
{
return(list[0].PreRelease);
}
else
{
return(false);
}
}
}
public void UpdateReleaseNote(ReleaseNote releaseNote)
{
using (var db = new ReleaseNotesContext())
{
var record = db.ReleaseNotes.SingleOrDefault(x => x.Version == releaseNote.Version);
if (record != null)
{
record.PreRelease = releaseNote.PreRelease;
record.DateReleased = releaseNote.DateReleased;
record.PatchNote = releaseNote.PatchNote;
db.SaveChanges();
}
}
}
public ReleaseNote ReadLastReleaseNote()
{
using (var db = new ReleaseNotesContext())
{
var list = db.ReleaseNotes.AsNoTracking().OrderByDescending(x => x.DateReleased).Take(1).ToList();
if (list.Count > 0)
{
return(list[0]);
}
else
{
return new ReleaseNote()
{
Version = "0.0.0"
}
};
}
}
public _ReleaseNoteController(ReleaseNotesContext context)
{
_context = context;
}
public CommentController(ReleaseNotesContext context)
{
_context = context;
}
public CountryCodesController(ReleaseNotesContext context)
{
_context = context;
}
internal static void UpgradeDatabaseVersion2(string newDatabaseDirectory, string applicationPath)
{
var releaseNotesTable = new DataTable();
try
{
MigrationLogger("Executing database upgrade migration...");
// delete the Replays.sqlite file
string replaysSqlite = Path.Combine(newDatabaseDirectory, Properties.Settings.Default.ReplaysDbFileName);
if (File.Exists(replaysSqlite))
{
File.Delete(replaysSqlite);
}
MigrationLogger($"Deleted {replaysSqlite}");
AppDomain.CurrentDomain.SetData("DataDirectory", applicationPath); // set to legacy
using (var conn = new SQLiteConnection(ConfigurationManager.ConnectionStrings[Properties.Settings.Default.OldHeroesParserDatabaseConnName].ConnectionString))
{
conn.Open();
using (var transaction = conn.BeginTransaction())
{
// get the release notes from HeroesParserData
using (var cmd = new SQLiteCommand("SELECT * FROM ReleaseNotes", conn))
{
using (SQLiteDataAdapter adapter = new SQLiteDataAdapter(cmd))
{
adapter.Fill(releaseNotesTable);
}
}
using (var cmd = new SQLiteCommand("DROP TABLE ReleaseNotes; DROP TABLE UserSettings;", conn))
{
cmd.ExecuteNonQuery();
}
MigrationLogger("Dropped table ReleaseNotes and UserSettings");
transaction.Commit();
}
}
AppDomain.CurrentDomain.SetData("DataDirectory", newDatabaseDirectory); // set to new
using (var db = new ReleaseNotesContext())
{
foreach (DataRow row in releaseNotesTable.Rows)
{
db.Database.ExecuteSqlCommand(
"INSERT INTO ReleaseNotes VALUES (@Version, @PreRelease, @DateReleased, @PatchNote);",
new SQLiteParameter("@Version", row["Version"]),
new SQLiteParameter("@PreRelease", row["PreRelease"]),
new SQLiteParameter("@DateReleased", row["DateReleased"]),
new SQLiteParameter("@PatchNote", row["PatchNote"]));
}
MigrationLogger("Added ReleaseNotes to ReleaseNotes.sqlite");
}
// rename HeroesParserData.db to Replays.sqlite
File.Move(Path.Combine(Properties.Settings.Default.OldDatabaseFolderName, Properties.Settings.Default.Version1DatabaseName), Path.Combine(newDatabaseDirectory, Properties.Settings.Default.ReplaysDbFileName));
MigrationLogger("HeroesParserData.db moved/renamed to Replays.sqlite");
MigrationLogger("Upgrade migration completed");
}
catch (Exception)
{
MigrationLogger($"[ERROR] An error has occured during the upgrade migration");
throw;
}
}
public ConfigController(ReleaseNotesContext context)
{
_context = context;
}
