/// <summary>
/// Method to add label
/// </summary>
/// <param name="label"></param>
/// <returns></returns>
public async Task <int> AddLabel(Domain.Models.Label label)
{
using (var context = new ToDoServiceDBContext())
{
context.Labels.Add(label);
return(await context.SaveChangesAsync());
}
}
/// <summary>
/// Method to register new user
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public async Task <int> RegisterUser(User user)
{
using (var context = new ToDoServiceDBContext())
{
context.Users.Add(user);
return(await context.SaveChangesAsync());
}
}
/// <summary>
/// Method to update todoitem
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public async Task <int> UpdateToDoItem(ToDoItem item)
{
using (var context = new ToDoServiceDBContext())
{
context.ToDoItems.Attach(item).Property(x => x.CreatedDate).IsModified = false;
context.ToDoItems.Update(item);
return(await context.SaveChangesAsync());
}
}
/// <summary>
/// Method to delete label by id.
/// </summary>
/// <param name="labelId"></param>
/// <returns></returns>
public async Task <int> DeleteLabelById(int labelId)
{
using (var context = new ToDoServiceDBContext())
{
var id = await context.Labels.FindAsync(labelId);
context.Labels.Remove(id);
return(await context.SaveChangesAsync());
}
}
/// <summary>
/// Method to add new todoitem
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public async Task <int> AddToDoItem(ToDoItem item)
{
using (var context = new ToDoServiceDBContext())
{
context.ToDoItems.Add(item);
int result = await context.SaveChangesAsync();
return(result);
}
}
/// <summary>
/// Method to delete todoitem by id
/// </summary>
/// <param name="itemId"></param>
/// <returns></returns>
public async Task <int> DeleteToDoItem(int itemId)
{
using (var context = new ToDoServiceDBContext())
{
var item = await context.ToDoItems.FindAsync(itemId);
context.ToDoItems.Remove(item);
return(await context.SaveChangesAsync());
}
}
/// <summary>
/// Method to add new todolist
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public async Task <int> AddToDoList(ToDoList item)
{
int result = 0;
using (var context = new ToDoServiceDBContext())
{
context.ToDoLists.Add(item);
result = await context.SaveChangesAsync();
}
return(result);
}
/// <summary>
/// Method to assign label to todoitem
/// </summary>
/// <param name="labelId"></param>
/// <param name="itemId"></param>
/// <returns></returns>
public async Task <int> AssignLabelToItem(int labelId, int[] itemId)
{
using (var context = new ToDoServiceDBContext())
{
var items = context.ToDoItems;
foreach (BaseToDoItem item in items)
{
if (itemId.Contains(item.Id))
{
item.LabelId = labelId;
}
}
return(await context.SaveChangesAsync());
}
}
/// <summary>
/// Method to assign label to todolist
/// </summary>
/// <param name="labelId"></param>
/// <param name="listId"></param>
/// <returns></returns>
public async Task <int> AssignLabelToList(int labelId, int[] listId)
{
using (var context = new ToDoServiceDBContext())
{
var items = context.ToDoLists;
foreach (ToDoList list in items)
{
if (listId.Contains(list.Id))
{
list.LabelId = labelId;
}
}
return(await context.SaveChangesAsync());
}
}
