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;
}
}