//Сохраняет записи табеля в базу
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;
}
}