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(); }