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