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 WorkUpdate()
{
// Get general variables
int projectId = Int32.Parse(hdfCurrentProject.Value.Trim());
int companyId = Convert.ToInt32(Session["companyID"]);
FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS);
DataView dataViewFlatSectionJl = new DataView(flatSectionJlTDS.FlatSectionJl);
dataViewFlatSectionJl.RowFilter = "(Selected = 1) AND (Deleted = 0)";
foreach (DataRowView row in dataViewFlatSectionJl)
{
int workId = Int32.Parse(row["WorkID"].ToString());
int assetId = Int32.Parse(row["AssetID"].ToString());
string workType = "Junction Lining Lateral";
// Get original variables
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByWorkId(workId, companyId);
string originalWorkType = workGateway.GetWorkTypeOriginal(workId);
int? originalLibraryCategoriesId = workGateway.GetLibraryCategoriesIdOriginal(workId);
string originalComment = workGateway.GetCommentsOriginal(workId);
string originalHistory = workGateway.GetHistoryOriginal(workId);
// Get new comment
WorkCommentsGateway workCommentsGateway = new WorkCommentsGateway();
workCommentsGateway.LoadByWorkIdWorkType(workId, companyId, "Junction Lining Lateral");
WorkComments workComments = new WorkComments(workCommentsGateway.Data);
string newComments = workComments.GetAllComments(workId, companyId, workCommentsGateway.Table.Rows.Count, "\n");
// Get new history
WorkHistoryGateway workHistoryGateway = new WorkHistoryGateway();
workHistoryGateway.LoadByWorkIdWorkType(workId, companyId, "Junction Lining Lateral");
WorkHistory workHistory = new WorkHistory(workHistoryGateway.Data);
string newHistory = workHistory.GetAllHistory(workId, companyId, workHistoryGateway.Table.Rows.Count, "\n");
Work work = new Work(null);
work.UpdateDirect(workId, projectId, assetId, originalWorkType, originalLibraryCategoriesId, false, companyId, originalComment, originalHistory, workId, projectId, assetId, originalWorkType, originalLibraryCategoriesId, false, companyId, newComments, newHistory);
flatSectionJl.UpdateCommentsHistoryForSummaryEdit(workId, workType, companyId);
}
}