/// <summary> /// Returns a list of all assigned tasks with their information /// </summary> /// <returns></returns> public static List <TaskInfo> getTasks() { AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter(); NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetData(); List <TaskInfo> result = new List <TaskInfo>(); foreach (NuRacingDataSet.AssignedTaskRow AssignedTaskRow in assignedTaskTable.Rows) { result.Add(new TaskInfo(AssignedTaskRow)); } return(result); }
/// <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); }
private static int getTaskID(string assigningUser, int workType, DateTime dueDate, string name, string description, bool takeFiveNeeded) { AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter(); NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetData(); foreach (NuRacingDataSet.AssignedTaskRow assignedTaskRow in assignedTaskTable.Rows) { if (assignedTaskRow.User_Username_AssignedBy == assigningUser && assignedTaskRow.WorkType_UID == workType && assignedTaskRow.Task_Name == name && assignedTaskRow.Task_Description == description && assignedTaskRow.Task_TakeFiveNeeded == takeFiveNeeded && assignedTaskRow.Task_DueDate.Date == dueDate.Date) { return(assignedTaskRow.Task_UID); } } throw new ArgumentException("Unknown error connecting adding work to database"); }
private static int getTaskID(string assigningUser, int workType, DateTime dueDate, string name, string description, bool takeFiveNeeded) { AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter(); NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetData(); foreach (NuRacingDataSet.AssignedTaskRow assignedTaskRow in assignedTaskTable.Rows) { if (assignedTaskRow.User_Username_AssignedBy == assigningUser && assignedTaskRow.WorkType_UID == workType && assignedTaskRow.Task_Name == name && assignedTaskRow.Task_Description == description && assignedTaskRow.Task_TakeFiveNeeded == takeFiveNeeded && assignedTaskRow.Task_DueDate.Date == dueDate.Date) { return assignedTaskRow.Task_UID; } } throw new ArgumentException("Unknown error connecting adding work to database"); }
/// <summary> /// Returns a list of all assigned tasks with their information /// </summary> /// <returns></returns> public static List<TaskInfo> getTasks() { AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter(); NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetData(); List<TaskInfo> result = new List<TaskInfo>(); foreach (NuRacingDataSet.AssignedTaskRow AssignedTaskRow in assignedTaskTable.Rows) { result.Add(new TaskInfo(AssignedTaskRow)); } return result; }