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();
}