private void UpdateDatabase()
{
LibraryFilesGateway libraryFilesGateway = new LibraryFilesGateway(libraryTDSForServices);
libraryFilesGateway.Update();
DB.Open();
DB.BeginTransaction();
try
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int serviceId = Int32.Parse(hdfSelectedSRId.Value);
ServiceRequestsManagerToolBasicInformation serviceRequestsManagerToolBasicInformation = new ServiceRequestsManagerToolBasicInformation(serviceRequestsManagerToolTDS);
serviceRequestsManagerToolBasicInformation.Save(companyId);
// Save costs information
ServiceRequestsManagerToolCostInformation serviceRequestsManagerToolCostInformation = new ServiceRequestsManagerToolCostInformation(serviceRequestsManagerToolTDS);
serviceRequestsManagerToolCostInformation.Save((int)serviceId, companyId);
// Save notes information
ServiceInformationServiceNoteGateway serviceInformationServiceNoteGateway = new ServiceInformationServiceNoteGateway(serviceInformationTDS);
ServiceInformationServiceNote serviceInformationServiceNote = new ServiceInformationServiceNote(serviceInformationTDS);
foreach (ServiceInformationTDS.NoteInformationRow rowNotes in (ServiceInformationTDS.NoteInformationDataTable)serviceInformationServiceNoteGateway.Table)
{
if (!rowNotes.IsLIBRARY_FILES_IDNull())
{
if (rowNotes.LIBRARY_FILES_ID == 0 && rowNotes.FILENAME != "")
{
libraryFilesGateway.LoadByFileName(rowNotes.FILENAME, companyId);
int newLibraryFilesId = libraryFilesGateway.GetlibraryFilesId(rowNotes.FILENAME);
rowNotes.LIBRARY_FILES_ID = newLibraryFilesId;
}
}
}
// Save notes information
serviceInformationServiceNote.Save(companyId);
DB.CommitTransaction();
// Store datasets
serviceRequestsManagerToolTDS.AcceptChanges();
Session["serviceRequestsManagerToolTDS"] = serviceRequestsManagerToolTDS;
// Store datasets
libraryTDSForServices.AcceptChanges();
serviceInformationTDS.AcceptChanges();
Session["serviceInformationTDSForManagerTool"] = serviceInformationTDS;
Session["libraryTDSForServices"] = libraryTDSForServices;
Session.Remove("libraryTDSForServices");
Session.Remove("serviceInformationTDSForManagerTool");
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
