protected void grdTasks_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            int points = 0;

            if(e.CommandName == "Complete")
            {
                //store which row was clicked
                Int32 selectedRow = Convert.ToInt32(e.CommandArgument);
                String user = User.Identity.Name;

                //get the selected task using the grid's Data Key collection
                int taskID = Convert.ToInt32(grdTasks.DataKeys[selectedRow].Values["taskID"]);

                //use EF to remove the selected task from the db
                using (ToDoDBase db = new ToDoDBase())
                {

                    ToDoTable s = (from objS in db.ToDoTables
                                   where objS.taskID == taskID
                                   select objS).FirstOrDefault();

                    if (s.priority == 0)
                        points = 5;

                    if (s.priority == 1)
                        points = 10;

                    if (s.priority == 2)
                        points = 15;

                    //do the delete
                    db.ToDoTables.Remove(s);
                    db.SaveChanges();
                }

                using (ToDoDBase db = new ToDoDBase())
                {
                    pointTracker s = (from objS in db.pointTrackers
                                      where objS.username == user
                                      select objS).FirstOrDefault();
                    if (s != null)
                    {

                        s.points += points;
                    }

                    db.SaveChanges();
                }

                //refresh the grid
                GetTasks();

            }
        }
        protected void GetPoints()
        {
            using (ToDoDBase db = new ToDoDBase())
            {

                String user = User.Identity.Name;

                //query the points table using EF and LINQ
                var points = from s in db.pointTrackers
                            select s;

                //bind the result to the gridview
                grdScores.DataSource = points.ToList();
                grdScores.DataBind();

            }
        }
        protected void GetTasks()
        {
            using (ToDoDBase db = new ToDoDBase())
            {

                String user = User.Identity.Name;

                //query the students table using EF and LINQ
                var tasks = from s in db.ToDoTables
                            where s.username == user
                               select s;

                //bind the result to the gridview
                grdTasks.DataSource = tasks.ToList();
                grdTasks.DataBind();

            }
        }
        protected void grdTasks_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            //store which row was clicked
            Int32 selectedRow = e.RowIndex;

            //get the selected StudentID using the grid's Data Key collection
            int taskID = Convert.ToInt32(grdTasks.DataKeys[selectedRow].Values["taskID"]);

            //use EF to remove the selected student from the db
            using (ToDoDBase db = new ToDoDBase())
            {

                ToDoTable s = (from objS in db.ToDoTables
                             where objS.taskID == taskID
                             select objS).FirstOrDefault();

                //do the delete
                db.ToDoTables.Remove(s);
                db.SaveChanges();
            }

            //refresh the grid
            GetTasks();
        }