private static int findWorkID(DateTime DateCompleted, string Description, int?TaskID, int WorkTypeID, int TimeWorkedMins, bool TakeFiveTaken)
{
WorkTableAdapter workAdapter = new WorkTableAdapter();
NuRacingDataSet.WorkDataTable workTable = workAdapter.GetData();
foreach (NuRacingDataSet.WorkRow workRow in workTable.Rows)
{
if (workRow.Work_DateCompleted.Date == DateCompleted.Date &&
workRow.Work_Description == Description &&
workRow.WorkType_UID == WorkTypeID &&
workRow.Work_TimeWorkedMins == TimeWorkedMins &&
workRow.Work_TakeFiveTaken == TakeFiveTaken)
{
if (TaskID == null && workRow.IsTask_UIDNull())
{
return(workRow.Work_UID);
}
if (TaskID == null || workRow.IsTask_UIDNull())
{
}
else if (TaskID.Value == workRow.Task_UID)
{
return(workRow.Work_UID);
}
}
}
throw new ArgumentException("Unknown error connecting adding work to database");
}
// Written by James Hibbard
/// <summary>
/// Returns the WorkInfo for the given WorkID
/// </summary>
/// <param name="WorkID">The WorkID to specify the row</param>
/// <returns>A WorkInfo object containing all info about the row.</returns>
public WorkInfo getWorkInfo(int WorkID)
{
WorkTableAdapter workAdapter = new WorkTableAdapter();
NuRacingDataSet.WorkDataTable workTable = workAdapter.GetWork(WorkID);
if (workTable.Rows.Count == 0)
{
throw new ArgumentException("WorkID wasn't valid");
}
return(new WorkInfo((NuRacingDataSet.WorkRow)workTable.Rows[0]));
}
// Written by James Hibbard
/// <summary>
/// Returns the WorkInfo for the given TaskID
/// </summary>
/// <param name="TaskID">The TaskID to specify the row</param>
/// <returns>If the taskID has a Work record, a WorkInfo object containing all info about the row, if it doesn't, returns null.</returns>
public WorkInfo getTaskWorkInfo(int TaskID)
{
WorkTableAdapter workAdapter = new WorkTableAdapter();
NuRacingDataSet.WorkDataTable workTable = workAdapter.GetDataByTaskID(TaskID);
if (workTable.Rows.Count == 0)
{
return(null);
}
else
{
return(new WorkInfo((NuRacingDataSet.WorkRow)workTable.Rows[0]));
}
}
// Written By James Hibbard
/// <summary>
/// Gets all WorkInfo records for a specific WorkType
/// </summary>
/// <param name="WorkTypeID">The ID of the Worktype</param>
/// <returns>A List of the WorkInfo records</returns>
public List <WorkInfo> getWorkTypeWorkInfo(int WorkTypeID)
{
WorkTableAdapter workAdapter = new WorkTableAdapter();
NuRacingDataSet.WorkDataTable workTable = workAdapter.GetDataByWorkTypeID(WorkTypeID);
List <WorkInfo> result = new List <WorkInfo>();
foreach (NuRacingDataSet.WorkRow workRow in workTable.Rows)
{
result.Add(new WorkInfo(workRow));
}
return(result);
}
// Writen By James Hibbard
/// <summary>
/// Returns a list of all WorkInfo objects the user recorded
/// </summary>
/// <param name="Username">The Username of the user to get the Work Info for</param>
/// <returns>A list of all the work records</returns>
public List <WorkInfo> getUserWorkInfo(String Username)
{
WorkTableAdapter workAdapter = new WorkTableAdapter();
NuRacingDataSet.WorkDataTable workTable = workAdapter.GetDataByUsername(Username);
List <WorkInfo> result = new List <WorkInfo>();
foreach (NuRacingDataSet.WorkRow workRow in workTable.Rows)
{
result.Add(new WorkInfo(workRow));
}
return(result);
}
private static void StoreWork(DateTime DateCompleted, string Description, int?taskID, int WorkTypeID, int TimeWorkedMins, bool TakeFiveTaken)
{
WorkTableAdapter workAdapter = new WorkTableAdapter();
NuRacingDataSet.WorkDataTable workTable = workAdapter.GetData();
NuRacingDataSet.WorkRow workRow = workTable.NewWorkRow();
workRow.Work_DateCompleted = DateCompleted;
workRow.Work_Description = Description;
workRow.WorkType_UID = WorkTypeID;
workRow.Work_TimeWorkedMins = TimeWorkedMins;
if (taskID == null)
{
workRow.SetTask_UIDNull();
}
else
{
workRow.Task_UID = taskID.Value;
}
workRow.Work_TakeFiveTaken = TakeFiveTaken;
workTable.AddWorkRow(workRow);
workAdapter.Update(workTable);
}
private static void StoreWork(DateTime DateCompleted, string Description, int? taskID, int WorkTypeID, int TimeWorkedMins, bool TakeFiveTaken)
{
WorkTableAdapter workAdapter = new WorkTableAdapter();
NuRacingDataSet.WorkDataTable workTable = workAdapter.GetData();
NuRacingDataSet.WorkRow workRow = workTable.NewWorkRow();
workRow.Work_DateCompleted = DateCompleted;
workRow.Work_Description = Description;
workRow.WorkType_UID = WorkTypeID;
workRow.Work_TimeWorkedMins = TimeWorkedMins;
if (taskID == null)
{
workRow.SetTask_UIDNull();
}
else
{
workRow.Task_UID = taskID.Value;
}
workRow.Work_TakeFiveTaken = TakeFiveTaken;
workTable.AddWorkRow(workRow);
workAdapter.Update(workTable);
}
private static int findWorkID(DateTime DateCompleted, string Description, int? TaskID, int WorkTypeID, int TimeWorkedMins, bool TakeFiveTaken)
{
WorkTableAdapter workAdapter = new WorkTableAdapter();
NuRacingDataSet.WorkDataTable workTable = workAdapter.GetData();
foreach (NuRacingDataSet.WorkRow workRow in workTable.Rows)
{
if (workRow.Work_DateCompleted.Date == DateCompleted.Date &&
workRow.Work_Description == Description &&
workRow.WorkType_UID == WorkTypeID &&
workRow.Work_TimeWorkedMins == TimeWorkedMins &&
workRow.Work_TakeFiveTaken == TakeFiveTaken)
{
if (TaskID == null && workRow.IsTask_UIDNull())
{
return workRow.Work_UID;
}
if (TaskID == null || workRow.IsTask_UIDNull())
{
}
else if (TaskID.Value == workRow.Task_UID)
{
return workRow.Work_UID;
}
}
}
throw new ArgumentException("Unknown error connecting adding work to database");
}
// Written By James Hibbard
/// <summary>
/// Gets all WorkInfo records for a specific WorkType
/// </summary>
/// <param name="WorkTypeID">The ID of the Worktype</param>
/// <returns>A List of the WorkInfo records</returns>
public List<WorkInfo> getWorkTypeWorkInfo(int WorkTypeID)
{
WorkTableAdapter workAdapter = new WorkTableAdapter();
NuRacingDataSet.WorkDataTable workTable = workAdapter.GetDataByWorkTypeID(WorkTypeID);
List<WorkInfo> result = new List<WorkInfo>();
foreach (NuRacingDataSet.WorkRow workRow in workTable.Rows)
{
result.Add(new WorkInfo(workRow));
}
return result;
}
// Written by James Hibbard
/// <summary>
/// Returns the WorkInfo for the given WorkID
/// </summary>
/// <param name="WorkID">The WorkID to specify the row</param>
/// <returns>A WorkInfo object containing all info about the row.</returns>
public WorkInfo getWorkInfo(int WorkID)
{
WorkTableAdapter workAdapter = new WorkTableAdapter();
NuRacingDataSet.WorkDataTable workTable = workAdapter.GetWork(WorkID);
if (workTable.Rows.Count == 0)
{
throw new ArgumentException("WorkID wasn't valid");
}
return new WorkInfo((NuRacingDataSet.WorkRow)workTable.Rows[0]);
}
// Writen By James Hibbard
/// <summary>
/// Returns a list of all WorkInfo objects the user recorded
/// </summary>
/// <param name="Username">The Username of the user to get the Work Info for</param>
/// <returns>A list of all the work records</returns>
public List<WorkInfo> getUserWorkInfo(String Username)
{
WorkTableAdapter workAdapter = new WorkTableAdapter();
NuRacingDataSet.WorkDataTable workTable = workAdapter.GetDataByUsername(Username);
List<WorkInfo> result = new List<WorkInfo>();
foreach (NuRacingDataSet.WorkRow workRow in workTable.Rows)
{
result.Add(new WorkInfo(workRow));
}
return result;
}
// Written by James Hibbard
/// <summary>
/// Returns the WorkInfo for the given TaskID
/// </summary>
/// <param name="TaskID">The TaskID to specify the row</param>
/// <returns>If the taskID has a Work record, a WorkInfo object containing all info about the row, if it doesn't, returns null.</returns>
public WorkInfo getTaskWorkInfo(int TaskID)
{
WorkTableAdapter workAdapter = new WorkTableAdapter();
NuRacingDataSet.WorkDataTable workTable = workAdapter.GetDataByTaskID(TaskID);
if (workTable.Rows.Count == 0)
{
return null;
}
else
{
return new WorkInfo((NuRacingDataSet.WorkRow)workTable.Rows[0]);
}
}
