public Dictionary<int, Country> GetItemsDictionary()
{
Dictionary<int, Country> dic;
using (var connection = new ReferenceDataEntities())
{
dic = connection.Countries.ToDictionary(k => k.Id);
}
return dic;
}
public Dictionary<int, Location> GetItemsDictionary()
{
Dictionary<int, Location> dic;
using(var connection = new ReferenceDataEntities())
{
dic = connection.Locations.ToDictionary(k => k.Id);
}
return dic;
}
public IEnumerable<Location> GetLocationsBySubdivisionId(int subdivisionId)
{
List<Location> locations;
using (var connection = new ReferenceDataEntities())
{
locations = connection.Locations.Where(x => x.SubdivisionId == subdivisionId).ToList();
}
return locations;
}
public Location GetItem(int id)
{
Location location;
using (var connection = new ReferenceDataEntities())
{
location = connection.Locations.FirstOrDefault(x => x.Id == id);
}
return location;
}
public IEnumerable<Location> GetItems()
{
List<Location> locations;
using (var connection = new ReferenceDataEntities())
{
locations = connection.Locations.ToList();
}
return locations;
}
public IEnumerable<Subdivision> GetItemsByCountryId(int countryId)
{
List<Subdivision> subdivisions;
using (var connection = new ReferenceDataEntities())
{
subdivisions = connection.Subdivisions.Where(x => x.CountryId == countryId).ToList();
}
return subdivisions;
}
public Subdivision GetItem(int id)
{
Subdivision subdivision;
using (var connection = new ReferenceDataEntities())
{
subdivision = connection.Subdivisions.FirstOrDefault(x => x.Id == id);
}
return subdivision;
}
public IEnumerable<Subdivision> GetItems()
{
List<Subdivision> subdivisions;
using (var connection = new ReferenceDataEntities())
{
subdivisions = connection.Subdivisions.ToList();
}
return subdivisions;
}
public IEnumerable<User> GetItems()
{
List<User> users;
using (var connection = new ReferenceDataEntities())
{
users = connection.Users.ToList();
}
return users;
}
public User GetItem(int id)
{
User user;
using (var connection = new ReferenceDataEntities())
{
user = connection.Users.FirstOrDefault(x => x.Id == id);
}
return user;
}
public IEnumerable<Country> GetItems()
{
List<Country> countries;
using (var connection = new ReferenceDataEntities())
{
countries = connection.Countries.ToList();
}
return countries;
}
public Country GetItem(int id)
{
Country country;
using (var connection = new ReferenceDataEntities())
{
country = connection.Countries.FirstOrDefault(x => x.Id == id);
}
return country;
}
public static void AddOrUpdate(Location location)
{
using (var connection = new ReferenceDataEntities())
{
Location oldValue = connection.Locations.FirstOrDefault(x => x.Id == location.Id);
if (oldValue != null)
{
connection.Entry(oldValue).CurrentValues.SetValues(location);
connection.SaveChanges();
}
else
{
connection.Locations.Add(location);
connection.SaveChanges();
}
}
}
public void AddOrUpdate(Country country)
{
using (var connection = new ReferenceDataEntities())
{
Country oldValue = connection.Countries.FirstOrDefault(x => x.Id == country.Id);
if (oldValue != null)
{
connection.Entry(oldValue).CurrentValues.SetValues(country);
connection.SaveChanges();
}
else
{
connection.Countries.Add(country);
connection.SaveChanges();
}
}
}
public User AddOrUpdate(User user)
{
using (var connection = new ReferenceDataEntities())
{
User oldValue = connection.Users.FirstOrDefault(x => x.Id == user.Id);
if (oldValue != null)
{
connection.Entry(oldValue).CurrentValues.SetValues(user);
connection.SaveChanges();
return null;
}
else
{
connection.Users.Add(user);
connection.SaveChanges();
return user;
}
}
}
