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>
/// See if specified task exists
/// </summary>
/// <param name="taskID">ID of task</param>
/// <returns></returns>
static public bool taskExists(int taskID)
{
AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter();
NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetDataByWorkTypeID(taskID);
return(assignedTaskTable.Rows.Count != 0);
}
/// <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]));
}
/// <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);
}
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>
/// 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");
}
}
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>
/// Return a list of all assigned tasks for the specified user
/// </summary>
/// <param name="username">Username of assigned user</param>
/// <returns></returns>
public static List<TaskInfo> getUserTasks(string username)
{
AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter();
NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetDataByAssignedUser(username);
List<TaskInfo> result = new List<TaskInfo>();
foreach (NuRacingDataSet.AssignedTaskRow AssignedTaskRow in assignedTaskTable.Rows)
{
result.Add(new TaskInfo(AssignedTaskRow));
}
return result;
}
/// <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]);
}
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>
/// See if specified task exists
/// </summary>
/// <param name="taskID">ID of task</param>
/// <returns></returns>
public static bool taskExists(int taskID)
{
AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter();
NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetDataByWorkTypeID(taskID);
return assignedTaskTable.Rows.Count != 0;
}
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);
}
}
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>
/// Returns a list of assigned tasks for given workType
/// </summary>
/// <param name="workID"></param>
/// <returns></returns>
public static List<TaskInfo> getWorkTypeTasks(int workID)
{
AssignedTaskTableAdapter assignedTaskAdapter = new AssignedTaskTableAdapter();
NuRacingDataSet.AssignedTaskDataTable assignedTaskTable = assignedTaskAdapter.GetDataByWorkTypeID(workID);
List<TaskInfo> result = new List<TaskInfo>();
foreach (NuRacingDataSet.AssignedTaskRow AssignedTaskRow in assignedTaskTable.Rows)
{
result.Add(new TaskInfo(AssignedTaskRow));
}
return result;
}
