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; } } }