public static string AddFavouritesToDb(string userId, string locationKey, string place, string country, string region)
{
using (var objAccuWeatherEntities = new AccuWeatherEntitiesContext())
{
try
{
var userFavorites = new Favourite
{
UserId = userId,
LocationKey = locationKey,
Place = place,
Country = country,
Region = region
};
objAccuWeatherEntities.Favourites.Add(userFavorites);
objAccuWeatherEntities.SaveChanges();
}
catch (Exception ex) {
throw new InvalidOperationException(ex.InnerException.ToString());
}
return("Data Saved");
}
}
public static List <Favourite> GetUsersFavourites(string userId)
{
using (var objAccuWeatherEntities = new AccuWeatherEntitiesContext())
{
try
{
var list = objAccuWeatherEntities.Favourites;
List <Favourite> userList = new List <Favourite>();
foreach (var item in list)
{
if (item.UserId == userId)
{
userList.Add(item);
}
}
return(userList);
}
catch (Exception ex)
{
throw new InvalidOperationException(ex.InnerException.ToString());
}
}
}