public static void UpdatePopulation() { try { using (var entities = new MinistryOfInteriorEntities()) { var districts = entities.Cities .GroupBy(city => city.District_ID) .Select(city => new { id = city.FirstOrDefault().District_ID, population = city.Sum(c => c.Population), }).ToList(); districts.ForEach(district => { entities.Districts .Single(district1 => district1.ID == district.id) .Population = district.population; }); entities.SaveChanges(); } } catch (Exception e) { Logger.Error(e.Message); throw; } }
public static List <City> Get() { try { using (var entities = new MinistryOfInteriorEntities()) { return(entities.Cities.ToList()); } } catch (Exception e) { Logger.Error(e.Message); throw; } }
public static void Add(City city) { try { using (var entities = new MinistryOfInteriorEntities()) { entities.Cities.AddOrUpdate(city); entities.SaveChanges(); } } catch (Exception e) { Logger.Error(e.Message); throw; } }
public static City GetById(long id) { try { using (var entities = new MinistryOfInteriorEntities()) { return(entities.Cities .Single(city => city.ID == id)); } } catch (Exception e) { Logger.Error(e.Message); throw; } }
public static List <City> GetWithQuerySyntax() { try { using (var entities = new MinistryOfInteriorEntities()) { return((from cities in entities.Cities select cities).ToList()); } } catch (Exception e) { Logger.Error(e.Message); throw; } }
public static District GetById(long id) { try { using (var entities = new MinistryOfInteriorEntities()) { return(entities.Districts .Single(district => district.ID == id)); } } catch (Exception e) { Logger.Error(e.Message); throw; } }
public static List <City> GetByPopulation(long population) { try { using (var entities = new MinistryOfInteriorEntities()) { return(entities.Cities .Where(city => city.Population >= population) .ToList()); } } catch (Exception e) { Logger.Error(e.Message); throw; } }
public static void Delete(long id) { try { using (var entities = new MinistryOfInteriorEntities()) { var city = entities.Cities .Single(city1 => city1.ID == id); entities.Cities.Remove(city); entities.SaveChanges(); } } catch (Exception e) { Logger.Error(e.Message); throw; } }
public static void Update(long id, District districtToUpdate) { try { using (var entities = new MinistryOfInteriorEntities()) { var district = entities.Districts .Single(district1 => district1.ID == id); district.Name = districtToUpdate.Name; district.Population = districtToUpdate.Population; entities.Districts.AddOrUpdate(district); entities.SaveChanges(); } } catch (Exception e) { Logger.Error(e.Message); throw; } }
public static void Update(long id, City cityToUpdate) { try { using (var entities = new MinistryOfInteriorEntities()) { var city = entities.Cities .Single(city1 => city1.ID == id); city.Name = cityToUpdate.Name; city.Mayor = cityToUpdate.Mayor; city.Population = cityToUpdate.Population; entities.Cities.AddOrUpdate(city); entities.SaveChanges(); } } catch (Exception e) { Logger.Error(e.Message); throw; } }