コード例 #1
0
        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");
            }
        }
コード例 #2
0
        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();
        }
コード例 #3
0
        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");
            }
        }