Example #1
0
        private WorkInfo(NuRacingDataSet.WorkRow row)
        {
            workID         = row.Work_UID;
            timeWorkedMins = row.Work_TimeWorkedMins;
            dateCompleted  = row.Work_DateCompleted;
            description    = row.Work_Description;
            takeFiveTaken  = row.Work_TakeFiveTaken;
            workTypeID     = row.WorkType_UID;
            taskID         = row.Task_UID;

            WorkDoneByTableAdapter workDoneByAdapter = new WorkDoneByTableAdapter();

            NuRacingDataSet.WorkDoneByDataTable workDoneByTable = workDoneByAdapter.GetDataByWorkID(row.Work_UID);

            usernames = new List <string>(workDoneByTable.Rows.Count);

            foreach (NuRacingDataSet.WorkDoneByRow workDoneByRow in workDoneByTable)
            {
                usernames.Add(workDoneByRow.User_Username);
            }
        }
Example #2
0
        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);
        }