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