public UpdateTaskLogValidation(TeamworkContext context)
{
_context = context;
RuleFor(t => t.Time)
.NotEmpty()
.LessThanOrEqualTo(8);
RuleFor(t => t.Description)
.MaximumLength(200);
RuleFor(t => t.Date)
.NotEmpty()
.LessThanOrEqualTo(DateTime.Today);
RuleFor(t => t.Task)
.NotEmpty()
.WithMessage("Log has to be assigned on task.")
.DependentRules(() =>
{
RuleFor(t => t.Task)
.Must((dto, task) => _context.Tasks.Any(u => u.Id == dto.Task.Id))
.WithMessage(dto => $"Task with id:{dto.Task.Id} doesn't exist. Please, try another task id.")
.Must((dto, task) => !_context.TaskLogs.Any(u => u.TaskId != dto.Task.Id))
.WithMessage(dto => $"Task with an id:{dto.Task.Id} is already logged.");
});
}
public UpdateUserValidation(TeamworkContext context)
{
_context = context;
RuleFor(u => u.FullName)
.NotEmpty()
.MinimumLength(4)
.MaximumLength(50);
RuleFor(u => u.Username)
.NotEmpty()
.MinimumLength(4)
.MaximumLength(25)
.Must(CheckUsernameUniqueness)
.WithMessage(dto => $"'{dto.Username}' username already exists in database. Please, try another username.");
RuleFor(u => u.Password)
.NotEmpty()
.MinimumLength(5)
.MaximumLength(20);
RuleFor(u => u.Email)
.NotEmpty()
.EmailAddress();
RuleFor(u => u.Role)
.Must(CheckRoleExistance)
.WithMessage((dto) => $"Role with id:{dto.Role.Id} doesn't exist. Please, try with an existing role id.");
}
public bool DoesGameExist(string game)
{
using (TeamworkContext context = new TeamworkContext())
{
var check = context.Games.Any(g => g.Name == game);
return(check);
}
}
public List <Game> ListAllGames()
{
using (TeamworkContext context = new TeamworkContext())
{
var query = context.Games;
return(query.ToList());
}
}
public bool DoesReviewExist(string reviewTitle)
{
using (TeamworkContext context = new TeamworkContext())
{
var check = context.Reviews.Any(r => r.Name == reviewTitle);
return(check);
}
}
public bool DoesDeveloperExist(string name)
{
using (TeamworkContext context = new TeamworkContext())
{
var check = context.Developers.Any(g => g.Name == name);
return(check);
}
}
public User GetUserByCredentials(string username, string password)
{
using (TeamworkContext context = new TeamworkContext())
{
var user = context.Users.Where(u => u.Username == username).ToList().Where(u => u.Password == password).FirstOrDefault();
return(user);
}
}
public bool IsUsernameTaken(string username)
{
using (TeamworkContext context = new TeamworkContext())
{
var result = context.Users.Any(a => a.Username == username);
return(result);
}
}
public bool CheckCreditCardNumber(int number)
{
using (TeamworkContext context = new TeamworkContext())
{
var result = context.Users.Any(a => a.CreditCardNumber == number);
return(result);
}
}
public UpdateRoleValidation(TeamworkContext context)
{
_context = context;
RuleFor(dto => dto.Name)
.NotEmpty()
.Must(CheckRoleUniqueness)
.WithMessage(dto => $"'{dto.Name}' role name already exists in database. Please, try another role name.");
}
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 bool DoesTheGameHaveAnPublisher(string gameName, string publisherName)
{
using (TeamworkContext context = new TeamworkContext())
{
var check = context.Games
.SingleOrDefault(g => g.Name == gameName)
.Developers.Any(d => d.Name == publisherName);
return(check);
}
}
static void Main()
{
TeamworkContext context = new TeamworkContext();
context.Database.Initialize(true);
CommandDispatcher commandDispatcher = new CommandDispatcher();
Engine engine = new Engine(commandDispatcher);
engine.Run();
}
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 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 List <GetGameByAverageRatingDto> GetGameByAverageRating(string gameName)
{
using (TeamworkContext context = new TeamworkContext())
{
var result = context.Reviews
.Select(g => new GetGameByAverageRatingDto()
{
GameName = g.Game.Name,
Rating = g.Game.Reviews.Average(a => a.Rating)
})
.Where(g => g.GameName == gameName);
return(result.ToList());
}
}
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 List <UserInfoDto> UserInfo(User user)
{
using (TeamworkContext context = new TeamworkContext())
{
var result = context.Users
.Where(u => u.Username == user.Username)
.Select(a => new UserInfoDto()
{
Username = a.Username,
Money = a.Money,
GamesOwned = a.GamesOwned.Select(d => d.Name).ToList()
});
return(result.ToList());
}
}
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 UpdateTaskValidation(TeamworkContext context)
{
_context = context;
RuleFor(t => t.Name)
.NotEmpty()
.DependentRules(() =>
{
RuleFor(t => t.Name)
.MinimumLength(4)
.MaximumLength(80);
});
RuleFor(t => t.Description)
.MaximumLength(200);
RuleFor(t => t.StoryPoints)
.NotEmpty()
.LessThan(20);
RuleFor(t => t.Status)
.IsInEnum();
RuleFor(t => t.Priority)
.IsInEnum();
RuleFor(t => t.User)
.NotEmpty()
.WithMessage("Task has to be assigned on user.")
.DependentRules(() =>
{
RuleFor(t => t.User)
.Must(CheckUserExistence)
.WithMessage(dto => $"User with id:{dto.User.Id} doesn't exist. Please, try another user id.");
});
RuleFor(t => t.Project)
.NotEmpty()
.WithMessage("Task has to be assigned on project.")
.DependentRules(() =>
{
RuleFor(t => t.Project)
.Must(CheckProjectExistence)
.WithMessage(dto => $"Project with id:{dto.Project.Id} doesn't exist. Please, try another user id.");
});
}
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 List <GetDevelopersAndGamesDto> GetDevelopersAndGames()
{
using (TeamworkContext context = new TeamworkContext())
{
var query = context.Developers
.Select(d => new GetDevelopersAndGamesDto()
{
DeveloperName = d.Name,
FoundedInCityName = d.FoundedInCityName,
FoundedInCountryName = d.FoundedInCountryName,
DateFounded = d.DateFounded,
GamesMade = d.Games.Select(g => g.Name).ToList()
});
return(query.ToList());
}
}
public List <GetCommentsAndReviewsDto> ListReviewsAndComments(string gameName)
{
using (TeamworkContext context = new TeamworkContext())
{
var result = context.Reviews
.Select(c => new GetCommentsAndReviewsDto()
{
GameName = c.Game.Name,
ReviewTitle = c.Name,
ReviewContent = c.Content,
Comments = c.Comments.Select(g => g.Content).ToList()
})
.Where(g => g.GameName == gameName);
return(result.ToList());
}
}
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 List <GetGamesByRatingDto> GetGamesByRating(float rating)
{
using (TeamworkContext context = new TeamworkContext())
{
var result = context.Reviews
.Select(g => new GetGamesByRatingDto()
{
GameName = g.Game.Name,
ReviewTitle = g.Name,
ReviewContnet = g.Content,
Rating = g.Rating
})
.Where(g => g.Rating >= rating)
.OrderBy(r => r.Rating)
.ThenBy(r => r.GameName);
return(result.ToList());
}
}
public List <GetGamesByGenreDto> GetGamesByGenre(string genreName)
{
using (TeamworkContext context = new TeamworkContext())
{
GameGenre genre = (GameGenre)Enum.Parse(typeof(GameGenre), genreName);
var query = context.Games
.Select(g => new GetGamesByGenreDto()
{
Name = g.Name,
SP = g.IsSingleplayer,
MP = g.IsMultiplayer,
Genre = g.GameGenre
})
.Where(g => g.Genre == genre);
return(query.ToList());
}
}
