public bool UserExists(string login)
{
using (var context = new DemoContext())
{
return context.Users.Any(u => u.Login == login);
}
}
public List<Country> GetCountries()
{
using (var context = new DemoContext())
{
return context.Countries.AsNoTracking().ToList();
}
}
public List<Province> GetProvincesByCountryName(string country)
{
using (var context = new DemoContext())
{
return context.Provinces
.AsNoTracking()
.Include(p => p.Country)
.Where(p => p.Country.Name == country)
.ToList();
}
}
public void AddUser(string login, string password, string country, string province)
{
using (var context = new DemoContext())
{
var provinceEntity = context.Provinces
.SingleOrDefault(p => p.Name == province && p.Country.Name == country);
if (provinceEntity == default(Province))
{
throw new InvalidOperationException("Missing country and province combination");
}
context.Users.Add(new User() { Login = login, Password = password, Province = provinceEntity });
context.SaveChanges();
}
}
