public void DeleteDataById(int Id)
{
FoodRecord data = db.FoodRecord.Find(Id);
String username = data.Username;
DateTime date = data.CreateDate;
db.FoodRecord.Remove(data);
Save();
db.TotalCaloriesCal(date, username);
Save();
}
public void Insert(SportRecord newSportRecord)
{
var query = from p in db.SportDatabase
where ((p.Sport_Id) == newSportRecord.Sport_Id)
select p;
//choice from SportDB
SportDatabase SportDatabase = query.Single();
newSportRecord.BurnCalories = SportDatabase.Calories * newSportRecord.SportTime;
newSportRecord.SportName = SportDatabase.SportType;
db.SportRecord.Add(newSportRecord);
Save();
//use stored procedure to calculate calories spent by date
db.TotalCaloriesCal(newSportRecord.CreateDate, newSportRecord.Username);
//db.SaveChanges();
}
