private void UpdateDatabase()
{
DB.Open();
DB.BeginTransaction();
try
{
int companyId = Int32.Parse(hdfCompanyId.Value);
// Update Comments and History
FlatSectionJlCommentDetails flatSectionJlCommentDetails = new FlatSectionJlCommentDetails(flatSectionJlTDS);
flatSectionJlCommentDetails.Save(companyId);
FlatSectionJlHistoryDetails flatSectionJlHistoryDetails = new FlatSectionJlHistoryDetails(flatSectionJlTDS);
flatSectionJlHistoryDetails.Save(companyId);
// Update FlatSectionJl for new Comments
int workId = Int32.Parse(hdfWorkId.Value.Trim());
string workType = "Junction Lining Lateral";
FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS);
flatSectionJl.UpdateCommentsHistoryForSummaryEdit(workId, workType, companyId);
JlNavigator jlNavigator = new JlNavigator(jlNavigatorTDS);
jlNavigator.UpdateComments(workId, workType, companyId);
Session["flatSectionJlTDS"] = flatSectionJlTDS;
Session["jlNavigatorTDS"] = jlNavigatorTDS;
DB.CommitTransaction();
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
private void UpdateDatabase()
{
// Get ids & location
int projectId = Int32.Parse(hdfCurrentProject.Value.Trim());
int companyId = Int32.Parse(Session["companyID"].ToString());
// Load project
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
// Get location
Int64 countryId = projectGateway.GetCountryID(projectId);
Int64? provinceId = null; if (projectGateway.GetProvinceID(projectId).HasValue) provinceId = (Int64)projectGateway.GetProvinceID(projectId);
Int64? countyId = null; if (projectGateway.GetCountyID(projectId).HasValue) countyId = (Int64)projectGateway.GetCountyID(projectId);
Int64? cityId = null; if (projectGateway.GetCityID(projectId).HasValue) cityId = (Int64)projectGateway.GetCityID(projectId);
// Save
DB.Open();
DB.BeginTransaction();
try
{
FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS);
if (Convert.ToBoolean(ViewState["UpdateComments"]))
{
// Update Comments
FlatSectionJlCommentDetails flatSectionJlCommentDetails = new FlatSectionJlCommentDetails(flatSectionJlTDS);
flatSectionJlCommentDetails.Save(companyId);
// Update works
WorkUpdate();
}
else
{
flatSectionJl.UpdateDirect(countryId, provinceId, countyId, cityId, projectId, companyId);
}
DB.CommitTransaction();
flatSectionJlTDS.AcceptChanges();
// Store datasets
Session["flatSectionJlTDS"] = flatSectionJlTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}