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(); }
public PartialViewResult SportDBDetail(int?id) { if (id.HasValue) { SportDatabase sportDBDetail = FoodAndSportDBService.GetSportDataById(id); SportRecord sportRecord = new SportRecord(); sportRecord.SportName = sportDBDetail.SportName; sportRecord.BurnCalories = sportDBDetail.Calories; DateTime date = (DateTime)Session["currentDate"]; sportRecord.CreateDate = date; sportRecord.Sport_Id = sportDBDetail.Sport_Id; return(PartialView(sportRecord)); } else { return(PartialView()); } }