public async Task AddProductAsync(string userId, string productId, int rating, string description)
{
var user = await _context.Users.Include(u => u.ProductDescriptions).FirstOrDefaultAsync(u => u.Id == userId).ConfigureAwait(false);
if (user is null)
{
throw new KeyNotFoundException("There is no User with such userId.");
}
if (user.ProductDescriptions.Any(x => x.ProductId == productId))
{
throw new OperationCanceledException("The Product with such productId is already exists. Try to update existing.");
}
var product = await _context.Products.FirstOrDefaultAsync(p => p.Id == productId).ConfigureAwait(false);
if (product is null)
{
throw new KeyNotFoundException("There is no Product with such productId.");
}
var userProdDescr = new UserProductDescriptionDB()
{
User = user,
Product = product,
Rating = rating,
Description = description,
Created = DateTime.UtcNow
};
_context.UserProductDescriptions.Add(userProdDescr);
await _context.SaveChangesAsync().ConfigureAwait(false);
}
public async Task SeedAsync(IList <string> prodIds)
{
await CreateUsers();
var user = AddFriendsToFirstUser();
CreateProductsAndAddThemToTheUsers();
CreateGroups();
await _context.SaveChangesAsync().ConfigureAwait(false);
async Task CreateUsers()
{
for (int i = 0; i < 10; i++)
{
var userToCreate = new UserDB
{
Id = i.ToString(),
UserName = $"UserName{i}",
Email = _faker.Internet.Email(),
EmailConfirmed = true,
Created = DateTime.UtcNow.AddDays(-15)
};
_context.Users.Add(userToCreate);
}
await _context.SaveChangesAsync().ConfigureAwait(false);
for (int i = 0; i < 10; i++)
{
await _manager.AddPasswordAsync(i.ToString(), $"{i}{i}{i}{i}{i}{i}").ConfigureAwait(false);
}
}
UserDB AddFriendsToFirstUser()
{
var user0 = _context.Users.Include(u => u.Friends).Include(u => u.ProductDescriptions.Select(d => d.Product)).First(u => u.Id == "0");
var user1 = _context.Users.Include(u => u.Friends).Include(u => u.ProductDescriptions.Select(d => d.Product)).First(u => u.Id == "1");
var user2 = _context.Users.Include(u => u.Friends).Include(u => u.ProductDescriptions.Select(d => d.Product)).First(u => u.Id == "2");
var user3 = _context.Users.Include(u => u.Friends).Include(u => u.ProductDescriptions.Select(d => d.Product)).First(u => u.Id == "3");
user0.Friends.Add(user1);
user0.Friends.Add(user2);
user0.Friends.Add(user3);
user1.Friends.Add(user0);
user0.Modified = DateTime.UtcNow.AddDays(-3);
return(user0);
}
void CreateProductsAndAddThemToTheUsers()
{
for (int i = 0; i < 7; i++)
{
var rating = _random.Next(1, 6);
var prodDescription = new UserProductDescriptionDB
{
UserId = "0",
ProductId = prodIds[i],
Rating = rating,
Description = productDescriptions[rating - 1],
Created = DateTime.UtcNow.AddDays(-2)
};
_context.UserProductDescriptions.Add(prodDescription);
_context.SaveChanges();
}
for (int i = 1; i < 10; i++)
{
foreach (var prodId in prodIds)
{
var rating = _random.Next(1, 6);
var prodDescription = new UserProductDescriptionDB
{
UserId = i.ToString(),
ProductId = prodId,
Rating = rating,
Description = productDescriptions[rating - 1],
Created = DateTime.UtcNow.AddDays(-2)
};
_context.UserProductDescriptions.Add(prodDescription);
_context.SaveChanges();
}
}
}
void CreateGroups()
{
for (int i = 0; i < 3; i++)
{
var group = new GroupDB
{
Id = Guid.NewGuid().ToString(),
Name = $"{_faker.Lorem.Word()} group",
Information = _faker.Lorem.Sentence(),
AdminId = i.ToString(),
Created = DateTime.UtcNow.AddDays(-4),
IsNotDeleted = true
};
_context.Groups.Add(group);
for (int j = 0; j < 10; j++)
{
var groupUser = new GroupUserDB
{
UserName = $"UserName{i}",
UserId = j.ToString(),
GroupId = group.Id,
IsConfirmed = true,
RightToCreateBoards = true,
Created = DateTime.UtcNow.AddDays(-1)
};
_context.GroupUsers.Add(groupUser);
}
for (int j = 0; j < 2; j++)
{
var gbName = $"Board about {_faker.Lorem.Word()}";
var groupBoard = new GroupBoardDB
{
Id = Guid.NewGuid().ToString(),
GroupId = group.Id,
CreatorId = i.ToString(),
Name = gbName,
Information = _faker.Lorem.Sentence(),
Created = DateTime.UtcNow.AddDays(-2),
IsNotDeleted = true
};
_context.GroupBoards.Add(groupBoard);
var groupProduct = new GroupProductDB
{
Id = Guid.NewGuid().ToString(),
GroupBoardId = groupBoard.Id,
Name = _faker.Commerce.ProductName(),
ProductId = prodIds[_random.Next(0, 9)],
Information = _faker.Lorem.Sentence()
};
_context.GroupProducts.Add(groupProduct);
for (int k = 0; k < 10; k++)
{
var groupComment = new GroupCommentDB
{
Id = Guid.NewGuid().ToString(),
GroupBoardId = groupBoard.Id,
CommentatorId = _random.Next(0, 10).ToString(),
Comment = _faker.Lorem.Sentence()
};
_context.GroupComments.Add(groupComment);
}
}
}
}
}
