public static void DeleteQueue(ToDoTask task)
{
var query = new TableQuery<TableEntity>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, task.Id.ToString(CultureInfo.InvariantCulture)));
var res = TodoTaskTable.ExecuteQuery(query);
if (res.Any())
{
TodoTaskTable.Execute(TableOperation.Delete(res.First()));
}
}
public static void AddToQueue(ToDoTask task)
{
var taskEntity = new TableEntity()
{
PartitionKey = task.Id.ToString(CultureInfo.InvariantCulture),
RowKey = string.Format("{0:D19}",task.Due.Ticks)
};
TodoTaskTable.Execute(TableOperation.Insert(taskEntity));
}
public ActionResult AddTask(int projectId, string content, string due)
{
if (!User.Identity.IsAuthenticated) return Redirect(_client.OAuthCheckUrl());
ToDoProject project =
entities.ToDoProjects.SingleOrDefault(m => m.Id == projectId && m.UserName == User.Identity.Name);
if (project != null)
{
ToDoTask task = new ToDoTask();
task.Content = content;
task.Due = DateTime.Parse(due).ToUniversalTime();
task.Color = 0;
task.ProjectId = projectId;
project.ToDoTasks.Add(task);
entities.SaveChanges();
ToDoTaskQueue.AddToQueue(task);
return Json(new { code = 0, data = new { Id = task.Id, Content = task.Content, Color = task.Color, ProjectId = task.ProjectId, Due = task.Due.ToString("yyyy/MM/dd HH:mm:ss UTC") } }, JsonRequestBehavior.AllowGet);
}
return Json(new { code = 1 }, JsonRequestBehavior.AllowGet);
}
protected void HandleDoubleClick(object sender, MouseButtonEventArgs e)
{
ToDoTask x = ((ListViewItem)sender).Content as ToDoTask;
List.SelectedTask(x);
}
public static void UpdateQueue(ToDoTask task)
{
DeleteQueue(task);
AddToQueue(task);
}
public ActionResult EditTask(ToDoTask task)
{
if (!User.Identity.IsAuthenticated) return Redirect(_client.OAuthCheckUrl());
ToDoTask t = entities.ToDoTasks.SingleOrDefault(m => m.Id == task.Id);
if (t != null && t.ToDoProject.UserName == User.Identity.Name)
{
if (Request.Params["Content"] != null) t.Content = task.Content;
if (Request.Params["Color"] != null) t.Color = task.Color;
if (Request.Params["Due"] != null) t.Due = task.Due.ToUniversalTime();
entities.SaveChanges();
if (task.Color < 100)
{
ToDoTaskQueue.UpdateQueue(t);
}
else
{
ToDoTaskQueue.DeleteQueue(t);
}
return Json(new { code = 0, data = new { Id = t.Id, Content = t.Content, Color = t.Color, ProjectId = t.ProjectId, Due = t.Due.ToString("yyyy/MM/dd HH:mm:ss UTC") } }, JsonRequestBehavior.AllowGet);
}
return Json(new { code = 1 }, JsonRequestBehavior.AllowGet);
}
