private void UpdateDatabase()
{
DB.Open();
DB.BeginTransaction();
try
{
// Update comments
string runDetails = hdfRunDetail.Value;
int projectId = Int32.Parse(hdfProjectId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
FullLengthLiningWetOutCommentsDetails fullLengthLiningWetOutCommentsDetails = new FullLengthLiningWetOutCommentsDetails(fullLengthLiningTDS);
fullLengthLiningWetOutCommentsDetails.Save(companyId, runDetails, projectId);
// Update works
workUpdate();
// Update section
int workId = Int32.Parse(hdfWorkId.Value.Trim());
FullLengthLiningWorkDetails fullLengthLiningWorkDetails = new FullLengthLiningWorkDetails(fullLengthLiningTDS);
fullLengthLiningWorkDetails.UpdateCommentsWetOutForSummaryEdit(workId, companyId);
// Store datasets
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
DB.CommitTransaction();
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
