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> /// Return a TaskInfo object via specified assignedTaskID /// </summary> /// <param name="assignedTaskID"></param> /// <returns></returns> public static TaskInfo getAssignedTask(int assignedTaskID) { AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter(); NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetAssignedTask(assignedTaskID); if (assignedTaskTable.Rows.Count == 0) { throw new ArgumentException("Assigned Task Doesn't Exist"); } return(new TaskInfo((NuRacingDataSet.AssignedTaskRow)assignedTaskTable.Rows[0])); }
public void resetData() { if (!beenChanged) { AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter(); NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetAssignedTask(taskID); NuRacingDataSet.AssignedTaskRow taskRow = (NuRacingDataSet.AssignedTaskRow)assignedTaskTable.Rows[0]; assigningUserInfo = UserInfo.getUser(taskRow.User_Username_AssignedBy); taskID = taskRow.Task_UID; workTypeID = taskRow.WorkType_UID; taskName = taskRow.Task_Name; taskDescription = taskRow.Task_Description; takeFiveNeeded = taskRow.Task_TakeFiveNeeded; if (!taskRow.IsTask_StatusNull()) { taskStatus = taskRow.Task_Status; if (!taskRow.IsTask_IncompleteReasonNull()) { taskIncompleteReason = taskRow.Task_IncompleteReason; } } dueDate = taskRow.Task_DueDate; AssignedUserTableAdapter assignedUserAdapter = new AssignedUserTableAdapter(); NuRacingDataSet.AssignedUserDataTable assignedUserTable = assignedUserAdapter.GetDataByTaskID(TaskID); userAssignedInfo = new List <UserInfo>(assignedUserTable.Rows.Count); foreach (NuRacingDataSet.AssignedUserRow assignedUserRow in assignedUserTable.Rows) { userAssignedInfo.Add(UserInfo.getUser(assignedUserRow.User_Username)); } } }
public void resetData() { if (!beenChanged) { AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter(); NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetAssignedTask(taskID); NuRacingDataSet.AssignedTaskRow taskRow = (NuRacingDataSet.AssignedTaskRow)assignedTaskTable.Rows[0]; assigningUserInfo = UserInfo.getUser(taskRow.User_Username_AssignedBy); taskID = taskRow.Task_UID; workTypeID = taskRow.WorkType_UID; taskName = taskRow.Task_Name; taskDescription = taskRow.Task_Description; takeFiveNeeded = taskRow.Task_TakeFiveNeeded; if (!taskRow.IsTask_StatusNull()) { taskStatus = taskRow.Task_Status; if (!taskRow.IsTask_IncompleteReasonNull()) { taskIncompleteReason = taskRow.Task_IncompleteReason; } } dueDate = taskRow.Task_DueDate; AssignedUserTableAdapter assignedUserAdapter = new AssignedUserTableAdapter(); NuRacingDataSet.AssignedUserDataTable assignedUserTable = assignedUserAdapter.GetDataByTaskID(TaskID); userAssignedInfo = new List<UserInfo>(assignedUserTable.Rows.Count); foreach (NuRacingDataSet.AssignedUserRow assignedUserRow in assignedUserTable.Rows) { userAssignedInfo.Add(UserInfo.getUser(assignedUserRow.User_Username)); } } }
/// <summary> /// Return a TaskInfo object via specified assignedTaskID /// </summary> /// <param name="assignedTaskID"></param> /// <returns></returns> public static TaskInfo getAssignedTask(int assignedTaskID) { AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter(); NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetAssignedTask(assignedTaskID); if (assignedTaskTable.Rows.Count == 0) { throw new ArgumentException("Assigned Task Doesn't Exist"); } return new TaskInfo((NuRacingDataSet.AssignedTaskRow)assignedTaskTable.Rows[0]); }