internal override long CreateRecord(ReplaysContext db, ReplayMatchTeamBan model)
{
db.ReplayMatchTeamBans.Add(model);
db.SaveChanges();
return(0);
}
internal override long UpdateRecord(ReplaysContext db, ReplayAllHotsPlayerHero model)
{
var record = db.Database.SqlQuery <ReplayAllHotsPlayerHero>(
"SELECT * FROM ReplayAllHotsPlayerHeroes WHERE PlayerId=@PlayerId AND HeroName=@HeroName LIMIT 1",
new SQLiteParameter("@PlayerId", model.PlayerId),
new SQLiteParameter("@HeroName", model.HeroName)).FirstOrDefault();
if (record != null)
{
if (model.LastUpdated > record.LastUpdated)
{
db.Database.ExecuteSqlCommand(
"UPDATE ReplayAllHotsPlayerHeroes SET IsUsable = @IsUsable, LastUpdated = @LastUpdated WHERE PlayerId=@PlayerId AND HeroName=@HeroName",
new SQLiteParameter("@IsUsable", model.IsUsable),
new SQLiteParameter("@LastUpdated", model.LastUpdated),
new SQLiteParameter("@PlayerId", model.PlayerId),
new SQLiteParameter("@HeroName", model.HeroName));
}
}
else
{
db.ReplayAllHotsPlayerHeroes.Add(model);
db.SaveChanges();
return(record.PlayerId);
}
return(0);
}
public void UpdatePlayerNotesRecord(long playerId, string notes)
{
using (var db = new ReplaysContext())
{
var currentRecord = db.ReplayAllHotsPlayers.Where(x => x.PlayerId == playerId).FirstOrDefault();
if (currentRecord != null)
{
currentRecord.Notes = notes;
db.SaveChanges();
}
}
}
