//Сохраняет записи табеля в базу private void SubmitTimeSheet() { try { _db.TimeSheet.InsertOnSubmit(_timeSheet); _db.SubmitChanges(); foreach (var timeSheetRecord in _timeSheetRecordLList) { timeSheetRecord.idTimeSheet = _timeSheet.id; } var r = SerializeTimeSheetRecordsToXml(_timeSheetRecordLList); _db.TimeSheetRecordInsert(r); } catch (System.Exception ex) { _db.TimeSheetRecords.DeleteAllOnSubmit(_db.TimeSheetRecords.Where(w => w.idTimeSheet == _timeSheet.id)); _db.TimeSheet.DeleteOnSubmit(_timeSheet); _db.SubmitChanges(); throw; } }
//Сохраняет записи табеля в базу private void SubmitTimeSheet() { var ts = new TimeSheet { id = _timeSheet.id, idDepartment = _timeSheet.idDepartment, IsFake = _timeSheet.IsFake, idCreater = _timeSheet.idCreater, DateBeginPeriod = _timeSheet.DateBeginPeriod, DateEndPeriod = _timeSheet.DateEndPeriod, DateComposition = _timeSheet.DateComposition }; try { _db.TimeSheet.InsertOnSubmit(ts); _db.SubmitChanges(); if (ts.IsFake) { return; } foreach (var timeSheetRecord in _timeSheetRecordLList) { timeSheetRecord.idTimeSheet = ts.id; } var r = SerializeTimeSheetRecordsToXml(_timeSheetRecordLList); _db.TimeSheetRecordInsert(r); } catch (System.Exception ex) { _db.TimeSheetRecords.DeleteAllOnSubmit(_db.TimeSheetRecords.Where(w => w.idTimeSheet == ts.id)); _db.TimeSheet.DeleteOnSubmit(ts); _db.SubmitChanges(); throw; } }