/// <summary> /// Gets favorits cities from FavoriteCity table. /// </summary> /// <returns></returns> public List <FavoriteCity> GetFavorites() { using (_context = new WeatherDBContext()) { return(_context.FavoriteCity.ToList()); } }
/// <summary> /// The method adds current weather to the CurrentWeather table. /// </summary> /// <param name="weather"></param> public void AddCurrentWeather(CurrentWeather weather) { using (_context = new WeatherDBContext()) { _context.CurrentWeather.Add(weather); _context.SaveChanges(); } }
/// <summary> /// Gets current weather of the city. /// </summary> /// <param name="cityKey"></param> /// <returns></returns> public List <CurrentWeather> GetCityCurrentWeather(string cityKey) { List <CurrentWeather> currentWeatherList = null; using (_context = new WeatherDBContext()) { currentWeatherList = _context.CurrentWeather.ToList(); currentWeatherList = currentWeatherList.Where(l => l.CityKey == cityKey && l.CurrentDate == DateTime.Now.Date).Select(l => l).ToList(); } return(currentWeatherList); }
/// <summary> /// Remove the city from FavoriteCity table. /// </summary> /// <param name="city"></param> /// <returns></returns> public bool DeleteFavorite(FavoriteCity city) { using (_context = new WeatherDBContext()) { FavoriteCity favorite = _context.FavoriteCity.Find(city.Id); if (favorite != null) { _context.FavoriteCity.Remove(favorite); _context.SaveChanges(); return(true); } else { return(false); } } }
/// <summary> /// The method adds city to FavoriteCity table. /// </summary> /// <param name="city"></param> /// <returns></returns> public Response AddFavorite(FavoriteCity city) { Response response = new Response(); using (_context = new WeatherDBContext()) { FavoriteCity favorite = _context.FavoriteCity.Where(l => l.Key == city.Key).Select(m => m).FirstOrDefault(); if (favorite == null) { _context.FavoriteCity.Add(city); _context.SaveChanges(); response.ErrorCode = 0; response.Message = "Favorite city was added successfully!"; } else { response.ErrorCode = 1; response.Message = "The favorite city already exists in the database !"; } } return(response); }