public bool ProjectTaskUserAjouter(VProjectTask vProjectTask)//id MapTaskState { //pour ajouter un "ProjectTaskUser", vue qu'il est lier à "MapTaskState" et qu'on ajout d'abord un ""MapTaskState" //il faut d'abord selectionner le dérnier id de "MapTaskState" var mapTaskState = from mts in _context.MapTaskState orderby mts.MapTaskStateID descending select mts; long idDernierMapTaskState = mapTaskState.ToList()[0].MapTaskStateID; //en suite, idDernierMapTaskState est entrée dans le nouveau ProjectTaskUser var projectTaskUser = new ProjectTaskUser { MapTaskStateID = idDernierMapTaskState, ProjectID = vProjectTask.ProjectID, TaskID = vProjectTask.TaskID, UserName = Environment.UserName }; _context.ProjectTaskUser.Add(projectTaskUser); General.SaveContextChanges("ajout dans ProjectTaskUser : " + projectTaskUser.ProjectTaskUserID, _context); return(true); }
public async Task <IActionResult> unsubscribeTask(UnsubscribeTaskInput unsubscribeTaskInput) { string token = HttpContext.Request.Headers["Authorization"]; if (token != null) { try { ApplicationUser user = await _userManager.FindByEmailAsync(_jwtService.GetClaimValue(token, "email")); ProjectTaskUser PTU = await _context.ProjectTaskUsers.SingleOrDefaultAsync(x => x.ProjectTaskID == new Guid(unsubscribeTaskInput.TaskID) && x.UserID == user.Id); if (PTU == null) { return(NotFound()); } _context.ProjectTaskUsers.Remove(PTU); await _context.SaveChangesAsync(); return(Ok()); } catch (ApplicationException e) { return(Unauthorized()); } catch (Exception e) { return(NotFound()); } } return(Unauthorized()); }
public void ProjectTaskUserModifier(ProjectTaskUser projectTaskUser) { try { _context.ProjectTaskUser.AddOrUpdate(projectTaskUser); General.SaveContextChanges("modificaton dans ProjectTaskUser id : " + projectTaskUser.ProjectTaskUserID, _context); } catch (Exception) { //MessageBox.Show(e.ToString()); return; } }
public bool ProjectTaskUserSupprimer(ProjectTaskUser projectTaskUser)//suppression d'un TimeSheet { try { //vue qu'un "ProjectTaskUser" _context.ProjectTaskUser.Remove(projectTaskUser); General.SaveContextChanges("suppression dans ProjectTaskUser id : " + projectTaskUser.ProjectTaskUserID, _context); return(true); } catch (Exception) { return(false); } }
// Add to ProjectTaskUser public void AddTaskProjectUser(int projectToAddId, int taskToAddId) { try { ProjectTaskUser addTaskTo = new ProjectTaskUser() { ProjectID = projectToAddId, TaskID = taskToAddId }; _data.ProjectTaskUser.Add(addTaskTo); General.SaveContextChanges("Add a Task to Project :" + projectToAddId, _data); } catch (Exception e) { System.Windows.Forms.MessageBox.Show(e.ToString()); return; } }
public async Task <IActionResult> createTask([FromBody] CreateTaskInput taskInput) { string token = HttpContext.Request.Headers["Authorization"]; if (token != null) { try { ApplicationUser user = await _userManager.FindByEmailAsync(_jwtService.GetClaimValue(token, "email")); ProjectTask NewTask = new ProjectTask(); NewTask.Title = taskInput.Title; NewTask.Description = taskInput.Description; NewTask.Created = DateTime.Now; NewTask.DueDate = DateTime.Parse(taskInput.DueDate); NewTask.CreatedBy = user.Email; _context.Add(NewTask); if (!string.IsNullOrEmpty(taskInput.AssignedTo)) { //TODO split string by ; and make multiple PTU ApplicationUser AssignTo = await _userManager.FindByEmailAsync(taskInput.AssignedTo); ProjectTaskUser NewPTU = new ProjectTaskUser(); NewPTU.ProjectTaskID = NewTask.ID; NewPTU.UserID = AssignTo.Id; _context.Add(NewPTU); } await _context.SaveChangesAsync(); return(Json(NewTask.ID)); } catch (ApplicationException e) { return(Unauthorized()); } catch (Exception e) { return(NotFound()); } } return(Unauthorized()); }
public async Task <IActionResult> assignTaskToUser([FromBody] AssignUserInput assignUserInput) { string token = HttpContext.Request.Headers["Authorization"]; if (token != null) { try { ProjectTask task = await _context.ProjectTasks.SingleOrDefaultAsync(x => x.ID == new Guid(assignUserInput.taskID)); if (task == null) { return(NotFound()); } ApplicationUser user = await _userManager.FindByEmailAsync(_jwtService.GetClaimValue(token, "email")); ProjectTaskUser NewPTU = new ProjectTaskUser(); NewPTU.ProjectTaskID = task.ID; NewPTU.UserID = user.Id; _context.Add(NewPTU); await _context.SaveChangesAsync(); return(Ok()); } catch (ApplicationException e) { return(Unauthorized()); } catch (Exception e) { return(NotFound()); } } return(Unauthorized()); }