public static void Main()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion<ErisSystemContext, Data.Migrations.EfConfiguration>());
Importer.ImportCountries();
var db = new ErisSystemContext();
var date = new DateTime(1991, 01, 01);
var country = db.Countries.Find(3);
var hitman = new User();
hitman.AboutMe = "Thug life";
hitman.UserName = "******";
hitman.PasswordHash = "ASFADSFDEFE@#@$@$@ASDFAS";
hitman.DateOfBirth = date;
hitman.CountriesOfOperation.Add(country);
db.Users.AddOrUpdate(hitman);
db.SaveChanges();
var repositoryTest = new EfGenericRepository<User>(db);
var hitmen = repositoryTest.All();
foreach (var x in hitmen)
{
Console.WriteLine(x.UserName);
Console.WriteLine(x.Gender);
Console.WriteLine(x.AboutMe);
Console.WriteLine(x.DateOfBirth);
}
}
public static void Main()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion <ErisSystemContext, Data.Migrations.EfConfiguration>());
Importer.ImportCountries();
var db = new ErisSystemContext();
var date = new DateTime(1991, 01, 01);
var country = db.Countries.Find(3);
var hitman = new User();
hitman.AboutMe = "Thug life";
hitman.UserName = "******";
hitman.PasswordHash = "ASFADSFDEFE@#@$@$@ASDFAS";
hitman.DateOfBirth = date;
hitman.CountriesOfOperation.Add(country);
db.Users.AddOrUpdate(hitman);
db.SaveChanges();
var repositoryTest = new EfGenericRepository <User>(db);
var hitmen = repositoryTest.All();
foreach (var x in hitmen)
{
Console.WriteLine(x.UserName);
Console.WriteLine(x.Gender);
Console.WriteLine(x.AboutMe);
Console.WriteLine(x.DateOfBirth);
}
}
public static ICollection <Match> GetMatchesInTwentyFourHours()
{
IRepository <Match> matchesContext = new EfGenericRepository <Match>(new BetsDbContext());
var startPeriod = DateTime.Now;
var endPeriod = startPeriod.AddHours(24);
var matches = matchesContext
.All()
.Where(m =>
DateTime.Compare(m.StartDate, startPeriod) > 0 &&
DateTime.Compare(m.StartDate, endPeriod) < 0)
.ToList();
return(matches);
}
public void All_Should_ReturnEntitiesOfGivenSet()
{
// Arrange
var mockedDbContext = new Mock <ICarAdvertsSystemDbContext>();
var mockedSet = new Mock <DbSet <MockDbModel> >();
mockedDbContext.Setup(x => x.Set <MockDbModel>()).Returns(mockedSet.Object);
var repository = new EfGenericRepository <MockDbModel>(mockedDbContext.Object);
// Act
var allEntities = repository.All();
// Assert
Assert.NotNull(allEntities);
Assert.IsInstanceOf(typeof(DbSet <MockDbModel>), allEntities);
Assert.AreSame(allEntities, repository.DbSet);
}
public ActionResult NormalizeParticipantsWithDuplicatedParticipantScores()
{
var result = new StringBuilder("<p>Done! Deleted Participant scores:</p><ol>");
var problemIds = this.Data.Problems.AllWithDeleted().Select(pr => pr.Id).ToList();
foreach (var problemId in problemIds)
{
var participantScoresRepository = new EfGenericRepository <ParticipantScore>(new OjsDbContext());
var scoresMarkedForDeletion = new List <ParticipantScore>();
participantScoresRepository
.All()
.Where(ps => ps.ProblemId == problemId)
.GroupBy(p => new { p.ProblemId, p.ParticipantId })
.Where(participantScoreGroup => participantScoreGroup.Count() > 1)
.ForEach(participantScoreGroup =>
{
participantScoreGroup
.OrderByDescending(ps => ps.Points)
.ThenByDescending(ps => ps.Id)
.Skip(1)
.ForEach(ps => scoresMarkedForDeletion.Add(ps));
});
if (scoresMarkedForDeletion.Any())
{
foreach (var participantScoreForDeletion in scoresMarkedForDeletion)
{
participantScoresRepository.Delete(participantScoreForDeletion);
result.Append($@"<li>ParticipantScore with
ParticipantId: {participantScoreForDeletion.ParticipantId} and
ProblemId: {participantScoreForDeletion.ProblemId}</li>");
}
participantScoresRepository.SaveChanges();
}
}
result.Append("</ol>");
return(this.Content(result.ToString()));
}
