public ActionResult Create([Bind(Include = "Id,UserId,CaloriesBurnt1,Date")] CaloriesBurnt caloriesBurnt)
{
if (ModelState.IsValid)
{
SqlConnection con1 = new SqlConnection("Data Source=(LocalDb)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Authentication.mdf;Integrated Security=True");
DataTable dt = new DataTable();
SqlCommand myCommand = new SqlCommand("SELECT TOP 1 Id FROM CaloriesBurnt ORDER BY Id DESC", con1);
con1.Open();
SqlDataAdapter da = new SqlDataAdapter(myCommand);
////replace with userid from email id
da.Fill(dt);
if (dt.Rows.Count > 0)
{
caloriesBurnt.Id = Convert.ToInt32(dt.Rows[0]["id"]) + 1;
}
caloriesBurnt.UserId = User.Identity.GetUserId();
//}
//userDetail.UserId = dt.Rows[0].Id;
con1.Close();
da.Dispose();
db.CaloriesBurnts.Add(caloriesBurnt);
db.SaveChanges();
TempData["success"] = "Calories Burnt has been added";
return(Redirect("../CaloriesEatens/Index"));
//return RedirectToAction("Index");
}
return(View(caloriesBurnt));
}
public ActionResult DeleteConfirmed(int id)
{
CaloriesBurnt caloriesBurnt = db.CaloriesBurnts.Find(id);
db.CaloriesBurnts.Remove(caloriesBurnt);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
CaloriesBurnt caloriesBurnt = db.CaloriesBurnts.Find(id);
db.CaloriesBurnts.Remove(caloriesBurnt);
db.SaveChanges();
TempData["success"] = "Calories Burnt has been deleted";
return(Redirect("../CaloriesEatens/Index"));
}
public ActionResult Edit([Bind(Include = "Id,UserId,CaloriesBurnt1,Date")] CaloriesBurnt caloriesBurnt)
{
if (ModelState.IsValid)
{
db.Entry(caloriesBurnt).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(caloriesBurnt));
}
public ActionResult Create([Bind(Include = "Id,UserId,CaloriesBurnt1")] CaloriesBurnt caloriesBurnt)
{
if (ModelState.IsValid)
{
db.CaloriesBurnts.Add(caloriesBurnt);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(caloriesBurnt));
}
// GET: CaloriesBurnts/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CaloriesBurnt caloriesBurnt = db.CaloriesBurnts.Find(id);
if (caloriesBurnt == null)
{
return(HttpNotFound());
}
return(View(caloriesBurnt));
}
public ActivityHeaderViewModel(ActivityHeader header, List <IDispersionSpan> dispersion)
{
AthleteName = header.AthleteName;
Sport = header.Sport;
Dispersion = dispersion;
LastPointTime = header.LastPointTime;
Duration = header.Duration;
DistanceInMeters = header.DistanceInMeters;
CaloriesBurnt = header.CaloriesBurnt;
AverageHeartRate = header.AverageHeartRate;
MaximumHeartRate = header.MaximumHeartRate;
MaximumSpeed = header.MaximumSpeed;
DisplayableCaloriesBurnt = CaloriesBurnt == 0 ? AppResources.NoValue : CaloriesBurnt.ToString();
DisplayableStartTime = LastPointTime.ToLocalTime().ToSmartShortDate();
DisplayableDistance = (DistanceInMeters / 1000f).ToString("0.00");
DisplayableTimeSpan = $"{Duration:h\\:mm}";
DisplayableAverageSpeed = $"{((DistanceInMeters / 1000f) / Duration.TotalHours):0.0}";
DisplayableAverageHeartRate =
AverageHeartRate == null ? AppResources.NoValue : AverageHeartRate.Value.ToString();
}
