//save buton event
protected void btn_Save_Click(object sender, EventArgs e)
{
using (chaodyzDBEntities1 db = new chaodyzDBEntities1())
{
Models.Task t = new Models.Task();
int TaskID = 0;
if (Request.QueryString["TaskId"] != null)
{
TaskID = Convert.ToInt32(Request.QueryString["TaskId"]);
t = (from task in db.Tasks
where task.TaskId == TaskID
select task).FirstOrDefault();
}
t.TaskName = TxtTaskName.Text;
t.TaskDueDay = Convert.ToDateTime(TxtDueDay.Text);
t.UserId = User.Identity.GetUserId();
// if there is no taskID on the query string, add this to db as a new object
if (TaskID == 0)
{
db.Tasks.Add(t);
}
db.SaveChanges();
Response.Redirect("Tasks.aspx");
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int TaskID = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["TaskId"]);
using (chaodyzDBEntities1 db = new chaodyzDBEntities1())
{
var s = (from task in db.Tasks
where task.TaskId == TaskID
select task).FirstOrDefault();
var c = from cdate in db.Calendars
where cdate.TaskId == TaskID
select cdate;
//if there is calendar info for this user, remove them first
if (c != null) {
db.Calendars.RemoveRange(c);
}
db.Tasks.Remove(s);
db.SaveChanges();
}
getTasks();
}
protected void btn_Puch_Click(object sender, EventArgs e)
{
//Get the button that raised the event
Button btn = (Button)sender;
//Get the row that contains this button
GridViewRow gvr = (GridViewRow)btn.NamingContainer;
//Get rowindex
int rowindex = gvr.RowIndex;
// get the taskId of the row that clicked
int taskID = Convert.ToInt32(GridView1.DataKeys[rowindex].Values["TaskId"]);
using (chaodyzDBEntities1 db = new chaodyzDBEntities1())
{
var c = (from cdate in db.Calendars
where cdate.TaskId == taskID
select cdate).FirstOrDefault();
// if user have punch card info, add " " before date, if not, add date
if (c != null)
{
c.TaskId = taskID;
c.date += " " + DateTime.Now.ToString("yyyy-MM-dd");
}
else
{
TimeManagerIII.Models.Calendar c2 = new TimeManagerIII.Models.Calendar();
c2.TaskId = taskID;
c2.date += DateTime.Now.ToString("yyyy-MM-dd");
db.Calendars.Add(c2);
}
db.SaveChanges();
}
}