private void UpdateDatabase()
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int materialId = Int32.Parse(hdfCurrentMaterialId.Value);
DB.Open();
DB.BeginTransaction();
try
{
// Save notes information
MaterialsInformationNoteInformation materialsInformationNoteInformation = new MaterialsInformationNoteInformation(materialsInformationTDS);
materialsInformationNoteInformation.Save(companyId);
// Save costs information
MaterialsInformationCostHistoryInformation materialsInformationCostHistoryInformation = new MaterialsInformationCostHistoryInformation(materialsInformationTDS);
materialsInformationCostHistoryInformation.Save(companyId);
// Save costs exceptions information
MaterialsInformationCostHistoryExceptionsInformation materialsInformationCostHistoryExceptionsInformation = new MaterialsInformationCostHistoryExceptionsInformation(materialsInformationTDS);
materialsInformationCostHistoryExceptionsInformation.Save(companyId, materialId);
// Save material information
MaterialsInformationBasicInformation materialsInformationBasicInformation = new MaterialsInformationBasicInformation(materialsInformationTDS);
materialsInformationBasicInformation.Save(companyId);
DB.CommitTransaction();
// Store datasets
materialsInformationTDS.AcceptChanges();
Session["materialsInformationTDS"] = materialsInformationTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
