protected override void Seed(MountainsContext context)
{
if (!context.Countries.Any())
{
Country bulgaria = new Country()
{
Code = "BG",
Name = "Bulgaria"
};
context.Countries.Add(bulgaria);
context.SaveChanges();
Mountain rila = new Mountain()
{
Name = "Rila",
};
context.Mountains.Add(rila);
context.SaveChanges();
bulgaria.Mountains.Add(rila);
Peak musala = new Peak()
{
Name = "Musala",
MountainId = rila.Id,
Elevation = 2925,
};
context.Peaks.Add(musala);
context.SaveChanges();
}
}
public static void Main(string[] args)
{
var context = new MountainsContext();
var mountains = context.Mountains
.Select(m => new
{
m.Name,
Countries = m.Countries.Select(c => c.CountryName),
Peaks = m.Peaks.Select(p => new
{
p.Name,
p.Elevation
})
})
.ToList();
mountains.ForEach(m =>
{
var countries = m.Countries.ToList();
Console.WriteLine("{0} in {1} with peaks:", m.Name,
string.Join(", ", countries));
m.Peaks.ToList().ForEach(p =>
{
Console.WriteLine(" {0} : {1} elevation", p.Name, p.Elevation);
});
});
}
public static void Main(string[] args)
{
var context = new MountainsContext();
var mountains = context.Mountains
.Select(m => new
{
m.Name,
Countries = m.Countries.Select(c => c.CountryName),
Peaks = m.Peaks.Select(p => new
{
p.Name,
p.Elevation
})
})
.ToList();
mountains.ForEach(m =>
{
var countries = m.Countries.ToList();
Console.WriteLine("{0} in {1} with peaks:", m.Name,
string.Join(", ", countries));
m.Peaks.ToList().ForEach(p =>
{
Console.WriteLine(" {0} : {1} elevation", p.Name, p.Elevation);
});
});
}
public static void Main()
{
using (var context = new MountainsContext())
{
var mountains = context.Mountains.Include(p => p.Peaks).Include(c => c.Countries).ToList();
foreach (var mountain in mountains)
{
Console.Write(mountain.Name);
Console.Write("; Peaks: " + string.Join(", ", mountain.Peaks.Select(m => m.Name)));
Console.WriteLine("; Countirues: " + string.Join(", ", mountain.Countries.Select(m => m.Name)));
}
}
}
private static void ImportMountain(MountainDTO mountainDTO)
{
var context = new MountainsContext();
// Parse mountain
if (mountainDTO.MountainName == null)
{
throw new Exception("Missing mountain name");
}
var mountainToImport = new Mountain {
Name = mountainDTO.MountainName
};
// Parse peaks optional
foreach (var peakDto in mountainDTO.Peaks)
{
if (peakDto.PeakName == null)
{
throw new Exception("Missing peak name");
}
if (peakDto.Elevation == null)
{
throw new Exception("Missing peak elevation");
}
mountainToImport.Peaks.Add(new Peak()
{
Name = peakDto.PeakName,
Elevation = peakDto.Elevation.GetValueOrDefault()
});
}
// Parse countries optional
foreach (var countryName in mountainDTO.Countries)
{
var country = context.Countries.FirstOrDefault(c => c.Name == countryName);
if (country == null)
{
country = new Country()
{
Code = countryName.ToUpper().Substring(0, 2),
Name = countryName
};
}
mountainToImport.Countries.Add(country);
}
context.Mountains.Add(mountainToImport);
context.SaveChanges();
}
private static void ImportMountain(MountainJson mountain)
{
var context = new MountainsContext();
if (string.IsNullOrEmpty(mountain.MountainName))
{
throw new ArgumentException("Mountain name is required.");
}
var peaks = new List <Peak>();
foreach (var peak in mountain.Peaks)
{
if (string.IsNullOrEmpty(peak.PeakName))
{
throw new ArgumentException("Peak name is required.");
}
if (peak.Elevation == null)
{
throw new ArgumentException("Peak elevation is required.");
}
var dataPeak = new Peak()
{
Name = peak.PeakName,
Elevation = (int)peak.Elevation
};
peaks.Add(dataPeak);
}
var countries = mountain.Countries
.Select(country => new Country()
{
CountryName = country,
CountryCode = country.Substring(0, 2).ToUpper()
})
.ToList();
var dataMountain = new Mountain()
{
Name = mountain.MountainName,
Countries = countries,
Peaks = peaks
};
context.Mountains.AddOrUpdate(dataMountain);
context.SaveChanges();
}
private static void AddCountryToDB(MountainDTO mountainDTO)
{
var context = new MountainsContext();
if (mountainDTO.MountainName == null)
{
throw new Exception("Mountain name is required");
}
var m = new Mountain()
{
Name = mountainDTO.MountainName
};
foreach (var peakDTO in mountainDTO.Peaks)
{
if (peakDTO.PeakName == null)
{
throw new Exception("Peak name is required");
}
if (peakDTO.Elevation == null)
{
throw new Exception("Peak elevation is required");
}
Peak peak = new Peak();
peak.Name = peakDTO.PeakName;
peak.Elevation = peakDTO.Elevation.GetValueOrDefault();
m.Peaks.Add(peak);
}
foreach (var countryName in mountainDTO.Countries)
{
var country = context.Countries.FirstOrDefault(c => c.Name == countryName);
if (country == null)
{
country = new Country()
{
Code = countryName.ToUpper().Substring(0, 2),
Name = countryName
};
}
m.Countries.Add(country);
}
context.Mountains.Add(m);
context.SaveChanges();
}
static void Main(string[] args)
{
var context = new MountainsContext();
var json = File.ReadAllText(@"..\..\mountains.json");
JavaScriptSerializer ser = new JavaScriptSerializer();
var mountains = ser.Deserialize <MountainsDto[]>(json);
foreach (var mountainsDto in mountains)
{
var mountain = new Mountain();
mountain.Name = mountainsDto.MountainName;
context.Mountains.Add(mountain);
foreach (var peakDto in mountainsDto.Peaks)
{
var peak = new Peak();
peak.Name = peakDto.PeakName;
peak.Elevation = peakDto.Elevation;
mountain.Peaks.Add(peak);
}
foreach (var countryNameDto in mountainsDto.Countries)
{
var country = context.Countries.FirstOrDefault(c => c.Name == countryNameDto);
if (country == null)
{
country = new Country()
{
Code = new String(countryNameDto.ToUpper().Take(2).ToArray()),
Name = countryNameDto
};
}
mountain.Countries.Add(country);
}
context.SaveChanges();
}
}
internal static void Main(string[] args)
{
var context = new MountainsContext();
var mountains = context.Mountains.Select(m =>
new
{
m.Name,
Countries = m.Countries.Select(c => c.Name),
Peaks = m.Peaks.Select(p => new { p.Name, p.Elevation })
});
foreach (var mountain in mountains)
{
Console.WriteLine(
"{0}, countries: {1}, peaks: {2}",
mountain.Name,
string.Join(", ", mountain.Countries),
string.Join(", ", mountain.Peaks.Select(
p => p.Name + " (elevation " + p.Elevation + ")")));
}
}
static void Main(string[] args)
{
var context = new MountainsContext();
//6.ListMountainsAndTheirCountriesAndPeaks
//var mountains = context.Mountains
// .Select(m => new
// {
// m.Name,
// Countries = m.Countries
// .Select(c => c.CountryName),
// Peaks = m.Peaks
// .Select(p => p.Name)
// });
//foreach (var mountain in mountains)
//{
// Console.WriteLine("Mountain: {0}\nCountries: {1}\nPeaks: {2}", mountain.Name, string.Join(", ", mountain.Countries),
// string.Join(", ", mountain.Peaks));
//}
}
private static void ImportMountain(JToken mountainObj)
{
var context = new MountainsContext();
var mountain = new Mountain();
// Parse mountain
if (mountainObj["mountainName"] == null)
{
throw new Exception("Missing mountain name");
}
mountain.Name = mountainObj["mountainName"].Value <string>();
// Parse peaks
var peaks = mountainObj["peaks"];
if (peaks != null)
{
foreach (var peak in peaks)
{
if (peak["peakName"] == null)
{
throw new Exception("Missing peak name");
}
string peakName = peak["peakName"].Value <string>();
if (peak["elevation"] == null)
{
throw new Exception("Missing peak elevation");
}
int elevation = peak["elevation"].Value <int>();
mountain.Peaks.Add(new Peak()
{
Name = peakName, Elevation = elevation
});
}
}
// Parse countries
var countryNames = mountainObj["countries"];
if (countryNames != null)
{
foreach (var countryName in countryNames)
{
var countryCode =
new string(countryName.Value <string>().Take(2).ToArray()).ToUpper();
var country = context.Countries.Find(countryCode);
if (country == null)
{
country = new Country()
{
Code = countryCode, Name = countryName.Value <string>()
};
}
mountain.Countries.Add(country);
}
}
// Persist the mountain in the database
context.Mountains.Add(mountain);
context.SaveChanges();
}