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