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