/// <summary>
/// Saves 'Fact' portion of record to database
/// </summary>
/// <param name="cityName"></param>
/// <param name="ctx"></param>
/// <returns></returns>
public int SaveFact(string cityName, citiesContext ctx)
{
Cities city = ctx.Cities.FirstOrDefault(c => c.Name.Equals(cityName, StringComparison.CurrentCultureIgnoreCase));
if (city == null)
{
city = new Cities
{
Name = cityName
};
ctx.SaveChanges();
}
return(city.Id);
}
/// <summary>
/// Saves a record to database
/// </summary>
/// <param name="item"></param>
public void Save(CityItem item)
{
using (citiesContext ctx = new citiesContext())
{
string[] cities = item.City.Split(" .,".ToArray(), StringSplitOptions.RemoveEmptyEntries);
foreach (string city in cities)
{
int cityId = SaveCity(city.Trim(), ctx);
ctx.Facts.Add(new Facts
{
CityId = cityId,
Value = item.Value
});
}
ctx.SaveChanges();
}
}
