/// <summary>
/// Iniciar una nueva lista de tareas para el usuario nuevo
/// </summary>
/// <param name="userName"></param>
private static void InitiateDatabaseForNewUser(string userName)
{
TodoItemContext db = new TodoItemContext();
TodoList todoList = new TodoList();
todoList.UserId = userName;
todoList.Title = "Mi lista de tareas 1";
todoList.Todos = new List <TodoItem>();
db.TodoLists.Add(todoList);
db.SaveChanges();
todoList.Todos.Add(new TodoItem()
{
Title = "Elemento de tarea 1", TodoListId = todoList.TodoListId, IsDone = false
});
todoList.Todos.Add(new TodoItem()
{
Title = "Elemento de tarea 2", TodoListId = todoList.TodoListId, IsDone = false
});
db.SaveChanges();
}
public void DeleteAll()
{
var objCtx = ((System.Data.Entity.Infrastructure.IObjectContextAdapter)db).ObjectContext;
objCtx.ExecuteStoreCommand("DELETE FROM TodoItems");
objCtx.ExecuteStoreCommand("DELETE FROM UserProfile");
objCtx.ExecuteStoreCommand("DELETE FROM TodoLists");
objCtx.ExecuteStoreCommand("DELETE FROM webpages_Membership");
objCtx.ExecuteStoreCommand("DELETE FROM webpages_OAuthMembership");
objCtx.ExecuteStoreCommand("DELETE FROM webpages_Roles");
objCtx.ExecuteStoreCommand("DELETE FROM webpages_UsersInRoles");
db.SaveChanges();
}
public TodoController(TodoItemContext context)
{
_context = context;
if (_context.TodoItems.Count() == 0)
{
// Create a new TodoItem if collection is empty,
// which means you can't delete all TodoItems.
_context.TodoItems.Add(new TodoItem {
Name = "Item1"
});
_context.SaveChanges();
}
}
// PUT api/Todo/5
public HttpResponseMessage PutTodoItem(int id, TodoItemDto todoItemDto)
{
if (ModelState.IsValid && id == todoItemDto.TodoItemId)
{
TodoItem todoItem = todoItemDto.ToEntity();
TodoList todoList = db.TodoLists.Find(todoItem.TodoListId);
if (todoList == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
if (todoList.UserId != User.Identity.Name)
{
// Trying to modify a record that does not belong to the user
return(Request.CreateResponse(HttpStatusCode.Unauthorized));
}
// Need to detach to avoid duplicate primary key exception when SaveChanges is called
db.Entry(todoList).State = EntityState.Detached;
db.Entry(todoItem).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public TodoController(TodoItemContext context)
{
_context = context;
if (_context.TodoItems.Count() == 0)
{
_context.TodoItems.Add(new TodoItem {
Name = "Item1"
});
_context.TodoItems.Add(new TodoItem {
Name = "Item2"
});
_context.SaveChanges();
}
}
public void UpdateState(Guid id, TodoState state)
{
using (var context = new TodoItemContext())
{
var item = context.TodoItems.FirstOrDefault(i => i.Id == id);
if (item == null)
{
throw new ArgumentException("Todo Item not found", "id");
}
item.LastModificationDate = DateTime.Now;
item.State = state;
context.SaveChanges();
}
}
/// <summary>
/// Initiate a new todo list for new user
/// </summary>
/// <param name="userName"></param>
private static void InitiateDatabaseForNewUser(string userName)
{
TodoItemContext db = new TodoItemContext();
TodoList todoList = new TodoList();
todoList.UserId = userName;
todoList.Title = "My Todo List #1";
todoList.Todos = new List<TodoItem>();
db.TodoLists.Add(todoList);
db.SaveChanges();
todoList.Todos.Add(new TodoItem() { Title = "Todo item #1", TodoListId = todoList.TodoListId, IsDone = false });
todoList.Todos.Add(new TodoItem() { Title = "Todo item #2", TodoListId = todoList.TodoListId, IsDone = false });
db.SaveChanges();
}
public TodoItem createItems(TodoItem item)
{
_context.todoItems.Add(item);
_context.SaveChanges();
return(item);
}