public virtual void SetPreference(Preference preference)
{
var check = DatabaseInstance.GetContext().Preferences.Where(x => x.UserId == preference.user_id && x.WeatherId == preference.weather_id).FirstOrDefault();
if (check == null)
{
DatabaseInstance.GetContext().Add(Mapper.Map(preference));
DatabaseInstance.GetContext().SaveChanges();
}
else
{
preference.preference_id = check.Id;
DatabaseInstance.GetContext().Update(Mapper.Map(preference));
DatabaseInstance.GetContext().SaveChanges();
}
}
public virtual void DeleteWeather(Domain.DomainEntities.Weather weather)
{
DatabaseInstance.GetContext().Remove(DatabaseInstance.GetContext().Weather.Find(weather.weather_id));
DatabaseInstance.GetContext().SaveChanges();
}
public virtual Domain.DomainEntities.Weather GetWeather(Domain.DomainEntities.Weather type)
{
return(Mapper.Map(DatabaseInstance.GetContext().Weather.Where(x => x.Type == type.type).FirstOrDefault()));
}
public virtual Domain.DomainEntities.Weather GetWeather(int id)
{
return(Mapper.Map(DatabaseInstance.GetContext().Weather.Where(x => x.Id == id).FirstOrDefault()));
}
public virtual IEnumerable <Domain.DomainEntities.Weather> GetWeather()
{
return(DatabaseInstance.GetContext().Weather.Select(x => Mapper.Map(x)));
}
public virtual void CreateWeather(Domain.DomainEntities.Weather weather)
{
DatabaseInstance.GetContext().Add(Mapper.Map(weather));
DatabaseInstance.GetContext().SaveChanges();
}
public virtual void DeletePreference(Preference preference)
{
DatabaseInstance.GetContext().Remove(DatabaseInstance.GetContext().Preferences.Find(preference.preference_id));
DatabaseInstance.GetContext().SaveChanges();
}
public virtual IEnumerable <Preference> GetPreferences(int userid)
{
return(Mapper.Map(DatabaseInstance.GetContext().Preferences.Where(x => x.UserId == userid)));
}
public virtual void Delete(User user)
{
DatabaseInstance.GetContext().Remove(DatabaseInstance.GetContext().Users.Find(user.id));
DatabaseInstance.GetContext().SaveChanges();
}
public virtual void UpdateLocation(User user)
{
DatabaseInstance.GetContext().Users.Find(user.id).Location = user.location;
DatabaseInstance.GetContext().SaveChanges();
}
public virtual User Find(string username)
{
return(Mapper.Map(DatabaseInstance.GetContext().Users.FirstOrDefault(u => u.Username == username)));
}
public virtual User Find(int userId)
{
return(Mapper.Map(DatabaseInstance.GetContext().Users.Find(userId)));
}
public virtual void Create(User user)
{
DatabaseInstance.GetContext().Add(Mapper.Map(user));
DatabaseInstance.GetContext().SaveChanges();
}
