private void UpdateDatabase()
{
DB.Open();
DB.BeginTransaction();
try
{
int companyId = Int32.Parse(hdfCompanyId.Value);
// Update
ProjectSelectProjectLastUsedProjects projectSelectProjectLastUsedProjects = new ProjectSelectProjectLastUsedProjects(projectSelectProjectTDS);
projectSelectProjectLastUsedProjects.Save(companyId);
DB.CommitTransaction();
// Store datasets
projectSelectProjectTDS.AcceptChanges();
Session["projectSelectProjectTDS"] = projectSelectProjectTDS;
Session["projectLastUsedProjects"] = projectSelectProjectTDS.LastUsedProjects;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
