public async Task <ActionResult <bool> > DeleteProjectMember(string milestoneId)
{
using (var ctx = new AckeeCtx())
{
var milestone = await ctx.Milestones.FirstOrDefaultAsync(m => m.MilestoneID == milestoneId);
if (milestone == null)
{
return(BadRequest());
}
ctx.Remove(milestone);
await ctx.SaveChangesAsync();
return(true);
}
}
public async Task <object> DeleteLabel([FromRoute] string labelId)
{
using (var ctx = new AckeeCtx())
{
var label = ctx.Labels.FirstOrDefault(l => l.LabelID == labelId);
if (label == null)
{
return(BadRequest());
}
ctx.Remove(label);
await ctx.SaveChangesAsync();
return(true);
}
}
public async Task <ActionResult <bool> > DeleteProjectMember(string projectId, string userEmail)
{
using (var ctx = new AckeeCtx())
{
var project = await ctx.Projects.FirstOrDefaultAsync(p => p.ProjectID == projectId);
var user = await ctx.ApplicationUser.FirstOrDefaultAsync(u => u.Email == userEmail);
var userProject = await ctx.UserProjects.FirstOrDefaultAsync(up => up.ProjectId == projectId && up.UserId == user.Id);
if (user == null || project == null || userProject == null)
{
return(BadRequest());
}
ctx.Remove(userProject);
await ctx.SaveChangesAsync();
return(true);
}
}
public async Task <ActionResult <bool> > RemoveLabelFromTask(string taskId, string labelId)
{
using (var ctx = new AckeeCtx())
{
var task = await ctx.Tasks.FirstOrDefaultAsync(t => t.TaskID == taskId);
var label = await ctx.Labels.FirstOrDefaultAsync(l => l.LabelID == labelId);
var taskLabel = await ctx.TaskLabels.FirstOrDefaultAsync(tl => tl.LabelID == labelId && tl.TaskID == taskId);
if (task == null || label == null || taskLabel == null)
{
return(BadRequest());
}
ctx.Remove(taskLabel);
await ctx.SaveChangesAsync();
return(true);
}
}
public async Task <ActionResult <bool> > RemoveAssigneeFromTask(string taskId, string userId)
{
using (var ctx = new AckeeCtx())
{
var task = await ctx.Tasks.FirstOrDefaultAsync(t => t.TaskID == taskId);
var assignee = await ctx.ApplicationUser.FirstOrDefaultAsync(a => a.Id == userId);
var userTask = await ctx.UserTasks.FirstOrDefaultAsync(ut => ut.UserID == userId && ut.TaskID == taskId);
if (task == null || assignee == null || userTask == null)
{
return(BadRequest());
}
ctx.Remove(userTask);
await ctx.SaveChangesAsync();
return(true);
}
}
public async Task <ActionResult <bool> > RemoveMilestoneFromTask(string taskId, string milestoneId)
{
using (var ctx = new AckeeCtx())
{
var task = await ctx.Tasks.FirstOrDefaultAsync(t => t.TaskID == taskId);
var milestone = await ctx.Milestones.FirstOrDefaultAsync(m => m.MilestoneID == milestoneId);
var milestoneTask = await ctx.MilestoneTasks.FirstOrDefaultAsync(mt => mt.MilestoneID == milestoneId && mt.TaskID == taskId);
if (task == null || milestone == null || milestoneTask == null)
{
return(BadRequest());
}
ctx.Remove(milestoneTask);
await ctx.SaveChangesAsync();
return(true);
}
}