private static void StoreWorkDoneBy(string[] Usernames, int WorkID) { WorkDoneByTableAdapter workDoneByAdapter = new WorkDoneByTableAdapter(); NuRacingDataSet.WorkDoneByDataTable workDoneByTable = workDoneByAdapter.GetData(); foreach (string Username in Usernames) { NuRacingDataSet.WorkDoneByRow newWorkDoneByRow = workDoneByTable.NewWorkDoneByRow(); newWorkDoneByRow.Work_UID = WorkID; newWorkDoneByRow.User_Username = Username; workDoneByTable.AddWorkDoneByRow(newWorkDoneByRow); } workDoneByAdapter.Update(workDoneByTable); }
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); } }