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);
}
}
