public async void UpdateReadTodoInDb()
{
// Setup our database
// Set values
DbContextOptions <TodosDBContext> options = new DbContextOptionsBuilder <TodosDBContext>().UseInMemoryDatabase("DbCanUpdateTodo").Options;
using (TodosDBContext context = new TodosDBContext(options))
{
// Arrange
Todo Todo = new Todo();
Todo.Name = "Clean Room";
context.Todos.Add(Todo);
context.SaveChanges();
// Act
Todo.Name = "Fix Tire";
context.Todos.Update(Todo);
context.SaveChanges();
var TodoName = await context.Todos.FirstOrDefaultAsync();
// Assert
Assert.Equal("Fix Tire", TodoName.Name);
}
}
public async void UpdateTodoListInDb()
{
// Setup our database
// Set values
DbContextOptions <TodosDBContext> options = new DbContextOptionsBuilder <TodosDBContext>().UseInMemoryDatabase("DbCanUpdateTodoList").Options;
using (TodosDBContext context = new TodosDBContext(options))
{
// Arrange
TodoList TodoList = new TodoList();
TodoList.Name = "School";
context.TodoList.Add(TodoList);
context.SaveChanges();
// Act
TodoList.Name = "Work";
context.TodoList.Update(TodoList);
context.SaveChanges();
var TodoListName = await context.TodoList.FirstOrDefaultAsync();
// Assert
Assert.Equal("Work", TodoListName.Name);
}
}
public ActionResult Create([Bind(Include = "ID,Name,Data,Meta,Status")] Tarefas tarefas)
{
if (ModelState.IsValid)
{
db.Todo.Add(tarefas);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tarefas));
}
public ActionResult Create([Bind(Include = "ID,Name,DueDate,Attributes,Priority")] Todos todos)
{
if (ModelState.IsValid)
{
db.Todo.Add(todos);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(todos));
}
public async void DeleteTodoFromTodoListInDb()
{
// Setup our database
// Set values
DbContextOptions <TodosDBContext> options = new DbContextOptionsBuilder <TodosDBContext>().UseInMemoryDatabase("DbCanAddTodoToTodoList").Options;
using (TodosDBContext context = new TodosDBContext(options))
{
// Arrange
TodoList TodoList = new TodoList();
TodoList.Name = "School";
context.TodoList.Add(TodoList);
context.SaveChanges();
Todo Todo = new Todo();
Todo.Name = "Finish Homework";
Todo.TodoListID = TodoList.ID;
context.Todos.Add(Todo);
await context.SaveChangesAsync();
// Act
context.Todos.Remove(Todo);
await context.SaveChangesAsync();
var TodoListName = await context.TodoList.FirstOrDefaultAsync();
// Assert
Assert.Empty(TodoListName.Todos);
}
}
public ResponseData CreateTodos(Todos todos)
{
ResponseData respnonse = new ResponseData();
if (ModelState.IsValid)
{
db.Todo.Add(todos);
db.SaveChanges();
respnonse.IsSuccess = true;
respnonse.ID = todos.ID;
respnonse.ResponseMessage = "Successfully Created";
}
else
{
respnonse.IsSuccess = false;
respnonse.ResponseMessage = "Unable To Create";
}
return(respnonse);
}
