private void UpdateDatabase() { int companyId = Int32.Parse(hdfCompanyId.Value); int employeeId = Int32.Parse(hdfCurrentEmployeeId.Value); DB.Open(); DB.BeginTransaction(); try { // Save type history information EmployeeInformationTypeHistoryInformation employeeInformationTypeHistoryInformation = new EmployeeInformationTypeHistoryInformation(employeeInformationTDS); employeeInformationTypeHistoryInformation.Save(employeeId, companyId); // Save notes information EmployeeInformationNoteInformation employeeInformationNoteInformation = new EmployeeInformationNoteInformation(employeeInformationTDS); employeeInformationNoteInformation.Save(companyId); // Save costs information EmployeeInformationCostInformation employeeInformationCostInformation = new EmployeeInformationCostInformation(employeeInformationTDS); employeeInformationCostInformation.Save(companyId); // Save costs exceptions information EmployeeInformationCostExceptionsInformation employeeInformationCostExceptionsInformation = new EmployeeInformationCostExceptionsInformation(employeeInformationTDS); employeeInformationCostExceptionsInformation.Save(companyId, employeeId); // Save categories approve timesheets information EmployeeInformationCategoryApproveTimesheetsInformation employeeInformationCategoryApproveTimesheetsInformation = new EmployeeInformationCategoryApproveTimesheetsInformation(employeeInformationTDS); employeeInformationCategoryApproveTimesheetsInformation.Save(); // Save employee information EmployeeInformationBasicInformation employeeInformationBasicInformation = new EmployeeInformationBasicInformation(employeeInformationTDS); employeeInformationBasicInformation.Save(companyId); DB.CommitTransaction(); // Store datasets employeeInformationTDS.AcceptChanges(); Session["employeeInformationTDS"] = employeeInformationTDS; } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }