protected void btnSave_Click(object sender, EventArgs e)
{
// Use EF to connect to SQL Server
using (fit_trackEntities db = new fit_trackEntities())
{
// Use the UserProfile Model to save the new record
UserProfile up = new UserProfile();
String UserID = Convert.ToString(User.Identity.GetUserId());
// Get the current UserProfile from the Enity Framework
up = (from objS in db.UserProfiles
where objS.UserID == UserID
select objS).FirstOrDefault();
up.FirstName = txtFirstName.Text;
up.LastName = txtLastName.Text;
up.Email = txtEmail.Text;
up.UserHeight = Convert.ToDecimal(txtHeight.Text);
up.UserWeight = Convert.ToDecimal(txtWeight.Text);
up.Age = Convert.ToInt32(txtAge.Text);
db.SaveChanges();
// Redirect to the updated Profile page
Response.Redirect("profile.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Grab username and userID from AspNet Authentication
String userName = Convert.ToString(User.Identity.GetUserName());
String userID = Convert.ToString(User.Identity.GetUserId());
lblUsername.Text = userName;
UserProfile userP = new UserProfile();
using (fit_trackEntities db = new fit_trackEntities())
{
userP = (from up in db.UserProfiles
join u in db.AspNetUsers on up.UserID equals u.Id
where up.UserID == userID
select up).FirstOrDefault();
// If user already has a profile, print the details to the screen
if (userP != null)
{
lblFirstName.Text = userP.FirstName;
lblLastName.Text = userP.LastName;
lblEmail.Text = userP.Email;
lblUserHeight.Text = Convert.ToString(userP.UserHeight);
lblUserWeight.Text = Convert.ToString(userP.UserWeight);
lblAge.Text = Convert.ToString(userP.Age);
}
// If the user doesn't have a profile yet (New User), add a new entry to the UserProfile table with their UserID
else
{
userP = new UserProfile();
userP.UserID = userID;
db.UserProfiles.Add(userP);
db.SaveChanges();
}
}
}
protected void btnExercise_Click(object sender, EventArgs e)
{
try
{
using (fit_trackEntities db = new fit_trackEntities())
{
ActivityLog d = new ActivityLog();
Int32 ActLogID = 0;
// Grab the userID from the Authentication table
String userID = Convert.ToString(User.Identity.GetUserId());
// If an Activity Log already exists (Edit), load the values for that ActLogID from the ActLog table
if (Request.QueryString["ActLogID"] != null)
{
// Get the ID from the URL
ActLogID = Convert.ToInt32(Request.QueryString["ActLogID"]);
// Get the current ActLog from the Enity Framework
d = (from objS in db.ActivityLogs
where objS.ActLogID == ActLogID
select objS).FirstOrDefault();
}
d.UserID = userID;
d.ActName = txtName.Text;
d.ActType = ddlExercise.SelectedValue;
if (ddlExercise.SelectedValue == "Cardio")
{
d.ActDistance = Convert.ToDecimal(txtDistance.Text);
d.ActDuration = Convert.ToDecimal(txtDuration.Text);
d.ActDate = DateTime.Now;
}
else if (ddlExercise.SelectedValue == "Weight Lifting")
{
d.ActReps = Convert.ToInt32(txtReps.Text);
d.ActWeight = Convert.ToInt32(txtWeight.Text);
d.ActDate = DateTime.Now;
}
// If there is no ActLog, add a new one to the DB now
if (ActLogID == 0)
{
db.ActivityLogs.Add(d);
}
db.SaveChanges();
Response.Redirect("/admin/main-menu.aspx", false);
}
}
catch (Exception ex)
{
Response.Redirect("/error.aspx");
}
}
protected void btnAddFood_Click(object sender, EventArgs e)
{
try
{
using (fit_trackEntities db = new fit_trackEntities())
{
FoodLog d = new FoodLog();
Int32 FoodLogID = 0;
String userID = Convert.ToString(User.Identity.GetUserId());
if (Request.QueryString["FoodLogID"] != null)
{
// Get the ID from the URL
FoodLogID = Convert.ToInt32(Request.QueryString["FoodLogID"]);
// Get the current FoodLog from the Enity Framework
d = (from objS in db.FoodLogs
where objS.FoodLogID == FoodLogID
select objS).FirstOrDefault();
}
d.UserID = userID;
d.Meal = ddlMeals.SelectedValue;
d.FoodName = txtFoodName.Text;
d.Calories = Convert.ToInt32(txtCalories.Text);
d.Carbs = Convert.ToInt32(txtCarbs.Text);
d.MealServingSize = Convert.ToInt32(txtServings.Text);
d.FoodGroup = ddlFoodGroup.SelectedValue;
d.Protein = Convert.ToInt32(txtProtein.Text);
d.TotalFat = Convert.ToInt32(txtFat.Text);
d.Sodium = Convert.ToInt32(txtSodium.Text);
d.FoodDate = DateTime.Now;
// If this is a new log, add log to FoodLog table
if (FoodLogID == 0)
{
db.FoodLogs.Add(d);
}
db.SaveChanges();
Response.Redirect("/admin/main-menu.aspx", false);
}
}
catch (Exception ex)
{
Response.Redirect("/error.aspx");
}
}
protected void grdFoodLog_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// Store which row was clicked
Int32 selectedRow = e.RowIndex;
// Get the selected FoodLogID using the grid's Data Key collection
Int32 FoodID = Convert.ToInt32(grdFoodLog.DataKeys[selectedRow].Values["FoodLogID"]);
try
{
// Use Entity Framework to remove the selected Food Log from the DB
using (fit_trackEntities db = new fit_trackEntities())
{
FoodLog fl = (from objF in db.FoodLogs
where objF.FoodLogID == FoodID
select objF).FirstOrDefault(); // Using First would get an error if no data comes back, FirstOrDefault won't throw an error
// Do the delete
db.FoodLogs.Remove(fl);
db.SaveChanges();
}
}
catch (Exception ex)
{
Response.Redirect("/error.aspx");
}
// Refresh the grid
GetFoodLog();
}