protected void showFood_RowDeleting(object sender, GridViewDeleteEventArgs e) { //get food log id Int32 fLogID = Convert.ToInt32(showFood.DataKeys[e.RowIndex].Values["fLogID"]); //Try block to catch any errors try { //Connect to the DB with EF using (HealthLogEntities db = new HealthLogEntities()) { //get selected log foodLog objC = (from c in db.foodLogs where c.fLogID == fLogID select c).FirstOrDefault(); //delete db.foodLogs.Remove(objC); db.SaveChanges(); //refresh grid getFoodLog(); } } //Catch any errors thrown and redirect to error page catch (Exception s) { Response.Redirect("/error.aspx"); } }
protected void getWorkoutLog() { //populate form with existing workout record Int32 workoutLogID = Convert.ToInt32(Request.QueryString["workoutLogID"]); //Try data connection, incase of errors try { //connect to db via EF using (HealthLogEntities db = new HealthLogEntities()) { //populate a workout instance with the workoutLogID from the URL parameter workoutLog s = (from objS in db.workoutLogs where objS.workoutLogID == workoutLogID select objS).FirstOrDefault(); //populate a set instance with the workoutLogID from the URL parameter setsLog q = (from objC in db.setsLogs where objC.setID == s.workoutLogID select objC).FirstOrDefault(); //map the workout properties to the form controls if we found a match if (s != null && q != null) { txtExcercise.Text = s.excercise; ddlMuscleGroup.SelectedValue = s.muscleGroup; txtDate.Text = Convert.ToString(s.wDate); ddlSets.SelectedValue = Convert.ToString(s.wSets); } } } catch (Exception R) { //If an error is thrown redirect to the error page Response.Redirect("/error.aspx"); } }
protected void getFoodLog() { //Get the userID for looking up var userStore = new UserStore <IdentityUser>(); var userManager = new UserManager <IdentityUser>(userStore); var authenticationManager = HttpContext.Current.GetOwinContext().Authentication; var userIdentity = authenticationManager.User.Identity.GetUserId(); //Try block incase any errors are thrown try { //connect with EF to the SQL server using (HealthLogEntities db = new HealthLogEntities()) { //Set sortstring String SortString = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString(); //Select the logs from foodlogs var Logs = from c in db.foodLogs where c.userID == userIdentity select new { c.fLogID, c.protein, c.carbs, c.fat, c.calories, c.foodDate, c.userID }; //If not null, display the logs if (Logs != null) { showFood.DataSource = Logs.AsQueryable().OrderBy(SortString).ToList(); showFood.DataBind(); } } } //Catch any errors therown and redirect catch (Exception r) { Response.Redirect("/error.aspx"); } }
protected void getWorkoutLog() { //Get userID for viewing based off ID var userStore = new UserStore <IdentityUser>(); var userManager = new UserManager <IdentityUser>(userStore); var authenticationManager = HttpContext.Current.GetOwinContext().Authentication; var userIdentity = authenticationManager.User.Identity.GetUserId(); //Try block incase an error is thrown try { //Connect with EF using (HealthLogEntities db = new HealthLogEntities()) { //Select the coloumns we need for the grid, and default sort String SortString = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString(); var Logs = from c in db.workoutLogs where c.userID == userIdentity select new { c.workoutLogID, c.userID, c.muscleGroup, c.excercise, c.wSets, c.wDate }; if (Logs != null) { //Bind the data to the gridview showWorkout.DataSource = Logs.AsQueryable().OrderBy(SortString).ToList(); showWorkout.DataBind(); } } } //Catch any errors and redirect to the error page catch (Exception r) { Response.Redirect("/error.aspx"); } }
protected void showWorkout_RowDeleting(object sender, GridViewDeleteEventArgs e) { //get workoutLogID Int32 workoutLogID = Convert.ToInt32(showWorkout.DataKeys[e.RowIndex].Values["workoutLogID"]); //Try block incase EF throws any errors try { //Use EF to connect to DB using (HealthLogEntities db = new HealthLogEntities()) { //get selected workout workoutLog objC = (from c in db.workoutLogs where c.workoutLogID == workoutLogID select c).FirstOrDefault(); //For loop for each set, up to potentially 5 for (int i = 0; i < 5; i++) { //Get each set with the workoutLogID we are deleting setsLog objD = (from d in db.setsLogs where d.setID == objC.workoutLogID select d).FirstOrDefault(); if (objD != null) { //Remove each set from that workout db.setsLogs.Remove(objD); db.SaveChanges(); } } //Delete the workout itself db.workoutLogs.Remove(objC); db.SaveChanges(); } } //Catch any errors and redirect catch (Exception q) { Response.Redirect("/error.aspx"); } //refresh grid getWorkoutLog(); }
protected void getFoodLog() { //populate form with existing foodlog record Int32 fLogID = Convert.ToInt32(Request.QueryString["fLogID"]); //Try block incase there are any errors try { //connect to db via EF using (HealthLogEntities db = new HealthLogEntities()) { //populate a student instance with the fLogID from the URL parameter foodLog s = (from objS in db.foodLogs where objS.fLogID == fLogID select objS).FirstOrDefault(); //map the student properties to the form controls if we found a match if (s != null) { //If editting, set the fields up txtProtein.Text = Convert.ToString(s.protein); txtFat.Text = Convert.ToString(s.fat); txtCarbs.Text = Convert.ToString(s.carbs); txtCalories.Text = Convert.ToString(s.calories); var x = Convert.ToString(s.foodDate); var q = Convert.ToDateTime(x).ToShortDateString(); txtDate.Text = q; } } } //Catch any errors thrown and redirect catch (Exception y) { Response.Redirect("/error.aspx"); } }
protected void getSetsLog() { //set variable for the ID Int32 workoutLogID = 0; //Check for query string in the URL if (Request.QueryString["workoutLogID"] != null) { //get the id from the url workoutLogID = Convert.ToInt32(Request.QueryString["workoutLogID"]); //Try block incase any errors are thrown in EF try { //Connect to EF using (HealthLogEntities db = new HealthLogEntities()) { //get the current sets for the workoutLogID from EF var w = from objC in db.setsLogs where objC.setID == workoutLogID select new { objC.setID, objC.ID, objC.setReps, objC.setWeight }; //Bind the data to the second gridview if not null if (w != null) { //Bind showSetsLog.DataSource = w.ToList(); showSetsLog.DataBind(); } } } //Catch any errors thrown and redirect to error page catch (Exception s) { Response.Redirect("/error.aspx"); } } }
protected void btnSave_Click(object sender, EventArgs e) { //Get the users ID for storing in the DB var userStore = new UserStore <IdentityUser>(); var userManager = new UserManager <IdentityUser>(userStore); var authenticationManager = HttpContext.Current.GetOwinContext().Authentication; var userIdentity = authenticationManager.User.Identity.GetUserId(); //Try statement incase an error is thrown try { //use EF to connect to SQL Server using (HealthLogEntities db = new HealthLogEntities()) { //use the Student model to save the new record workoutLog s = new workoutLog(); Int32 workoutLogID = 0; //check the querystring for an id so we can determine add / update if (Request.QueryString["workoutLogID"] != null) { //get the id from the url workoutLogID = Convert.ToInt32(Request.QueryString["workoutLogID"]); //get the current workout from EF s = (from objS in db.workoutLogs where objS.workoutLogID == workoutLogID select objS).FirstOrDefault(); } //s.XXX = XXX.text for all variables. setting them in the DB s.excercise = txtExcercise.Text; s.muscleGroup = ddlMuscleGroup.SelectedValue; s.userID = userIdentity; s.wDate = Convert.ToDateTime(txtDate.Text); s.wSets = Convert.ToInt32(ddlSets.SelectedValue); //call add only if we have no workout ID if (workoutLogID == 0) { db.workoutLogs.Add(s); } //run the update or insert db.SaveChanges(); //New set variable setsLog q = new setsLog(); Int32 setID = 0; //check to see if editting with the query string if (Request.QueryString["setID"] != null) { //get the id from the url setID = Convert.ToInt32(Request.QueryString["setID"]); //get the current student from EF q = (from objC in db.setsLogs where objC.setID == s.workoutLogID select objC).FirstOrDefault(); } //If there is no set in the url if (setID == 0) { //switch statement to add each set of weight/reps to the database depending on how many they chose switch (Convert.ToInt32(ddlSets.SelectedValue)) { case (1): q.setReps = setsControl1.getReps(); q.setWeight = setsControl1.getWeight(); q.setID = s.workoutLogID; //Add the rep(s) and weight(s) to the DB db.setsLogs.Add(q); db.SaveChanges(); break; case (2): q.setReps = setsControl1.getReps(); q.setWeight = setsControl1.getWeight(); q.setID = s.workoutLogID; //Add the rep(s) and weight(s) to the DB db.setsLogs.Add(q); db.SaveChanges(); q.setReps = setsControl2.getReps(); q.setWeight = setsControl2.getWeight(); q.setID = s.workoutLogID; //Add the rep(s) and weight(s) to the DB db.setsLogs.Add(q); db.SaveChanges(); break; case (3): q.setReps = setsControl1.getReps(); q.setWeight = setsControl1.getWeight(); q.setID = s.workoutLogID; //Add the rep(s) and weight(s) to the DB db.setsLogs.Add(q); db.SaveChanges(); q.setReps = setsControl2.getReps(); q.setWeight = setsControl2.getWeight(); q.setID = s.workoutLogID; //Add the rep(s) and weight(s) to the DB db.setsLogs.Add(q); db.SaveChanges(); q.setReps = setsControl3.getReps(); q.setWeight = setsControl3.getWeight(); q.setID = s.workoutLogID; //Add the rep(s) and weight(s) to the DB db.setsLogs.Add(q); db.SaveChanges(); break; case (4): q.setReps = setsControl1.getReps(); q.setWeight = setsControl1.getWeight(); q.setID = s.workoutLogID; //Add the rep(s) and weight(s) to the DB db.setsLogs.Add(q); db.SaveChanges(); q.setReps = setsControl2.getReps(); q.setWeight = setsControl2.getWeight(); q.setID = s.workoutLogID; //Add the rep(s) and weight(s) to the DB db.setsLogs.Add(q); db.SaveChanges(); q.setReps = setsControl3.getReps(); q.setWeight = setsControl3.getWeight(); q.setID = s.workoutLogID; //Add the rep(s) and weight(s) to the DB db.setsLogs.Add(q); db.SaveChanges(); q.setReps = setsControl4.getReps(); q.setWeight = setsControl4.getWeight(); q.setID = s.workoutLogID; //Add the rep(s) and weight(s) to the DB db.setsLogs.Add(q); db.SaveChanges(); break; case (5): q.setReps = setsControl1.getReps(); q.setWeight = setsControl1.getWeight(); q.setID = s.workoutLogID; //Add the rep(s) and weight(s) to the DB db.setsLogs.Add(q); db.SaveChanges(); q.setReps = setsControl2.getReps(); q.setWeight = setsControl2.getWeight(); q.setID = s.workoutLogID; //Add the rep(s) and weight(s) to the DB db.setsLogs.Add(q); db.SaveChanges(); q.setReps = setsControl3.getReps(); q.setWeight = setsControl3.getWeight(); q.setID = s.workoutLogID; //Add the rep(s) and weight(s) to the DB db.setsLogs.Add(q); db.SaveChanges(); q.setReps = setsControl4.getReps(); q.setWeight = setsControl4.getWeight(); q.setID = s.workoutLogID; //Add the rep(s) and weight(s) to the DB db.setsLogs.Add(q); db.SaveChanges(); q.setReps = setsControl5.getReps(); q.setWeight = setsControl5.getWeight(); q.setID = s.workoutLogID; //Add the rep(s) and weight(s) to the DB db.setsLogs.Add(q); db.SaveChanges(); break; } } //Send the user to the view workout page Response.Redirect("viewWorkout.aspx"); } } catch (System.Threading.ThreadAbortException lException) { // do nothing } //catch if an error is thrown and redirect to the error page catch (Exception T) { Response.Redirect("/error.aspx"); } }
protected void btnSave_Click(object sender, EventArgs e) { //Get USERID for the saving foreign keys var userStore = new UserStore <IdentityUser>(); var userManager = new UserManager <IdentityUser>(userStore); var authenticationManager = HttpContext.Current.GetOwinContext().Authentication; var userIdentity = authenticationManager.User.Identity.GetUserId(); //Try block incase any errors are thrown try { //use EF to connect to SQL Server using (HealthLogEntities db = new HealthLogEntities()) { //use the foodLog model to save the new record foodLog s = new foodLog(); Int32 fLogID = 0; //check the querystring for an id so we can determine add / update if (Request.QueryString["fLogID"] != null) { //get the id from the url fLogID = Convert.ToInt32(Request.QueryString["fLogID"]); //get the current student from EF s = (from objS in db.foodLogs where objS.fLogID == fLogID select objS).FirstOrDefault(); } //s.XXX = XXX.text for all variables. s.userID = userIdentity; s.fat = Convert.ToInt32(txtFat.Text); s.protein = Convert.ToInt32(txtProtein.Text); s.carbs = Convert.ToInt32(txtCarbs.Text); s.calories = Convert.ToInt32(txtCalories.Text); s.foodDate = Convert.ToDateTime(txtDate.Text); //call add only if we have no student ID if (fLogID == 0) { db.foodLogs.Add(s); } //run the update or insert db.SaveChanges(); //redirect to the updated foodlog page Response.Redirect("viewFoodLog.aspx"); } } catch (System.Threading.ThreadAbortException lException) { // do nothing } //Catch any error and redirect catch (Exception z) { Response.Redirect("/error.aspx"); } }