public static List <string> GetMetrics()
{
TemperatureConversionDbContext temperatureConversionAppDbContext = new TemperatureConversionDbContext();
List <string> metrics = temperatureConversionAppDbContext.Metrics.Select(m => m.Title).ToList();
return(metrics);
}
public static List <Conversion> GetConversions(User user)
{
TemperatureConversionDbContext temperatureConversionAppDbContext = new TemperatureConversionDbContext();
List <Conversion> conversions = temperatureConversionAppDbContext.Conversions.Where(c => c.User.Name == user.Name).ToList();
return(conversions);
}
public static void AddUser(User user)
{
TemperatureConversionDbContext temperatureConversionAppDbContext = new TemperatureConversionDbContext();
temperatureConversionAppDbContext.Users.Add(user);
temperatureConversionAppDbContext.SaveChanges();
}
public static List <User> GetUsers()
{
TemperatureConversionDbContext temperatureConversionAppDbContext = new TemperatureConversionDbContext();
List <User> users = temperatureConversionAppDbContext.Users.ToList();
return(users);
}
public static void RemoveConversion(int conversionId)
{
TemperatureConversionDbContext temperatureConversionAppDbContext = new TemperatureConversionDbContext();
Conversion conversion = temperatureConversionAppDbContext.Conversions.Find(conversionId);
temperatureConversionAppDbContext.Conversions.Remove(conversion);
temperatureConversionAppDbContext.SaveChanges();
}
public static void AddConversion(Conversion conversion, User user)
{
TemperatureConversionDbContext temperatureConversionAppDbContext = new TemperatureConversionDbContext();
user = temperatureConversionAppDbContext.Users.Where(u => u.Name == user.Name).First();
conversion.UserId = user.UserId;
temperatureConversionAppDbContext.Conversions.Add(conversion);
temperatureConversionAppDbContext.SaveChanges();
}