/// <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()); } }