protected void Page_PreRender(object sender, EventArgs e)
{
// Set active toolbar
mForm8 master = (mForm8)this.Master;
master.ActiveToolbar = "eSewers";
// For error message
hdfErrorFieldList.Value = "";
if ((tbxWetOutDataHoistHeight.Text == "OK")|| (tbxWetOutDataHoistHeight.Text == ""))
{
lblWetOutDataWarning.Visible = false;
}
else
{
lblWetOutDataWarning.Visible = true;
}
// For Video Done From MH and Measured From MH
int companyId = Int32.Parse(hdfCompanyId.Value);
int assetId = Int32.Parse(hdfAssetId.Value);
int workId = Int32.Parse(hdfWorkId.Value);
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
// set visible VideoDoneFromMh and Measured From and To
FullLengthLiningWorkDetailsGateway flWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway();
flWorkDetailsGateway.LoadByWorkIdAssetId(workId, assetId, companyId);
FullLengthLiningLateralDetails flLateralDetails = new FullLengthLiningLateralDetails();
flLateralDetails.LoadForEdit(workId, assetId, companyId, currentProjectId);
if (Int32.Parse(tbxLaterals.Text) > 0)
{
ddlM1DataVideoDoneFromMh.Visible = false;
tbxM1DataVideoDoneFromMh.Visible = true;
tbxM1DataVideoDoneFromMh.Text = ddlM1DataVideoDoneFromMh.SelectedValue;
ddlM1DataVideoDoneToMh.Visible = false;
tbxM1DataVideoDoneToMh.Visible = true;
tbxM1DataVideoDoneToMh.Text = ddlM1DataVideoDoneToMh.SelectedValue;
ddlM1DataMeasuredFromMh.Visible = false;
tbxM1DataMeasuredFromMh.Visible = true;
tbxM1DataMeasuredFromMh.Text = ddlM1DataMeasuredFromMh.SelectedValue;
btnClear.Visible = false;
}
else
{
ddlM1DataVideoDoneFromMh.Visible = true;
tbxM1DataVideoDoneFromMh.Visible = false;
ddlM1DataVideoDoneToMh.Visible = true;
tbxM1DataVideoDoneToMh.Visible = false;
ddlM1DataMeasuredFromMh.Visible = true;
tbxM1DataMeasuredFromMh.Visible = false;
btnClear.Visible = true;
}
// For materials (m1)
MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway();
materialInformationGateway.LoadLastMaterialByAssetId(assetId, companyId);
if (materialInformationGateway.Table.Rows.Count > 0)
{
ddlM1DataMaterial.SelectedValue = materialInformationGateway.GetLastMaterialType(assetId);
}
// For PreFlush Date and PreVideo Date
int projectId = Int32.Parse(hdfCurrentProjectId.Value);
FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway();
fullLengthLiningWorkDetailsGateway.LoadByWorkIdAssetId(workId, assetId, companyId);
int? raProjectId = fullLengthLiningWorkDetailsGateway.GetRaProjectId(workId);
if ((raProjectId.HasValue) && (raProjectId == projectId))
{
// ... if ra data is from the same project
tkrdpGeneralPreFlushDate.Visible = true;
tkrdpGeneralPreVideoDate.Visible = true;
tkrdpGeneralPreFlushDateReadOnly.Visible = false;
tkrdpGeneralPreVideoDateReadOnly.Visible = false;
}
else
{
tkrdpGeneralPreFlushDate.Visible = false;
tkrdpGeneralPreVideoDate.Visible = false;
tkrdpGeneralPreFlushDateReadOnly.Visible = true;
tkrdpGeneralPreVideoDateReadOnly.Visible = true;
}
// ... if there is no data
if (tkrdpGeneralPreFlushDate.SelectedDate.HasValue)
{
tkrdpGeneralPreFlushDate.Calendar.Enabled = false;
tkrdpGeneralPreFlushDate.DateInput.ReadOnly = true;
}
else
{
tkrdpGeneralPreFlushDate.Calendar.Enabled = true;
tkrdpGeneralPreFlushDate.DateInput.ReadOnly = false;
}
if (tkrdpGeneralPreVideoDate.SelectedDate.HasValue)
{
tkrdpGeneralPreVideoDate.Calendar.Enabled = false;
tkrdpGeneralPreVideoDate.DateInput.ReadOnly = true;
}
else
{
tkrdpGeneralPreVideoDate.Calendar.Enabled = true;
tkrdpGeneralPreVideoDate.DateInput.ReadOnly = false;
}
// Hide or show the Old CWP ID field
if (tbxOldCwpId.Text == "")
{
lblOldCwpId.Visible = false;
tbxOldCwpId.Visible = false;
}
if (tbxFlowSectionId.Text == "")
{
LoadFullLengthLiningData(currentProjectId, assetId, companyId);
}
// Validate tools
if (Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_ADMIN"]))
{
tkrpbLeftMenuTools.Items[0].Items[1].Visible = true; // Resins option
tkrpbLeftMenuTools.Items[0].Items[2].Visible = true; // Catalyst option
tkrdpInstallDataInstallDate.Enabled = true;
tkrdpInstallDataFinalVideoDate.Enabled = true;
}
else
{
tkrpbLeftMenuTools.Items[0].Items[1].Visible = false; // Resins option
tkrpbLeftMenuTools.Items[0].Items[2].Visible = false; // Catalyst option
tkrdpInstallDataInstallDate.Enabled = false;
tkrdpInstallDataFinalVideoDate.Enabled = false;
}
}
/// <summary>
/// Save all materials to database (direct)
/// </summary>
/// <param name="companyId">companyId</param>
public void Save(int companyId)
{
MaterialInformationTDS materialInformationChanges = (MaterialInformationTDS)Data.GetChanges();
if (materialInformationChanges.MaterialInformation.Rows.Count > 0)
{
MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(materialInformationChanges);
foreach (MaterialInformationTDS.MaterialInformationRow row in (MaterialInformationTDS.MaterialInformationDataTable)materialInformationChanges.MaterialInformation)
{
// Insert new materials
if ((!row.Deleted) && (!row.InDatabase))
{
AssetSewerMaterial assetSewerMaterial = new AssetSewerMaterial(null);
assetSewerMaterial.InsertDirect(row.AssetID, row.RefID, row.MaterialType, row.Date_, row.Deleted, row.COMPANY_ID);
}
// Update materials
if ((!row.Deleted) && (row.InDatabase))
{
int assetId = row.AssetID;
int refId = row.RefID;
bool originalDeleted = false;
int originalCompanyId = companyId;
// original values
string originalMaterialType = materialInformationGateway.GetMaterialTypeOriginal(assetId, refId);
DateTime originalDate_ = materialInformationGateway.GetDate_Original(assetId, refId);
// new values
string newMaterialType = materialInformationGateway.GetMaterialType(assetId, refId);
AssetSewerMaterial assetSewerMaterial = new AssetSewerMaterial(null);
assetSewerMaterial.UpdateDirect(assetId, refId, originalMaterialType, originalDate_, originalCompanyId, originalDeleted, assetId, refId, newMaterialType, originalDate_, originalCompanyId, originalDeleted);
}
// Deleted materials
if ((row.Deleted) && (row.InDatabase))
{
AssetSewerMaterial assetSewerMaterial = new AssetSewerMaterial(null);
assetSewerMaterial.DeleteDirect(row.AssetID, row.RefID, row.COMPANY_ID);
}
}
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
// Set active toolbar
mForm6 master = (mForm6)this.Master;
master.ActiveToolbar = "eSewers";
int companyId = Int32.Parse(hdfCompanyId.Value);
int assetId = Int32.Parse(hdfAssetId.Value);
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway();
materialInformationGateway.LoadLastMaterialByAssetId(assetId, companyId);
if (materialInformationGateway.Table.Rows.Count > 0)
{
tbxGeneralDataMaterial.Text = materialInformationGateway.GetLastMaterialType(assetId);
}
if (tbxFlowOrderId.Text == "")
{
LoadPointRepairsData(currentProjectId, assetId, companyId);
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
bool isFromTabClick = false;
if (!IsPostBack)
{
if (!isFromTabClick)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_EDIT"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Validate query string
if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["client_id"] == null) || ((string)Request.QueryString["project_id"] == null) || ((string)Request.QueryString["asset_id"] == null) || ((string)Request.QueryString["active_tab"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in fl_edit.aspx");
}
// Tag Page
TagPage();
// Prepare initial data
Session.Remove("flAddLateralsNewDummy");
Session.Remove("wetOutCatalystsDetailsDummy");
Session.Remove("materialInformationTDS");
materialInformationTDS = new MaterialInformationTDS();
// ... for wet out section list
AssetSewerSectionList assetSewerSectionList = new AssetSewerSectionList();
assetSewerSectionList.LoadAndAddItem(Int32.Parse(hdfCurrentProjectId.Value), hdfWorkType.Value, "-1", "(All)", Int32.Parse(hdfCompanyId.Value));
cbxlSectionId.DataSource = assetSewerSectionList.Table;
cbxlSectionId.DataValueField = "SectionID";
cbxlSectionId.DataTextField = "FlowOrderID";
cbxlSectionId.DataBind();
cbxlInversionDataSectionId.DataSource = assetSewerSectionList.Table;
cbxlInversionDataSectionId.DataValueField = "SectionID";
cbxlInversionDataSectionId.DataTextField = "FlowOrderID";
cbxlInversionDataSectionId.DataBind();
// If coming from
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
int assetId = Int32.Parse(hdfAssetId.Value.Trim());
int workId = Int32.Parse(hdfWorkId.Value.Trim());
string workType = hdfWorkType.Value;
// ... fl_navigator2.aspx
if (Request.QueryString["source_page"] == "fl_navigator2.aspx")
{
StoreNavigatorState();
ViewState["update"] = "no";
// ... Set initial tab
if ((string)Session["dialogOpenedFll"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
fullLengthLiningTDS = new FullLengthLiningTDS();
FullLengthLiningSectionDetails fullLengthLiningSectionDetails = new FullLengthLiningSectionDetails(fullLengthLiningTDS);
fullLengthLiningSectionDetails.LoadByWorkId(workId, companyId);
FullLengthLiningWorkDetails fullLengthLiningWorkDetails = new FullLengthLiningWorkDetails(fullLengthLiningTDS);
fullLengthLiningWorkDetails.LoadByWorkIdAssetId(workId, assetId, companyId);
FullLengthLiningLateralDetails fullLengthLiningLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
fullLengthLiningLateralDetails.LoadForEdit(workId, assetId, companyId, currentProjectId);
FullLengthLiningWetOutCatalystsDetails fullLengthLiningWetOutCatalystsDetails = new FullLengthLiningWetOutCatalystsDetails(fullLengthLiningTDS);
fullLengthLiningWetOutCatalystsDetails.LoadAll(workId, companyId);
}
else
{
hdfActiveTab.Value = (string)Session["activeTabFll"];
// Restore datasets
fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"];
}
// ... Store dataset
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
}
// ... fl_summary.aspx or fl_edit.aspx
if ((Request.QueryString["source_page"] == "fl_summary.aspx") || (Request.QueryString["source_page"] == "fl_edit.aspx"))
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// ... Restore dataset
fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"];
// ... Set initial tab
if ((string)Session["dialogOpenedFll"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
}
else
{
hdfActiveTab.Value = (string)Session["activeTabFll"];
}
if (ViewState["update"].ToString().Trim() == "yes")
{
FullLengthLiningSectionDetails fullLengthLiningSectionDetails = new FullLengthLiningSectionDetails(fullLengthLiningTDS);
fullLengthLiningSectionDetails.LoadByWorkId(workId, companyId);
FullLengthLiningWorkDetails fullLengthLiningWorkDetails = new FullLengthLiningWorkDetails(fullLengthLiningTDS);
fullLengthLiningWorkDetails.LoadByWorkIdAssetId(workId, assetId, companyId);
FullLengthLiningLateralDetails fullLengthLiningLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS);
fullLengthLiningLateralDetails.LoadForEdit(workId, assetId, companyId, currentProjectId);
FullLengthLiningWetOutCatalystsDetails fullLengthLiningWetOutCatalystsDetails = new FullLengthLiningWetOutCatalystsDetails(fullLengthLiningTDS);
fullLengthLiningWetOutCatalystsDetails.LoadAll(workId, companyId);
// ... Store dataset
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
}
}
// Prepare initial data
lblMissingData.Visible = false;
// Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcFlDetails.ActiveTabIndex = activeTab;
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
if (name.Length > 23) name = name.Substring(0, 20) + "...";
lblTitleProjectName.Text = " > Project: " + name + " (" + projectGateway.GetProjectNumber(currentProjectId) + ") > Selected Section";
// ... Data for current full length lining work
LoadFullLengthLiningData(currentProjectId, assetId, companyId);
// Databind
Page.DataBind();
// Especial load for Run details
string runDetails = hdfRunDetails.Value;
WorkFullLengthLiningWetOutGateway workFullLengthLiningWetOutGateway = new WorkFullLengthLiningWetOutGateway();
workFullLengthLiningWetOutGateway.LoadByWorkId(workId, companyId);
// ... Verify if work has cipp information to load run details
if (workFullLengthLiningWetOutGateway.Table.Rows.Count > 0)
{
string[] runDetailsList = runDetails.Split('>');
for (int i = 0; i < runDetailsList.Length; i++)
{
cbxlSectionId.Items.FindByValue(runDetailsList[i]).Selected = true;
cbxlInversionDataSectionId.Items.FindByValue(runDetailsList[i]).Selected = true;
}
}
else
{
if (cbxlSectionId.Items.Count > 1)
{
cbxlSectionId.Items.FindByValue(runDetails).Selected = true;
}
}
// SelectIndex for grids
((DropDownList)grdLaterals.FooterRow.FindControl("ddlNewMaterial")).SelectedIndex = 0;
((DropDownList)grdCatalysts.FooterRow.FindControl("ddlNameFooter")).SelectedIndex = 0;
// For usmh, dsmh autocomplete
string provinceId_ = "0"; if (hdfProvinceId.Value != "") provinceId_ = hdfProvinceId.Value;
string countyId_ = "0"; if (hdfCountyId.Value != "") countyId_ = hdfCountyId.Value;
string cityId_ = "0"; if (hdfCityId.Value != "") cityId_ = hdfCityId.Value;
aceUsmh.ContextKey = hdfCountryId.Value + "," + provinceId_ + "," + countyId_ + "," + cityId_ + "," + hdfCompanyId.Value;
aceDsmh.ContextKey = hdfCountryId.Value + "," + provinceId_ + "," + countyId_ + "," + cityId_ + "," + hdfCompanyId.Value;
// Make Wetout tab visible
if (ckbxWetOutDataIncludeWetOutInformation.Checked)
{
pnlVisibleInformation.Visible = true;
upnlVisibleInformation.Update();
}
else
{
pnlVisibleInformation.Visible = false;
upnlVisibleInformation.Update();
}
// Make inversion tab visible
lblInversionDataInversionMissingData.Visible = false;
uplInversionDataInversionMissingData.Update();
if (ckbxInversionDataIncludeInversionInformation.Checked)
{
// ... ... visible only if wet out information is provided.
if (!ckbxWetOutDataIncludeWetOutInformation.Checked)
{
pnlInversionVisibleInformation.Visible = false;
upnlInversionVisibleInformation.Update();
}
else
{
pnlInversionVisibleInformation.Visible = true;
upnlInversionVisibleInformation.Update();
}
}
else
{
pnlInversionVisibleInformation.Visible = false;
upnlInversionVisibleInformation.Update();
}
// Load Materials
MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(materialInformationTDS);
materialInformationGateway.LoadAllByAssetId(assetId, companyId);
materialInformation = materialInformationTDS.MaterialInformation;
Session["materialInformationTDS"] = materialInformationTDS;
}
}
else
{
// Restore datasets
fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"];
flatSectionJlTDSForFLL = (FlatSectionJlTDS)Session["flatSectionJlTDSForFLL"];
materialInformationTDS = (MaterialInformationTDS)Session["materialInformationTDS"];
materialInformation = materialInformationTDS.MaterialInformation;
// Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcFlDetails.ActiveTabIndex = activeTab;
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_EDIT"])) || !(Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_EDIT"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Validate query string
if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["asset_id"] == null) || ((string)Request.QueryString["work_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in asset_sewer_material.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfAssetId.Value = Convert.ToString(Request.QueryString["asset_id"]);
hdfWorkId.Value = Convert.ToString(Request.QueryString["work_id"]);
hdfUpdate.Value = "yes";
Session.Remove("materialInformationNewDummy");
Session.Remove("materialInformation");
// If coming from
// ... fl_edit.aspx or ra_edit.aspx
if ((Request.QueryString["source_page"] == "fl_edit.aspx") || (Request.QueryString["source_page"] == "ra_edit.aspx"))
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// ... Load materials to edit
materialInformationTDS = new MaterialInformationTDS();
// Get workId
int assetId = Int32.Parse(hdfAssetId.Value.Trim());
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(materialInformationTDS);
materialInformationGateway.LoadAllByAssetId(assetId, companyId);
// ... Store datasets
Session["materialInformationTDS"] = materialInformationTDS;
Session["materialInformation"] = materialInformationTDS.MaterialInformation;
}
}
else
{
// Restore datasets
materialInformationTDS = (MaterialInformationTDS)Session["materialInformationTDS"];
materialInformation = materialInformationTDS.MaterialInformation;
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
// Set active toolbar
mForm6 master = (mForm6)this.Master;
master.ActiveToolbar = "eSewers";
// For error message
lblWetOutDataWarning.Visible = false;
if (tbxWetOutDataHoistHeight.Text == "OK")
{
lblWetOutDataWarning.Visible = false;
}
else
{
lblWetOutDataWarning.Visible = true;
}
// For Material
int companyId = Int32.Parse(hdfCompanyId.Value);
int assetId = Int32.Parse(hdfAssetId.Value);
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway();
materialInformationGateway.LoadLastMaterialByAssetId(assetId, companyId);
if (materialInformationGateway.Table.Rows.Count > 0)
{
tbxM1DataMaterial.Text = materialInformationGateway.GetLastMaterialType(assetId);
}
// Hide or Show the Old CWP ID field
if (tbxOldCwpId.Text == "")
{
lblOldCwpId.Visible = false;
tbxOldCwpId.Visible = false;
}
if (tbxFlowOrderId.Text == "")
{
LoadFullLengthLiningData(currentProjectId, assetId, companyId);
}
// Validate tools
if (Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_ADMIN"]))
{
tkrpbLeftMenuTools.Items[0].Items[1].Visible = true; // Resins option
tkrpbLeftMenuTools.Items[0].Items[2].Visible = true; // Catalyst option
}
else
{
tkrpbLeftMenuTools.Items[0].Items[1].Visible = false; // Resins option
tkrpbLeftMenuTools.Items[0].Items[2].Visible = false; // Catalyst option
}
// Make Wetout tab visible
if (ckbxWetOutDataIncludeWetOutInformation.Checked)
{
upnlVisibleInformation.Visible = true;
}
else
{
upnlVisibleInformation.Visible = false;
}
// Make inversion tab visible
if (ckbxInversionDataIncludeInversionInformation.Checked)
{
upnlInversionVisibleInformation.Visible = true;
}
else
{
upnlInversionVisibleInformation.Visible = false;
}
}
protected void grdMaterials_RowDataBound(object sender, GridViewRowEventArgs e)
{
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate))))
{
int assetId = Int32.Parse(hdfAssetId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
int refId = Int32.Parse(((Label)e.Row.FindControl("lblRefIDEdit")).Text.Trim());
MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(materialInformationTDS);
string materialType = materialInformationGateway.GetMaterialType(assetId, refId);
((DropDownList)e.Row.FindControl("ddlMaterialTypeEdit")).SelectedValue = materialType;
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
bool isFromTabClick = false;
if (!IsPostBack)
{
if (!isFromTabClick)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_EDIT"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Validate query string
if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["client_id"] == null) || ((string)Request.QueryString["project_id"] == null) || ((string)Request.QueryString["asset_id"] == null) || ((string)Request.QueryString["active_tab"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in ra_edit.aspx");
}
// Tag Page
TagPage();
// Prepare initial data
Session.Remove("raAddLateralsNewDummy");
Session.Remove("materialInformationTDS");
materialInformationTDS = new MaterialInformationTDS();
// If coming from
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
int assetId = Int32.Parse(hdfAssetId.Value.Trim());
int workId = Int32.Parse(hdfWorkId.Value.Trim());
int workIdFll = Int32.Parse(hdfWorkIdFll.Value.Trim());
string workType = hdfWorkType.Value;
// ... ra_navigator2.aspx
if (Request.QueryString["source_page"] == "ra_navigator2.aspx")
{
StoreNavigatorState();
ViewState["update"] = "no";
// ... Set initial tab
if ((string)Session["dialogOpenedRa"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
rehabAssessmentTDS = new RehabAssessmentTDS();
RehabAssessmentSectionDetails rehabAssessmentSectionDetails = new RehabAssessmentSectionDetails(rehabAssessmentTDS);
rehabAssessmentSectionDetails.LoadByWorkId(workId, companyId);
RehabAssessmentWorkDetails rehabAssessmentWorkDetails = new RehabAssessmentWorkDetails(rehabAssessmentTDS);
rehabAssessmentWorkDetails.LoadByWorkId(workId, companyId);
RehabAssessmentLateralDetails rehabAssessmentLateralDetails = new RehabAssessmentLateralDetails(rehabAssessmentTDS);
rehabAssessmentLateralDetails.LoadForEdit(workIdFll, assetId, companyId, currentProjectId);
}
else
{
hdfActiveTab.Value = (string)Session["activeTabRa"];
// Restore dataset
rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"];
}
// Store dataset
Session["rehabAssessmentTDS"] = rehabAssessmentTDS;
}
// ... ra_summary.aspx or ra_edit.aspx
if ((Request.QueryString["source_page"] == "ra_summary.aspx") || (Request.QueryString["source_page"] == "ra_edit.aspx"))
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// ... Set initial tab
if ((string)Session["dialogOpenedRa"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
}
else
{
hdfActiveTab.Value = (string)Session["activeTabRa"];
}
if (ViewState["update"].ToString().Trim() == "yes")
{
rehabAssessmentTDS = new RehabAssessmentTDS();
RehabAssessmentSectionDetails rehabAssessmentSectionDetails = new RehabAssessmentSectionDetails(rehabAssessmentTDS);
rehabAssessmentSectionDetails.LoadByWorkId(workId, companyId);
RehabAssessmentWorkDetails rehabAssessmentWorkDetails = new RehabAssessmentWorkDetails(rehabAssessmentTDS);
rehabAssessmentWorkDetails.LoadByWorkId(workId, companyId);
RehabAssessmentLateralDetails rehabAssessmentLateralDetails = new RehabAssessmentLateralDetails(rehabAssessmentTDS);
rehabAssessmentLateralDetails.LoadForEdit(workIdFll, assetId, companyId, currentProjectId);
// Store dataset
Session["rehabAssessmentTDS"] = rehabAssessmentTDS;
}
// Restore dataset
rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"];
}
// Prepare initial data
lblMissingData.Visible = false;
// Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcRaDetails.ActiveTabIndex = activeTab;
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
if (name.Length > 23) name = name.Substring(0, 20) + "...";
lblTitleProjectName.Text = " > Project: " + name + " (" + projectGateway.GetProjectNumber(currentProjectId) + ") > Selected Section";
// ... Data for current work
LoadRehabAssessmentData(currentProjectId, assetId, companyId);
// Databind
Page.DataBind();
((DropDownList)grdLaterals.FooterRow.FindControl("ddlNewMaterial")).SelectedIndex = 0;
// For usmh, dsmh autocomplete
string provinceId_ = "0"; if (hdfProvinceId.Value != "") provinceId_ = hdfProvinceId.Value;
string countyId_ = "0"; if (hdfCountyId.Value != "") countyId_ = hdfCountyId.Value;
string cityId_ = "0"; if (hdfCityId.Value != "") cityId_ = hdfCityId.Value;
aceUsmh.ContextKey = hdfCountryId.Value + "," + provinceId_ + "," + countyId_ + "," + cityId_ + "," + hdfCompanyId.Value;
aceDsmh.ContextKey = hdfCountryId.Value + "," + provinceId_ + "," + countyId_ + "," + cityId_ + "," + hdfCompanyId.Value;
// Load Materials
MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(materialInformationTDS);
materialInformationGateway.LoadAllByAssetId(assetId, companyId);
materialInformation = materialInformationTDS.MaterialInformation;
Session["materialInformationTDS"] = materialInformationTDS;
}
}
else
{
// Restore datasets
rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"];
flatSectionJlTDSForRA = (FlatSectionJlTDS)Session["flatSectionJlTDSForRA"];
materialInformationTDS = (MaterialInformationTDS)Session["materialInformationTDS"];
materialInformation = materialInformationTDS.MaterialInformation;
// Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcRaDetails.ActiveTabIndex = activeTab;
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
// Set active toolbar
mForm8 master = (mForm8)this.Master;
master.ActiveToolbar = "eSewers";
// For error message
hdfErrorFieldList.Value = "";
// For Video Done From MH and Measured From MH
int companyId = Int32.Parse(hdfCompanyId.Value);
int assetId = Int32.Parse(hdfAssetId.Value);
int workId = Int32.Parse(hdfWorkId.Value);
int workIdFll = Int32.Parse(hdfWorkIdFll.Value);
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
RehabAssessmentWorkDetailsGateway raWorkDetailsGateway = new RehabAssessmentWorkDetailsGateway();
raWorkDetailsGateway.LoadByWorkId(workId, companyId);
RehabAssessmentLateralDetails raLateralDetails = new RehabAssessmentLateralDetails();
raLateralDetails.LoadForEdit(workIdFll, assetId, companyId, currentProjectId);
if (Int32.Parse(tbxLaterals.Text) > 0)
{
ddlM1DataVideoDoneFromMh.Visible = false;
tbxM1DataVideoDoneFromMh.Visible = true;
tbxM1DataVideoDoneFromMh.Text = ddlM1DataVideoDoneFromMh.SelectedValue;
ddlM1DataVideoDoneToMh.Visible = false;
tbxM1DataVideoDoneToMh.Visible = true;
tbxM1DataVideoDoneToMh.Text = ddlM1DataVideoDoneToMh.SelectedValue;
ddlM1DataMeasuredFromMh.Visible = false;
tbxM1DataMeasuredFromMh.Visible = true;
tbxM1DataMeasuredFromMh.Text = ddlM1DataMeasuredFromMh.SelectedValue;
btnClear.Visible = false;
}
else
{
ddlM1DataVideoDoneFromMh.Visible = true;
tbxM1DataVideoDoneFromMh.Visible = false;
ddlM1DataVideoDoneToMh.Visible = true;
tbxM1DataVideoDoneToMh.Visible = false;
ddlM1DataMeasuredFromMh.Visible = true;
tbxM1DataMeasuredFromMh.Visible = false;
btnClear.Visible = true;
}
// For materials
// ... Load material for m1
MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway();
materialInformationGateway.LoadLastMaterialByAssetId(assetId, companyId);
if (materialInformationGateway.Table.Rows.Count > 0)
{
ddlM1DataMaterial.SelectedValue = materialInformationGateway.GetLastMaterialType(assetId);
}
// Hide or show the Old CWP ID field
if (tbxOldCwpId.Text == "")
{
lblOldCwpId.Visible = false;
tbxOldCwpId.Visible = false;
}
if (tbxFlowOrderId.Text == "")
{
LoadRehabAssessmentData(currentProjectId, assetId, companyId);
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
// Set active toolbar
mForm6 master = (mForm6)this.Master;
master.ActiveToolbar = "eSewers";
// For materials
// ... Load material for m1
int companyId = Int32.Parse(hdfCompanyId.Value);
int assetId = Int32.Parse(hdfAssetId.Value);
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway();
materialInformationGateway.LoadLastMaterialByAssetId(assetId, companyId);
if (materialInformationGateway.Table.Rows.Count > 0)
{
tbxM1DataMaterial.Text = materialInformationGateway.GetLastMaterialType(assetId);
}
// Hide or show the Old CWP ID field
if (tbxOldCwpId.Text == "")
{
lblOldCwpId.Visible = false;
tbxOldCwpId.Visible = false;
}
if (tbxFlowOrderId.Text == "")
{
LoadRehabAssessmentData(currentProjectId, assetId, companyId);
}
}
/// <summary>
/// Insert a material
/// </summary>
/// <param name="lateral_assetId">lateral_assetId</param>
/// <param name="material">material</param>
/// <param name="companyId">companyId</param>
private void InsertMaterial(int lateral_assetId, string material, int companyId)
{
LfsAssetSewerLateralGateway lfsAssetSewertLateralGateway = new LfsAssetSewerLateralGateway(null);
if (!lfsAssetSewertLateralGateway.IsUsedInMaterials(lateral_assetId, material, companyId))
{
MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway();
materialInformationGateway.LoadAllByAssetId(lateral_assetId, companyId);
AssetSewerMaterial assetSewerMaterial = new AssetSewerMaterial(materialInformationGateway.Data);
assetSewerMaterial.InsertDirect(lateral_assetId, materialInformationGateway.Table.Rows.Count + 1, material, DateTime.Now, false, companyId);
}
}