public void AddReviewToGame(string gameName, string reviewTitle) { using (TeamworkContext context = new TeamworkContext()) { Game game = context.Games.SingleOrDefault(g => g.Name == gameName); Review review = context.Reviews.SingleOrDefault(r => r.Name == reviewTitle); game.Reviews.Add(review); context.SaveChanges(); } }
public void AddCommentToReview(string commnetContent, string reviewTitle) { using (TeamworkContext context = new TeamworkContext()) { Comment comment = context.Comments .Where(a => a.ReviewId == null) .SingleOrDefault(c => c.Content == commnetContent); Review review = context.Reviews.SingleOrDefault(r => r.Name == reviewTitle); review.Comments.Add(comment); context.SaveChanges(); } }
public void AddGameToPublisher(string gameName, string publisherName) { using (TeamworkContext context = new TeamworkContext()) { Game game = context.Games.SingleOrDefault(g => g.Name == gameName); Publisher publisher = context.Publishers.SingleOrDefault(d => d.Name == publisherName); publisher.Games.Add(game); game.Publishers.Add(publisher); context.SaveChanges(); } }
public void AddGameToDeveloper(string gameName, string developerName) { using (TeamworkContext context = new TeamworkContext()) { Game game = context.Games.SingleOrDefault(g => g.Name == gameName); Developer developer = context.Developers.SingleOrDefault(d => d.Name == developerName); developer.Games.Add(game); game.Developers.Add(developer); context.SaveChanges(); } }
public void Log(IUseCase useCase, IApplicationActor actor, object data) { _context.UseCaseLoggers.Add(new Domain.UseCaseLogger { Actor = actor.Identity, UseCase = useCase.Name, Data = JsonConvert.SerializeObject(data), DateTime = DateTime.Now }); _context.SaveChanges(); }
public void Execute(int id) { var task = _context.Tasks.Find(id); if (task == null) { throw new EntityNotFoundException(id); } task.DeletedAt = DateTime.Now; _context.SaveChanges(); }
public void Execute(int id) { var role = _context.Roles.Find(id); if (role == null) { throw new EntityNotFoundException(id); } role.DeletedAt = DateTime.Now; _context.SaveChanges(); }
public void Execute(int id) { var project = _context.Projects.Find(id); if (project == null) { throw new EntityNotFoundException(id); } project.DeletedAt = DateTime.Now; _context.SaveChanges(); }
public void Execute(int id) { var user = _context.Users.Find(id); if (user == null) { throw new EntityNotFoundException(id); } user.DeletedAt = DateTime.Now; _context.SaveChanges(); }
public void AddComment(string content) { Comment comment = new Comment { Content = content, }; using (TeamworkContext context = new TeamworkContext()) { context.Comments.Add(comment); context.SaveChanges(); } }
public void GreateReview(string name, string content, float rating, string gameName) { Review review = new Review { Name = name, Content = content, Rating = rating, }; using (TeamworkContext context = new TeamworkContext()) { context.Reviews.Add(review); context.SaveChanges(); } }
public void GreateDeveloper(string name, string countryName, string cityName, DateTime founded) { Developer developer = new Developer { Name = name, FoundedInCountryName = countryName, FoundedInCityName = cityName, DateFounded = founded }; using (TeamworkContext context = new TeamworkContext()) { context.Developers.Add(developer); context.SaveChanges(); } }
public void RegisterUser(string username, string password, decimal money, int creditCardNumber) { using (TeamworkContext context = new TeamworkContext()) { User u = new User { Username = username, Password = password, Money = money, CreditCardNumber = creditCardNumber }; context.Users.Add(u); context.SaveChanges(); } }
public void GreatePublisher(string name, string countryName, string cityName, DateTime founded) { Publisher publisher = new Publisher { Name = name, FoundedInCountryName = countryName, FoundedInCityName = cityName, FoundedIn = founded }; using (TeamworkContext context = new TeamworkContext()) { context.Publishers.Add(publisher); context.SaveChanges(); } }
public void AddMoney(int credit, decimal money, User user) { using (TeamworkContext context = new TeamworkContext()) { User u = context.Users.Where(a => a.Username == user.Username).ToList().FirstOrDefault(); if (credit == u.CreditCardNumber) { u.Money += money; context.SaveChanges(); } else { throw new ArgumentException("Wrong credit card number."); } } }
public void GreateGame(string name, bool isSingleplayer, bool isMultiplayer, DateTime?relaseDate, GameGenre gameGender, decimal gamePrice) { Game game = new Game { Name = name, IsSingleplayer = isSingleplayer, IsMultiplayer = isMultiplayer, RelaseDate = relaseDate, GameGenre = gameGender, Price = gamePrice }; using (TeamworkContext context = new TeamworkContext()) { context.Games.Add(game); context.SaveChanges(); } }
public void BuyGame(string gameName, User currentUser) { using (TeamworkContext context = new TeamworkContext()) { Game game = context.Games.FirstOrDefault(a => a.Name == gameName); User user = context.Users.FirstOrDefault(a => a.Username == currentUser.Username); if (user.Money < game.Price) { throw new ArgumentException("You need more money to but this game."); } if (user.GamesOwned.Any(a => a.Name == game.Name)) { throw new ArgumentException($"You already own the game {game.Name}."); } user.Money -= game.Price; user.GamesOwned.Add(game); context.SaveChanges(); } }