public virtual void CreateTask(Task task) { var context = new TaskDataContext(); context.AddObject(TaskDataContext.TaskTable, task.ToRow()); context.SaveChanges(); }
public virtual TaskList CreateList(string name, bool publicList) { var context = new TaskDataContext(); var list = new TaskList { Name = name, IsPublic = publicList }; context.AddObject(TaskDataContext.TaskListTable, list.ToRow()); context.SaveChanges(); return list; }
public virtual void DeleteTask(string listId, string taskId) { var context = new TaskDataContext(); var task = context.Tasks .Where(t => t.PartitionKey == listId && t.RowKey == taskId && true) .SingleOrDefault(); if (task != null) { context.DeleteObject(task); context.SaveChanges(); } }
public virtual void DeleteList(string listId) { var context = new TaskDataContext(); var list = context.TaskLists .Where(t => t.RowKey == listId && t.PartitionKey == listId.Substring(0, 1) && true) .SingleOrDefault(); if (list != null) { var tasks = context.Tasks .Where(t => t.PartitionKey == listId); foreach (TaskRow task in tasks) { context.DeleteObject(task); } context.DeleteObject(list); context.SaveChanges(); } }
public virtual Task GetTask(string taskId, string listId) { var context = new TaskDataContext(); var task = context.Tasks .Where(t => t.RowKey == taskId && t.PartitionKey == listId && true) .ToModel() .SingleOrDefault(); return task; }
public virtual void CreateTables() { var context = new TaskDataContext(); context.CreateTables(); }
public virtual void UpdateTask(Task task) { var context = new TaskDataContext(); var taskRow = task.ToRow(); context.AttachTo(TaskDataContext.TaskTable, taskRow, "*"); context.UpdateObject(taskRow); context.SaveChanges(); }
public virtual void UpdateList(TaskList list) { var context = new TaskDataContext(); var taskListRow = list.ToRow(); context.AttachTo(TaskDataContext.TaskListTable, taskListRow, "*"); context.UpdateObject(taskListRow); context.SaveChanges(); }
public virtual bool TablesExist() { var context = new TaskDataContext(); return context.IsTablesCreated; }
public virtual PagedTaskSource GetTasks(string listId, int pageSize, string nextPartition, string nextRowKey) { var context = new TaskDataContext(); return new PagedTaskSource(context.Tasks.Where(t => t.ListId == listId), nextPartition, nextRowKey, pageSize); }
public virtual IEnumerable<TaskList> GetTaskLists(bool includePrivate) { var context = new TaskDataContext(); var lists = context.TaskLists .Where(t => t.IsPublic == true || t.IsPublic != includePrivate); return lists.ToModel(); }
public virtual TaskList GetTaskList(string listId) { var context = new TaskDataContext(); if (this.TablesExist()) { var list = context.TaskLists .Where(t => t.RowKey == listId && t.PartitionKey == listId.Substring(0, 1) && true) .ToModel() .SingleOrDefault(); return list; } return null; }