public void Create(CreateTaskViewModel task)
{
var entity = createTaskViewModelToTask(task);
_context.Tasks.Add(entity);
_context.SaveChanges();
}
public RegisterResponse Register(RegisterRequest registerRequest)
{
RegisterResponse response = new RegisterResponse();
if (string.IsNullOrWhiteSpace(registerRequest.Username))
{
response.Error = "Username is empty";
return(response);
}
if (string.IsNullOrWhiteSpace(registerRequest.Password))
{
response.Error = "Password is empty";
return(response);
}
User user;
if (context.Users.Any())
{
user = context.Users.FirstOrDefault(p => p.Name.ToLower() == registerRequest.Username.ToLower());
if (user != null)
{
response.Error = "User already exists";
return(response);
}
}
user = new User();
user.Name = registerRequest.Username;
user.Password = registerRequest.Password;
user.Token = Guid.NewGuid().ToString();
context.Entry(user).State = EntityState.Added;
context.SaveChanges();
response.Token = user.Token;
return(response);
}
public IHttpActionResult PutAspNetUser(string id, AspNetUser aspNetUser)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != aspNetUser.Id)
{
return(BadRequest());
}
db.Entry(aspNetUser).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!AspNetUserExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async void ToDoDeleteTest()
{
DbContextOptions <ToDoDbContext> options =
new DbContextOptionsBuilder <ToDoDbContext>()
.UseInMemoryDatabase("todoDelete")
.Options;
using (ToDoDbContext context = new ToDoDbContext(options))
{
//CREATE
//Arrange
ToDo taskOne = new ToDo();
taskOne.Name = "Finish homework";
taskOne.Completed = false;
context.ToDos.Add(taskOne);
context.SaveChanges();
//READ
var myTask = await context.ToDos.FirstOrDefaultAsync(t => t.Name == taskOne.Name);
context.ToDos.Remove(myTask);
context.SaveChanges();
var deletedTask = await context.ToDos.FirstOrDefaultAsync(t => t.Name == myTask.Name);
Assert.True(deletedTask == null);
}
}
public async void ToDoListUpdateTest()
{
DbContextOptions <ToDoDbContext> options =
new DbContextOptionsBuilder <ToDoDbContext>()
.UseInMemoryDatabase("todoListUpdate")
.Options;
using (ToDoDbContext context = new ToDoDbContext(options))
{
//CREATE
//Arrange
ToDoList myList = new ToDoList();
myList.Name = "new list";
context.ToDoList.Add(myList);
context.SaveChanges();
//READ
var list = await context.ToDoList.FirstOrDefaultAsync(t => t.Name == myList.Name);
list.Name = "another name";
context.Update(list);
context.SaveChanges();
var newList = await context.ToDoList.FirstOrDefaultAsync(t => t.Name == myList.Name);
Assert.Equal("another name", newList.Name);
}
}
public ToDoItemDTO CreateItemInList(Guid listId, ToDoItemDTO itemDTO)
{
_logger.LogInformation("ToDoItemService -> Executing CreateItemInList()");
var toDoList = _context.ToDoLists
.SingleOrDefault(todo => todo.Id.Equals(listId));;
if (toDoList == null)
{
throw new EntityNotFoundException();
}
//create item from dto
ToDoItem itemToAdd = itemDTO.CreateEntity(listId);
//each new Item receives the lowest position of all items in a list
itemToAdd.Position = _context.ToDoItems.Where(x => x.ToDoListId.Equals(listId)).Count();
//add the new item to list and update database
toDoList.Items.Add(itemToAdd);
_context.SaveChanges();
//update dto data
itemDTO.ItemId = itemToAdd.Id;
itemDTO.Position = itemToAdd.Position;
return(itemDTO);
}
public ValidationResponse CreateTodo(CreateTodoRequest request)
{
ValidationResponse response = new ValidationResponse();
if (request == null || string.IsNullOrWhiteSpace(request.Username) || string.IsNullOrWhiteSpace(request.Token))
{
response.Error = "Need to login";
return(response);
}
User user = context.Users.FirstOrDefault(u => u.Name == request.Username && u.Token == request.Token);
if (user == null)
{
response.Error = "Need to login";
return(response);
}
var todo = new ToDo();
todo.User = user;
todo.Text = request.TodoText;
context.Entry(todo).State = EntityState.Added;
context.SaveChanges();
return(response);
}
public ActionResult <ToDo> PostToDo(ToDo toDo)
{
_context.ToDos.Add(toDo);
_context.SaveChanges();
return(CreatedAtAction("PostToDo", toDo));
}
public IActionResult Create(ToDo t)
{
t.isFinished = true;
_db.Items.Add(t);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public ToDo CreateToDo(ToDo toDo)
{
_context.Add(toDo);
_context.SaveChanges();
return(toDo);
}
public async void ToDoListDeleteTest()
{
DbContextOptions <ToDoDbContext> options =
new DbContextOptionsBuilder <ToDoDbContext>()
.UseInMemoryDatabase("todoListDelete")
.Options;
using (ToDoDbContext context = new ToDoDbContext(options))
{
//CREATE
//Arrange
ToDoList myList = new ToDoList();
myList.Name = "new list";
context.ToDoList.Add(myList);
context.SaveChanges();
//READ
var list = await context.ToDoList.FirstOrDefaultAsync(t => t.Name == myList.Name);
context.ToDoList.Remove(list);
context.SaveChanges();
var deletedList = await context.ToDoList.FirstOrDefaultAsync(t => t.Name == myList.Name);
Assert.True(deletedList == null);
}
}
public ToDoListDTO CreateToDoList(ToDoListDTO toDoListDTO, string email)
{
_logger.LogInformation("ToDoListService -> Executing CreateToDoList()");
//if the user didn't specify the date for the reminder
if (toDoListDTO.EndDate == null)
{
toDoListDTO.IsReminded = false; //the list is not a reminded list
}
else
{
toDoListDTO.IsReminded = true;
}
ToDoList newList = toDoListDTO.CreateEntity(email);
//new todo list position is 'highest' in the hierarchy for the specified user
newList.Position = _context.ToDoLists
.Where(x => x.Owner.Equals(email))
.Count();
_context.ToDoLists.Add(newList);
_context.SaveChanges();
toDoListDTO.Id = newList.Id;
toDoListDTO.Position = newList.Position;
return(toDoListDTO);
}
public ICollection <ToDo> AddToDo(ToDo toDo, Guid userId)
{
toDo.UserId = userId;
_context.ToDos.Add(toDo);
_context.SaveChanges();
return(GetAll(userId));
}
public void DeleteById(int id)
{
ToDo toDo = _context.ToDos.FirstOrDefault(x => x.Id == id);
if (toDo != null)
{
_context.ToDos.Remove(toDo);
}
_context.SaveChanges();
}
public ActionResult <User> WijzigUser(int id, User user)
{
if (id != user.Id)
{
return(BadRequest());
}
_context.Users.Update(user);
_context.SaveChanges();
return(Ok(user));
}
public void DeleteById(int id)
{
SubTask subtask = _context.SubTasks.FirstOrDefault(x => x.Id == id);
if (subtask != null)
{
_context.SubTasks.Remove(subtask);
}
_context.SaveChanges();
}
public void DeleteById(int id)
{
User user = _context.Users.FirstOrDefault(x => x.Id == id);
if (user != null)
{
_context.Users.Remove(user);
}
_context.SaveChanges();
}
public ActionResult Create([Bind(Include = "Id,Name,Description")] ToDoItem toDoItem)
{
if (ModelState.IsValid)
{
db.ToDoItems.Add(toDoItem);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(toDoItem));
}
public ActionResult Create(ToDoItem toDoItem)
{
if (ModelState.IsValid)
{
_db.ToDoItems.Add(toDoItem);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(toDoItem));
}
public ActionResult Create([Bind(Include = "Id,Description,Completed")] ToDo toDo)
{
_toDoRepo.Add(toDo);
ViewBag.ToDoes = _toDoRepo.GetAll();
//return RedirectToAction("Index");
if (ModelState.IsValid)
{
db.ToDoes.Add(toDo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
/// <summary>
/// DB method to Soft delete(Mark complete) a task
/// </summary>
/// <param name="toDoID"></param>
/// <returns></returns>
public long Update(long toDoID)
{
ToDo todo = _toDoDbContext.todoS.Find(toDoID);
if (todo != null)
{
todo.isDeleted = true;
_toDoDbContext.Entry(todo).State = EntityState.Modified;
if (_toDoDbContext.SaveChanges() == 1)
{
return(todo.Id);
}
}
return(0);
}
public IActionResult Edit(Task edittedTask)
{
if (ModelState.IsValid)
{
using (var db = new ToDoDbContext())
{
var entityToEdit = db.Tasks.FirstOrDefault(t => t.Id == edittedTask.Id);
entityToEdit.Title = edittedTask.Title;
entityToEdit.Comments = edittedTask.Comments;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
else
{
ViewData["Error"] = "Leaving empty title or comment is not allowed!";
if (string.IsNullOrWhiteSpace(edittedTask.Title))
{
ViewData["TitleError"] = "bg-danger";
}
if (string.IsNullOrWhiteSpace(edittedTask.Comments))
{
ViewData["CommentsError"] = "bg-danger";
}
return(View());
}
}
public Item Update(Item item)
{
using var todoDbContext = new ToDoDbContext();
todoDbContext.Items.Update(item);
todoDbContext.SaveChanges();
return(item);
}
private void CheckForExpirations(object state)
{
using (var scope = _serviceScopeFactory.CreateScope())
{
_dbContext = scope.ServiceProvider.GetService <ToDoDbContext>();
DateTime today = DateTime.Today;
//loop through to do lists and check if their reminder date expired
_dbContext.ToDoLists
.ToList()
.ForEach(list =>
{
if (list.IsReminded && list.EndDate.HasValue && today > list.EndDate.Value)
{
_logger.LogInformation($"ReminderService -> Found expired list with title '{list.Title}'");
SendEmail($"{_options.LinkToExpiredList}/{list.Id}", list.Owner);
list.IsReminded = false;
}
});
_dbContext.SaveChanges();
}
}
private void SetupDb()
{
var ti = new TenantInfo {
Id = "finbuckle", ConnectionString = "Data Source=Data/ToDoList.db"
};
using (var db = new ToDoDbContext(ti))
{
db.Database.EnsureDeleted();
db.Database.EnsureCreated();
db.ToDoItems.Add(new ToDoItem {
Title = "Call Lawyer ", Completed = false
});
db.ToDoItems.Add(new ToDoItem {
Title = "File Papers", Completed = false
});
db.ToDoItems.Add(new ToDoItem {
Title = "Send Invoices", Completed = true
});
db.SaveChanges();
}
ti = new TenantInfo {
Id = "megacorp", ConnectionString = "Data Source=Data/ToDoList.db"
};
using (var db = new ToDoDbContext(ti))
{
db.Database.EnsureCreated();
db.ToDoItems.Add(new ToDoItem {
Title = "Send Invoices", Completed = true
});
db.ToDoItems.Add(new ToDoItem {
Title = "Construct Additional Pylons", Completed = true
});
db.ToDoItems.Add(new ToDoItem {
Title = "Call Insurance Company", Completed = false
});
db.SaveChanges();
}
ti = new TenantInfo {
Id = "initech", ConnectionString = "Data Source=Data/Initech_ToDoList.db"
};
using (var db = new ToDoDbContext(ti))
{
db.Database.EnsureDeleted();
db.Database.EnsureCreated();
db.ToDoItems.Add(new ToDoItem {
Title = "Send Invoices", Completed = false
});
db.ToDoItems.Add(new ToDoItem {
Title = "Pay Salaries", Completed = true
});
db.ToDoItems.Add(new ToDoItem {
Title = "Write Memo", Completed = false
});
db.SaveChanges();
}
}
public IActionResult Post([FromBody] Activity a)
{
var db = new ToDoDbContext();
db.Activity.Add(a);
db.SaveChanges();
return(Ok());
}
public IActionResult Delete(uint id)
{
var db = new ToDoDbContext();
var a = db.Activity.Find(id);
db.Activity.Remove(a);
db.SaveChanges();
return(Ok());
}
public IActionResult Put(uint id, [FromBody] Activity a)
{
var db = new ToDoDbContext();
a.Id = id;
db.Update(a);
db.SaveChanges();
return(Ok());
}
public async Task <bool> Handle(ToggleDoneCommand request, CancellationToken cancellationToken)
{
var entity = await _context.ToDoItems.SingleOrDefaultAsync(x => x.ToDoItemId == request.ItemId, cancellationToken);
var updatedDone = !entity.Done;
entity.Done = updatedDone;
_context.SaveChanges();
return(updatedDone);
}
public ActionResult Edit([Bind("Id", "Item", "Completed")] ToDoItem toDoItem)
{
if (ModelState.IsValid)
{
_db.Entry(toDoItem).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(toDoItem));
}
