public void StartRunning(string eventName, string distance) { try { var now = DateTime.Now; List <RunnerInfo> runners = new List <RunnerInfo>(); using (RunnerDataContext db = new RunnerDataContext()) { runners = db.RunnerInfos.Where(x => x.Event == eventName && x.Distance == distance).ToList(); List <RunnerScanDateTime> insertingList = new List <RunnerScanDateTime>(); foreach (var runner in runners) { RunnerScanDateTime record = new RunnerScanDateTime() { RunnerIdentification = runner.RunnerBIB, ScannedDateTime = now }; insertingList.Add(record); } db.RunnerScanDateTimes.InsertAllOnSubmit(insertingList); db.SubmitChanges(); } MessageBox.Show($"Start {eventName} {distance} successfully"); } catch (Exception e) { MessageBox.Show(e.Message); } }
partial void UpdateRunnerScanDateTime(RunnerScanDateTime instance);
partial void DeleteRunnerScanDateTime(RunnerScanDateTime instance);
partial void InsertRunnerScanDateTime(RunnerScanDateTime instance);