public async Task <IEnumerable <User> > GetAllUsers()
{
using (var context = new CitiesUsersContext())
{
return(await context.Users.ToListAsync());
}
}
public async Task <int> AddUser(UserRequestDto user)
{
using (var context = new CitiesUsersContext())
{
User newUser = new User()
{
Name = user.Name,
Email = user.Email,
Phone = user.Phone
};
context.Users.Add(newUser);
await context.SaveChangesAsync();
if (user.CitiesIds != null)
{
foreach (var item in user.CitiesIds)
{
UserCities userCities = new UserCities()
{
CityId = item,
UserId = newUser.Id
};
context.UserCities.Add(userCities);
}
await context.SaveChangesAsync();
}
return(newUser.Id);
}
}
public async Task <IEnumerable <City> > GetCitiesByUserId(int userId)
{
using (var context = new CitiesUsersContext())
{
var cityIds = await context.UserCities.Where(x => x.UserId == userId).Select(s => s.CityId).ToListAsync();
return(await context.Cities.Where(x => cityIds.Contains(x.Id)).ToListAsync());
}
}
