public async Task Post([FromBody] ToDoItem model)
{
model.CreationTime = DateTime.Now;
model.LastUpdateDateTime = DateTime.Now;
model.IsCompleted = false;
await _db.ToDoItems.AddAsync(model);
await _db.SaveChangesAsync();
}
public async Task <ToDoItemResponse> PostToDoItemAsync(ToDoItem toDoItem)
{
var mapper = _mappingConfig.CreateMapper();
var entity = mapper.Map <ToDoItemEntity>(toDoItem);
_context.ToDoItems.Add(entity);
await _context.SaveChangesAsync();
var rewritten = mapper.Map <ToDoItem>(entity);
return(new ToDoItemResponse {
Id = entity.Id, Item = rewritten
});
}
public static async Task AddTestData(ToDoAppDbContext context)
{
if (context.ToDoItems.Any())
{
return;
}
context.ToDoItems.Add(new ToDoItemEntity {
Name = "Get Groceries",
IsComplete = true
});
context.ToDoItems.Add(new ToDoItemEntity
{
Name = "Walk Dogs",
IsComplete = false
});
context.ToDoItems.Add(new ToDoItemEntity
{
Name = "Study",
IsComplete = false
});
await context.SaveChangesAsync();
}
public async Task <TeamMember> Create(TeamMember entity)
{
using (ToDoAppDbContext context = _contextFactory.CreateContext())
{
var createdEntity = context.Members.Add(entity);
await context.SaveChangesAsync();
return(createdEntity);
}
}
public async Task <bool> Delete(int id)
{
using (ToDoAppDbContext context = _contextFactory.CreateContext())
{
TeamMember entity = context.Set <TeamMember>().FirstOrDefault((e) => e.Id == id);
context.Set <TeamMember>().Remove(entity);
await context.SaveChangesAsync();
return(true);
}
}
public async Task <TeamMember> Update(int id, TeamMember entity)
{
using (ToDoAppDbContext context = _contextFactory.CreateContext())
{
entity.Id = id;
context.Set <TeamMember>().Add(entity);
await context.SaveChangesAsync();
return(entity);
}
}
public async Task <bool> PostToDoTasks(List <ToDoTasks> toDoTasks)
{
try
{
int noOfRowDeleted = _context.Database.ExecuteSqlRaw("Delete from ToDoTasks");
//_context.ToDoTasks.RemoveRange(_context.ToDoTasks);
foreach (var item in toDoTasks)
{
item.ID = Guid.NewGuid();
_context.ToDoTasks.Add(item);
}
await _context.SaveChangesAsync();
return(true);
}
catch (Exception)
{
throw;
}
}
