public async void CanUpdateAList()
{
DbContextOptions <TodoDbContext> options =
new DbContextOptionsBuilder <TodoDbContext>()
.UseInMemoryDatabase("GetTodoListName")
.Options;
using (TodoDbContext context = new TodoDbContext(options))
{
TodoList list = new TodoList();
list.ListTitle = "test";
context.TodoLists.Add(list);
context.SaveChanges();
list.ListTitle = "update";
context.TodoLists.Update(list);
context.SaveChanges();
var listContents = await context.TodoLists.FirstOrDefaultAsync(x => x.ListTitle == list.ListTitle);
Assert.Equal("update", listContents.ListTitle);
}
}
//public List<Todo> GetTodos(string filter)
//{
// var filterOn = filter.Split(',');
// var todoList = _context.Todos.Select(s => new { s.Id, s.Title }).ToList();
// return todoList;
//}
public int StoreTodo(TodoMapper mapper)
{
var newTodo = new Todo();
if (mapper.Id > 0)
{
newTodo = _context.Todos.Find(mapper.Id);
}
newTodo.Title = mapper.Title;
newTodo.Description = mapper.Description;
newTodo.Status = (TaskStatus)mapper.Status;
newTodo.Created = mapper.Created;
newTodo.Due = mapper.Due;
newTodo.Completed = mapper.Completed;
newTodo.OwnerId = 1;
if (mapper.Id == 0)
{
_context.Entry(newTodo).State = Microsoft.EntityFrameworkCore.EntityState.Added;
}
else
{
_context.Entry(newTodo).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
}
return(_context.SaveChanges());
}
// PUT api/Todo/5
public HttpResponseMessage PutTodos(int id, Todos todos)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
if (id != todos.Id)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
db.Entry(todos).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public IHttpActionResult PutTaskList(int id, TaskList taskList)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
if (id != taskList.Id)
{
return BadRequest();
}
db.Entry(taskList).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TaskListExists(id))
{
return NotFound();
}
else
{
throw;
}
}
return StatusCode(HttpStatusCode.NoContent);
}
public async void CanUpdateTodo()
{
DbContextOptions <TodoDbContext> options =
new DbContextOptionsBuilder <TodoDbContext>()
.UseInMemoryDatabase("GetTodoName")
.Options;
using (TodoDbContext context = new TodoDbContext(options))
{
Todo task = new Todo();
task.Title = "test";
context.Todos.Add(task);
context.SaveChanges();
task.Title = "update";
context.Todos.Update(task);
context.SaveChanges();
var taskTitle = await context.Todos.FirstOrDefaultAsync(x => x.Title == task.Title);
Assert.Equal("update", taskTitle.Title);
}
}
public async void CanDeleteATodo()
{
//Arrange
DbContextOptions <TodoDbContext> options =
new DbContextOptionsBuilder <TodoDbContext>()
.UseInMemoryDatabase("GetTodoName")
.Options;
using (TodoDbContext context = new TodoDbContext(options))
{
Todo task = new Todo();
task.Title = "testTodo";
context.Todos.Add(task);
context.SaveChanges();
//Act
context.Todos.Remove(task);
context.SaveChanges();
var taskTitle = await context.Todos.ToListAsync();
//Assert
Assert.DoesNotContain(task, taskTitle);
}
}
public async void CanDeleteAList()
{
//Arrange
DbContextOptions <TodoDbContext> options =
new DbContextOptionsBuilder <TodoDbContext>()
.UseInMemoryDatabase("GetTodoListName")
.Options;
using (TodoDbContext context = new TodoDbContext(options))
{
TodoList list = new TodoList();
list.Title = "testList";
context.TodoLists.Add(list);
context.SaveChanges();
//Act
context.TodoLists.Remove(list);
context.SaveChanges();
var listContents = await context.TodoLists.ToListAsync();
//Assert
Assert.DoesNotContain(list, listContents);
}
}
public IHttpActionResult PutTodo(int id, Todo todo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != todo.Id)
{
return(BadRequest());
}
db.Entry(todo).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TodoExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
/// <summary>
/// Initiate a new todo list for new user
/// </summary>
/// <param name="userName"></param>
internal static void InitiateDatabaseForNewUser(string userName)
{
using (TodoDbContext db = new TodoDbContext())
{
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 IHttpActionResult PutTodoList(int id, TodoListViewModel todoListDto)
{
if (!ModelState.IsValid)
{
return(Message(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)));
}
if (id != todoListDto.TodoListId)
{
return(StatusCode(HttpStatusCode.BadRequest));
}
TodoList todoList = todoListDto.ToEntity();
if (!String.Equals(db.Entry(todoList).Entity.UserId, User.Identity.GetUserId(), StringComparison.OrdinalIgnoreCase))
{
// Trying to modify a record that does not belong to the user
return(StatusCode(HttpStatusCode.Unauthorized));
}
db.Entry(todoList).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
return(StatusCode(HttpStatusCode.InternalServerError));
}
return(StatusCode(HttpStatusCode.OK));
}
public void Add(TodoItem todoItem)
{
if(_context.TodoItems.Find(todoItem.Id) != null)
throw new DuplicateTodoItemException
($"Duplicate id: {todoItem.Id}");
_context.TodoItems.Add(todoItem);
_context.SaveChanges();
}
public ActionResult <TodoItem> AddTodoItem(TodoItem item)
{
Task.Delay(Config.ActionDelay).Wait();
_dbContext.TodoItems.Add(item);
_dbContext.SaveChanges();
return(CreatedAtAction(nameof(GetTodoItem), new { id = item.Id }, item));
}
public void Add(TodoItem todoItem)
{
if (_context.TodoItems.FirstOrDefault(g => g.Id == todoItem.Id) != null)
{
throw new DuplicateTodoItemException($"duplicate id: {todoItem.Id}");
}
_context.TodoItems.Add(todoItem);
_context.SaveChanges();
}
public IActionResult Create(Todo todo)
{
var todoId = _dbContext.Todos.Select(x => x.Id).Max() + 1;
todo.Id = todoId;
_dbContext.Todos.Add(todo);
_dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult <Todo> Post([FromBody] Todo todo)
{
if (todo == null)
{
return(StatusCode((int)HttpStatusCode.NotAcceptable));
}
todo.Timestamp = DateTime.Now;
dbContext.Todos.Add(todo);
dbContext.SaveChanges();
return(todo);
}
public async void Add(TodoItem todoItem)
{
TodoItem ret = await _context.TodoItems.FirstOrDefaultAsync(i => i.Id.Equals(todoItem.Id));
if (ret != null)
{
throw new DuplicateTodoItemException("duplicate id: { " + todoItem.Id + "}");
}
_context.TodoItems.Add(todoItem);
_context.SaveChanges();
}
public IActionResult Create([FromBody] TodoTask task)
{
if (task == null)
{
return(BadRequest());
}
_context.TodoTasks.Add(task);
_context.SaveChanges();
return(CreatedAtRoute("get", new { id = task.TodoTaskId }, task));
}
public IActionResult Post([FromBody] TodoDTO model) => RunSafely(() =>
{
var entity = new Todo.API.Data.Todo
{
Name = model.Name,
Content = model.Name
};
_todoDbContext.Todos.Add(entity);
_todoDbContext.SaveChanges();
return(Ok());
});
public IActionResult Create([FromBody] TodoItem item)
{
if (item == null)
{
return(BadRequest());
}
_context.TodoItems.Add(item);
_context.SaveChanges();
return(CreatedAtRoute("GetTodo", new { id = item.Id }, item));
}
public IActionResult CreateList(TodoList list)
{
if (!ModelState.IsValid)
{
return(View());
}
_db.TodoLists.Add(list);
_db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
public void CreateTodo(string txt)
{
var todo = new Todo()
{
Txt = txt
};
ctx.Todos.Add(todo);
ctx.SaveChanges();
Clients.All.createdTodo(todo);
}
public ActionResult Create(string txt)
{
var todo = new Todo()
{
Txt = txt
};
db.Todos.Add(todo);
db.SaveChanges();
return(Content(JsonConvert.SerializeObject(todo), "application/json"));
}
public IHttpActionResult PostCategories(Categorie categorie)
{
if (ModelState.IsValid) // si l'état du modele est ok, càd que le tous les champs sont non nulls
{
db.Categories.Add(categorie);
db.SaveChanges();
return(Ok(categorie));
}
else
{
return(BadRequest(ModelState)); // renvoie une errueur 400
}
}
public IHttpActionResult PostCategories(Categorie categorie)
{
if (ModelState.IsValid)
{
db.Categories.Add(categorie);
db.SaveChanges();
return(Ok(categorie));
}
else
{
return(BadRequest(ModelState));
}
}
public void CreateTodo(Todos todo)
{
TodoEntity todoEntity = new TodoEntity
{
DateAdded = todo.DateAdded,
DateToCommence = todo.DateToCommence,
Description = todo.Description,
Title = todo.Title,
UserId = todo.UserId
};
todoDbContext.TodoEntities.Add(todoEntity);
todoDbContext.SaveChanges();
}
public void Add(TodoItem todoItem)
{
if (todoItem == null)
{
throw new ArgumentNullException();
}
if (_context.TodoItems.Any(t => t.Id.Equals(todoItem.Id)))
{
throw new DuplicateTodoItemException(todoItem.Id);
}
_context.TodoItems.Add(todoItem);
_context.SaveChanges();
}
private void CreateEditions()
{
var defaultEdition = _context.Editions.IgnoreQueryFilters().FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName);
if (defaultEdition == null)
{
defaultEdition = new Edition {
Name = EditionManager.DefaultEditionName, DisplayName = EditionManager.DefaultEditionName
};
_context.Editions.Add(defaultEdition);
_context.SaveChanges();
/* Add desired features to the standard edition, if wanted... */
}
}
public IHttpActionResult PostCategories(Categorie categorie)
{
// afin de verifier les models de la table crée il faut la ligne suivante
if (ModelState.IsValid)
{
db.Categories.Add(categorie);
db.SaveChanges();
return(Ok(categorie)); // return "..." permet de retourner le code d'acces du server à la connexion de la base de donnée Ok = Status 200)
}
else
{
return(BadRequest(ModelState)); //Permet de sortir l'ereur 400 dans la console web ainsi avec un resumé de l'erreure
}
}
public IActionResult OnPost()
{
_dbContext.Todos.Add(Todo);
_dbContext.SaveChanges();
return(RedirectToPage("./Index"));
}
public async Task Create_ReturnsNewlyCreatedTodoItem()
{
// Arrange
var options = new DbContextOptionsBuilder <TodoDbContext>()
.UseInMemoryDatabase(databaseName: "Create_ReturnsNewlyCreatedTodoItem")
.Options;
var context = new TodoDbContext(options);
context.Items.AddRange(
Enumerable.Range(1, 10).Select(t => new Item {
Description = "Item " + t
})
);
context.SaveChanges();
var controller = new ItemsController(context);
// Act
var result = await controller.Create(new Item { Description = "This is a new task" });
// Assert
Assert.IsType <CreatedAtRouteResult>(result);
Assert.Equal(11, context.Items.Count());
}