public static void SaveConversions(List <Conversion> conversions) { DOSMapsDataContext dataContext = new DOSMapsDataContext(); dataContext.Conversions.InsertAllOnSubmit(conversions); dataContext.SubmitChanges(); }
public static void SetCreatedCountryPercents() { // Set countries' percentages to the average of it's parts percentages DOSMapsDataContext dataContext = new DOSMapsDataContext(); List <Country> countries = (from country in dataContext.Countries where country.PrayerNeed == 0.0 join chunk in dataContext.Chunks on country.Chunk_ID equals chunk.ID join part in dataContext.Parts on country.ID equals part.Country_ID select country).ToList(); foreach (Country country in countries) { double needSum = 0.0; double resourceSum = 0.0; foreach (Part part in country.Parts) { needSum += part.PrayerNeed; resourceSum += part.PrayerResource; } country.PrayerNeed = needSum / country.Parts.Count(); country.PrayerResource = resourceSum / country.Parts.Count(); country.Chunk.PrayerNeed = country.PrayerNeed; country.Chunk.PrayerResource = country.PrayerResource; } dataContext.SubmitChanges(); }
public static void SavePrayersFor(List <PrayersFor> prayersFor) { DOSMapsDataContext dataContext = new DOSMapsDataContext(); dataContext.PrayersFors.InsertAllOnSubmit(prayersFor); dataContext.SubmitChanges(); }
public static List <Continent> GetContinents() { DOSMapsDataContext dataContext = new DOSMapsDataContext(); List <Continent> continents = (from continent in dataContext.Continents select continent).ToList(); return(continents); }
public static List <Conversion> GetConversions() { DOSMapsDataContext dataContext = new DOSMapsDataContext(); List <Conversion> conversions = (from conversion in dataContext.Conversions select conversion).ToList(); return(conversions); }
public static List <PrayersFor> GetPrayersFor() { DOSMapsDataContext dataContext = new DOSMapsDataContext(); List <PrayersFor> result = (from prayersFor in dataContext.PrayersFors select prayersFor).ToList(); return(result); }
public static List <Part> GetParts() { DOSMapsDataContext dataContext = new DOSMapsDataContext(); List <Part> result = (from part in dataContext.Parts select part).ToList(); return(result); }
public static List <Chunk> GetChunks() { DOSMapsDataContext dataContext = new DOSMapsDataContext(); List <Chunk> result = (from chunk in dataContext.Chunks select chunk).ToList(); return(result); }
public static void SaveData(List <Part> parts, List <Country> countries, List <Chunk> chunks) { DOSMapsDataContext dataContext = new DOSMapsDataContext(); dataContext.Parts.InsertAllOnSubmit(parts); dataContext.Countries.InsertAllOnSubmit(countries); dataContext.Chunks.InsertAllOnSubmit(chunks); dataContext.SubmitChanges(); }
public static Country GetCountry(Guid ID) { DOSMapsDataContext dataContext = new DOSMapsDataContext(); Country result = (from country in dataContext.Countries where country.ID == ID select country).SingleOrDefault(); return(result); }
public static Chunk GetChunk(String ID) { DOSMapsDataContext dataContext = new DOSMapsDataContext(); Chunk result = (from chunk in dataContext.Chunks where chunk.ID == ID select chunk).SingleOrDefault(); return(result); }
public static void SaveCountryName(Guid ID, String countryName, String countryCode) { DOSMapsDataContext dataContext = new DOSMapsDataContext(); Country modified = (from country in dataContext.Countries where country.ID == ID select country).SingleOrDefault(); modified.Name = countryName; modified.Code = countryCode; dataContext.SubmitChanges(); }
public static List <Chunk> GetMultis() { DOSMapsDataContext dataContext = new DOSMapsDataContext(); List <Chunk> multis = (from chunk in dataContext.Chunks where chunk.Type == 2 join country in dataContext.Countries on chunk.ID equals country.MultiChunk_ID into countries from country in countries.DefaultIfEmpty() select chunk).ToList(); return(multis); }
public static List <Country> GetCountries() { DOSMapsDataContext dataContext = new DOSMapsDataContext(); List <Country> countries = (from country in dataContext.Countries join chunk in dataContext.Chunks on country.Chunk_ID equals chunk.ID join part in dataContext.Parts on country.ID equals part.Country_ID into parts from part in parts.DefaultIfEmpty() select country).Distinct().ToList(); return(countries); }
public static void SaveMulti(String ID, List <Chunk> countryChunks, List <Country> countries) { DOSMapsDataContext dataContext = new DOSMapsDataContext(); dataContext.Countries.InsertAllOnSubmit(countries); dataContext.Chunks.InsertAllOnSubmit(countryChunks); Chunk modified = (from chunk in dataContext.Chunks where chunk.ID == ID select chunk).SingleOrDefault(); modified.MultiComplete = true; dataContext.SubmitChanges(); }