public async Task <int> DeleteListWithAllTask(int listId) { int rowAffacted = 0; using (IDbContextTransaction transection = _ternContext.Database.BeginTransaction()) { try { List <Domain.Task> tasks = _ternContext.Tasks.Where(x => x.ListId == listId).ToList(); _ternContext.Tasks.RemoveRange(tasks); rowAffacted += await _ternContext.SaveChangesAsync(); Domain.List list = new Domain.List { ListId = listId }; _ternContext.Lists.Attach(list); _ternContext.Lists.Remove(list); rowAffacted += await _ternContext.SaveChangesAsync(); await transection.CommitAsync(); } catch (Exception e) { throw e; } } return(0); }
public async Task <int> DeleteAsync(int taskId) { Domain.Task task = new Domain.Task { TaskId = taskId }; _ternContext.Tasks.Attach(task); _ternContext.Tasks.Remove(task); int rowAffected = await _ternContext.SaveChangesAsync(); return(rowAffected); }
public async Task <int> Delete(int subTaskId) { int rowAffected = 0; SubTask subTask = new SubTask { SubTaskId = subTaskId }; _ternContext.SubTasks.Attach(subTask); _ternContext.SubTasks.Remove(subTask); rowAffected += await _ternContext.SaveChangesAsync(); return(rowAffected); }
public async Task <int> Create(CreateSubTaskModel subTask) { Domain.SubTask newSubTask = new Domain.SubTask { SubTaskName = subTask.SubTaskName, TaskId = subTask.TaskId, StatusId = 1, CreatedDate = DateTime.Now }; _ternContext.SubTasks.Add(newSubTask); await _ternContext.SaveChangesAsync(); return(newSubTask.SubTaskId); }
public async Task <int> CreateNewTask(CreateTaskModel taskDetail) { var task = new Domain.Task { TaskName = taskDetail.TaskName, Description = taskDetail.Description, ListId = null, StatusId = 1, CreatedDate = DateTime.Now }; _ternContext.Tasks.Add(task); await _ternContext.SaveChangesAsync(); return(task.TaskId); }
public async Task <int> Update(TaskModel taskDetail) { int recordAffected = 0; Domain.Task task = _ternContext.Tasks.FirstOrDefault(x => x.TaskId == taskDetail.TaskId); if (task != null) { task.TaskName = taskDetail.TaskName; task.Description = taskDetail.Description; task.ListId = taskDetail.List.ListId; task.StatusId = taskDetail.Status.StatusId; _ternContext.Tasks.Update(task); recordAffected = await _ternContext.SaveChangesAsync(); } return(recordAffected); }
public async Task <int> DeleteList(int listId) { int rowAffacted = 0; try { Domain.List list = new Domain.List { ListId = listId }; _ternContext.Lists.Attach(list); _ternContext.Lists.Remove(list); rowAffacted = await _ternContext.SaveChangesAsync(); return(rowAffacted); } catch (Exception e) { throw e; } }