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())); }