public void updateDatabase() { if (beenChanged) { AssignedTaskTableAdapter taskAdapter = new AssignedTaskTableAdapter(); NuRacingDataSet.AssignedTaskDataTable taskTable = taskAdapter.GetAssignedTask(taskID); NuRacingDataSet.AssignedTaskRow taskRow = (NuRacingDataSet.AssignedTaskRow)taskTable.Rows[0]; taskRow.WorkType_UID = workTypeID; taskRow.Task_Name = taskName; taskRow.Task_Description = taskDescription; taskRow.Task_TakeFiveNeeded = takeFiveNeeded; taskRow.Task_DueDate = dueDate; if (taskStatus != null) { taskRow.Task_Status = taskStatus; } if (taskIncompleteReason != null) { taskRow.Task_IncompleteReason = taskIncompleteReason; } taskAdapter.Update(taskTable); } }
/// <summary> /// Adds a task for the specified user and send them an email notification. /// </summary> /// <param name="assigningUser">User assigning the task</param> /// <param name="assignedToUser">User task was assigned to</param> /// <param name="workType">Work task belongs to</param> /// <param name="name">Name of the task</param> /// <param name="description">Description of task</param> /// <param name="takeFiveNeeded">Requires a take five</param> static public void addTask(string assigningUser, List <string> assignedToUsers, int workType, DateTime dueDate, string name, string description, bool takeFiveNeeded) { AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter(); NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetData(); NuRacingDataSet.AssignedTaskRow assignedTaskRow = assignedTaskTable.NewAssignedTaskRow(); assignedTaskRow.User_Username_AssignedBy = assigningUser; assignedTaskRow.WorkType_UID = workType; assignedTaskRow.Task_Name = name; assignedTaskRow.Task_Description = description; assignedTaskRow.Task_TakeFiveNeeded = takeFiveNeeded; assignedTaskRow.Task_DueDate = dueDate; assignedTaskRow.Task_Status = "Incomplete"; assignedTaskTable.AddAssignedTaskRow(assignedTaskRow); assignedTaskAdapter.Update(assignedTaskTable); AssignedUserTableAdapter assignedUserAdapter = new AssignedUserTableAdapter(); NuRacingDataSet.AssignedUserDataTable assignedUserTable = assignedUserAdapter.GetData(); int TaskID = getTaskID(assigningUser, workType, dueDate, name, description, takeFiveNeeded); foreach (string assignedToUser in assignedToUsers) { NuRacingDataSet.AssignedUserRow assignedUserRow = assignedUserTable.NewAssignedUserRow(); assignedUserRow.User_Username = assignedToUser; assignedUserRow.Task_UID = TaskID; assignedUserTable.AddAssignedUserRow(assignedUserRow); EmailManager.taskNotification(assignedToUser, assigningUser, name, description, User.getEmail(assignedToUser)); } assignedUserAdapter.Update(assignedUserTable); }
/// <summary> /// Adds a task for the specified user and send them an email notification. /// </summary> /// <param name="assigningUser">User assigning the task</param> /// <param name="assignedToUser">User task was assigned to</param> /// <param name="workType">Work task belongs to</param> /// <param name="name">Name of the task</param> /// <param name="description">Description of task</param> /// <param name="takeFiveNeeded">Requires a take five</param> public static void addTask(string assigningUser, List<string> assignedToUsers, int workType, DateTime dueDate, string name, string description, bool takeFiveNeeded) { AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter(); NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetData(); NuRacingDataSet.AssignedTaskRow assignedTaskRow = assignedTaskTable.NewAssignedTaskRow(); assignedTaskRow.User_Username_AssignedBy = assigningUser; assignedTaskRow.WorkType_UID = workType; assignedTaskRow.Task_Name = name; assignedTaskRow.Task_Description = description; assignedTaskRow.Task_TakeFiveNeeded = takeFiveNeeded; assignedTaskRow.Task_DueDate = dueDate; assignedTaskRow.Task_Status = "Incomplete"; assignedTaskTable.AddAssignedTaskRow(assignedTaskRow); assignedTaskAdapter.Update(assignedTaskTable); AssignedUserTableAdapter assignedUserAdapter = new AssignedUserTableAdapter(); NuRacingDataSet.AssignedUserDataTable assignedUserTable = assignedUserAdapter.GetData(); int TaskID = getTaskID(assigningUser, workType, dueDate, name, description, takeFiveNeeded); foreach (string assignedToUser in assignedToUsers) { NuRacingDataSet.AssignedUserRow assignedUserRow = assignedUserTable.NewAssignedUserRow(); assignedUserRow.User_Username = assignedToUser; assignedUserRow.Task_UID = TaskID; assignedUserTable.AddAssignedUserRow(assignedUserRow); EmailManager.taskNotification(assignedToUser, assigningUser, name, description, User.getEmail(assignedToUser)); } assignedUserAdapter.Update(assignedUserTable); }
/// <summary> /// Sets the specified task to complete if it exists /// </summary> /// <param name="taskID">ID of task</param> static public void taskComplete(int taskID) { if (taskExists(taskID)) { AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter(); NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetDataByWorkTypeID(taskID); NuRacingDataSet.AssignedTaskRow assignedTaskRow = (NuRacingDataSet.AssignedTaskRow)assignedTaskTable.Rows[0]; assignedTaskRow.Task_Status = "Complete"; assignedTaskAdapter.Update(assignedTaskTable); } else { throw new ArgumentException("Assigned Task Doesn't Exist"); } }
/// <summary> /// Sets the reason for a task being incomplete. /// </summary> /// <param name="taskID">ID of the task</param> /// <param name="reason">Reason for incomplete task</param> public static void changeTaskStatus(int taskID, string status, string reason) { if (taskExists(taskID)) { AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter(); NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetDataByWorkTypeID(taskID); NuRacingDataSet.AssignedTaskRow assignedTaskRow = (NuRacingDataSet.AssignedTaskRow)assignedTaskTable.Rows[0]; assignedTaskRow.Task_Status = "Incomplete"; assignedTaskRow.Task_IncompleteReason = reason; assignedTaskAdapter.Update(assignedTaskTable); } else { throw new ArgumentException("Assigned Task Doesn't Exist"); } }
public void updateDatabase() { if (beenChanged) { AssignedTaskTableAdapter taskAdapter = new AssignedTaskTableAdapter(); NuRacingDataSet.AssignedTaskDataTable taskTable = taskAdapter.GetAssignedTask(taskID); NuRacingDataSet.AssignedTaskRow taskRow = (NuRacingDataSet.AssignedTaskRow)taskTable.Rows[0]; taskRow.WorkType_UID = workTypeID; taskRow.Task_Name = taskName; taskRow.Task_Description = taskDescription; taskRow.Task_TakeFiveNeeded = takeFiveNeeded; taskRow.Task_DueDate = dueDate; if (taskStatus != null) { taskRow.Task_Status = taskStatus; } if (taskIncompleteReason != null) { taskRow.Task_IncompleteReason = taskIncompleteReason; } taskAdapter.Update(taskTable); } }