public void deleteUser(User user)
{
using (var db = new InfoFoodContext())
{
db.Users.Remove(user);
db.SaveChanges();
}
}
public User getUser(string id)
{
using (var db = new InfoFoodContext())
{
var user = db.Users.FirstOrDefault(a => a.UserId == id);
return(user);
}
}
public void addUser(User user)
{
using (var db = new InfoFoodContext())
{
if (getUser(user.UserId) != null)
{
MessageBox.Show("user already exists");
return;
}
db.Users.Add(user); // adds the user to the DbSet in memory
db.WeekComleteWeightInfos.Add(new WeekComleteWeightInfo(user.Id, user.UserId, user.Weight, user.DateOfWeight));
db.SaveChanges(); // commits the changes to the database
}
}
public List <KeyValuePair <string, double> > getGraphData(string id)
{
using (var db = new InfoFoodContext())
{
List <KeyValuePair <string, double> > list = new List <KeyValuePair <string, double> >();
var result = (from c in db.WeekComleteWeightInfos
where c.UserId == id
select new TempData
{
dataOfWeight = c.CurrentDate,
weight = c.WeightNow
}).ToList();
foreach (TempData i in result)
{
list.Add(new KeyValuePair <string, double>(i.dataOfWeight, i.weight));
}
return(list);
}
}
public void updateUser(User user)
{
using (var db = new InfoFoodContext())
{
var updaeUser = db.Users.FirstOrDefault(a => a.UserId == user.UserId);
if (user.DateOfWeight != updaeUser.DateOfWeight)
{
db.WeekComleteWeightInfos.Add(new WeekComleteWeightInfo(user.Id, user.UserId, user.Weight, user.DateOfWeight));
}
db.Users.Find(updaeUser.Id).Height = user.Height;
db.Users.Find(updaeUser.Id).Weight = user.Weight;
db.Users.Find(updaeUser.Id).Name = user.Name;
db.Users.Find(updaeUser.Id).DateOfBirth = user.DateOfBirth;
db.Users.Find(updaeUser.Id).DateOfWeight = user.DateOfWeight;
db.Users.Find(updaeUser.Id)._gender = user._gender;
db.Users.Find(updaeUser.Id)._mood = user._mood;
db.Users.Find(updaeUser.Id)._familyStatus = user._familyStatus;
db.Users.Find(updaeUser.Id)._activity = user._activity;
db.SaveChanges();
}
}
