// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_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["work_type"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in flat_section_jl_edit.aspx");
}
// Tag Page
TagPage();
// Prepare initial data
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
string name = projectGateway.GetName(currentProjectId);
if (name.Length > 23) name = name.Substring(0, 16) + "...";
lblTitleProjectName.Text = " > Project: " + name + " (" + projectGateway.GetProjectNumber(currentProjectId) + ") > Selected Laterals";
// If coming from
// ... jl_navigator2.aspx
if (Request.QueryString["source_page"] == "jl_navigator2.aspx")
{
StoreNavigatorState();
ViewState["update"] = "no";
}
// ... flat_section_jl_summary.aspx
if (Request.QueryString["source_page"] == "flat_section_jl_summary.aspx")
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
}
// Restore datasets
flatSectionJlTDS = (FlatSectionJlTDS)Session["flatSectionJlTDS"];
DataView dataViewFlatSectionJl = new DataView(flatSectionJlTDS.FlatSectionJl);
dataViewFlatSectionJl.RowFilter = "(Selected = 1) AND (Deleted = 0)";
grdvJl.DataSource = dataViewFlatSectionJl;
//DataBind
odsCoPitLocation.DataBind();
odsFlange.DataBind();
grdvJl.DataBind();
if (Session["rowFocus"] != null)
{
this.SetFocusGridView();
}
// FooterMenu
tbFooterToolbar.Visible = true;
if (grdvJl.Rows.Count == 1)
{
tbFooterToolbar.Visible = false;
}
}
else
{
// Restore datasets
flatSectionJlTDS = (FlatSectionJlTDS)Session["flatSectionJlTDS"];
DataView dataViewFlatSectionJl = new DataView(flatSectionJlTDS.FlatSectionJl);
dataViewFlatSectionJl.RowFilter = "(Selected = 1) AND (Deleted = 0)";
grdvJl.DataSource = dataViewFlatSectionJl;
//DataBind
grdvJl.DataBind();
// FooterMenu
tbFooterToolbar.Visible = true;
if (grdvJl.Rows.Count == 1)
{
tbFooterToolbar.Visible = false;
}
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_VIEW"]))
{
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))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in pr_lining_plan.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString();
hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString();
hdfWorkType.Value = "Point Repairs";
// Prepare initial data
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
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) + ") > Lining Plan";
// ... for the grid
prLiningPlanTDS = new PlLiningPlanTDS();
int projectId = Int32.Parse(hdfCurrentProjectId.Value);
PrLiningPlanGateway prLiningPlanGateway = new PrLiningPlanGateway(prLiningPlanTDS);
prLiningPlanGateway.ClearBeforeFill = false;
prLiningPlanGateway.Load(projectId, companyId);
grdLiningPlan.DataSource = prLiningPlanGateway.Table;
grdLiningPlan.DataBind();
// Check results
if (prLiningPlanTDS.PlLiningPlan.Rows.Count > 0)
{
tPreview.Visible = true;
tdNoResults.Visible = false;
tbFooterToolbar.Visible = true;
}
else
{
tPreview.Visible = false;
tdNoResults.Visible = true;
tbFooterToolbar.Visible = false;
}
// Check results
if (prLiningPlanTDS.PlLiningPlan.Rows.Count == 1)
{
tbFooterToolbar.Visible = false;
}
// Store dataset
Session["prLiningPlanTDS"] = prLiningPlanTDS;
}
else
{
// Restore dataset
prLiningPlanTDS = (PlLiningPlanTDS)Session["prLiningPlanTDS"];
// ... for the grid
PrLiningPlanGateway prLiningPlanGateway = new PrLiningPlanGateway(prLiningPlanTDS);
grdLiningPlan.DataSource = prLiningPlanGateway.Table;
grdLiningPlan.DataBind();
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_MANHOLEREHABILITATION_VIEW"])))
{
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["in_project"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in mr_navigator2.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString();
hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString();
hdfInProject.Value = Request.QueryString["in_project"].ToString();
hdfWorkType.Value = "Manhole Rehabilitation";
// Prepare initial data
// ... For sortByList
odsSortByList.DataBind();
ddlSortBy.DataSourceID = "odsSortByList";
ddlSortBy.DataValueField = "SortID";
ddlSortBy.DataTextField = "Name";
ddlSortBy.DataBind();
// ... For
odsViewForDisplayList.DataBind();
ddlCondition1.DataSourceID = "odsViewForDisplayList";
ddlCondition1.DataValueField = "ConditionID";
ddlCondition1.DataTextField = "Name";
ddlCondition1.DataBind();
// ... For view ddl
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
string workType = hdfWorkType.Value;
int loginId = Convert.ToInt32(Session["loginID"]);
string viewTypeGlobal = "";
string viewTypePersonal = "Personal";
// Global Views check
if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"]))
{
viewTypeGlobal = "Global";
}
WorkViewList workViewList = new WorkViewList();
workViewList.LoadAndAddItem(workType, viewTypeGlobal, viewTypePersonal, loginId, companyId);
ddlView.DataSource = workViewList.Table;
ddlView.DataValueField = "ViewID";
ddlView.DataTextField = "Name";
ddlView.DataBind();
ddlView.SelectedIndex = 1;
// Validate top information
if ((hdfCurrentClientId.Value != "0") && (hdfCurrentProjectId.Value != "0"))
{
// ... 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
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
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) + ")";
}
else
{
lblTitleClientName.Text = "";
lblTitleProjectName.Text = "";
}
// If coming from
// ... mr_navigator.aspx or mr_navigator2.aspx
if ((Request.QueryString["source_page"] == "mr_navigator.aspx") || (Request.QueryString["source_page"] == "mr_navigator2.aspx"))
{
RestoreNavigatorState();
mrNavigatorTDS = (MrNavigatorTDS)Session["mrNavigatorTDS"];
}
// ... mr_edit.aspx, mr_summary.aspx or mr_delete.aspx
if ((Request.QueryString["source_page"] == "mr_edit.aspx") || (Request.QueryString["source_page"] == "mr_summary.aspx") || (Request.QueryString["source_page"] == "mr_delete.aspx"))
{
RestoreNavigatorState();
if (Request.QueryString["update"] == "no")
{
mrNavigatorTDS = (MrNavigatorTDS)Session["mrNavigatorTDS"];
}
else
{
// ... Delete store data
Session.Contents.Remove("mrNavigatorTDS");
// ... Search data with updates
if (hdfBtnOrigin.Value == "Search")
{
mrNavigatorTDS = SubmitSearch();
}
else
{
if (hdfBtnOrigin.Value == "Go")
{
mrNavigatorTDS = SubmitSearchForViews();
}
}
// ... store datasets
Session["mrNavigatorTDS"] = mrNavigatorTDS;
}
}
// ... mr_delete.aspx, mr_summary.aspx or mr_edit.aspx
if ((Request.QueryString["source_page"] == "mr_delete.aspx") || (Request.QueryString["source_page"] == "mr_summary.aspx") || (Request.QueryString["source_page"] == "mr_edit.aspx"))
{
if (mrNavigatorTDS.MrNavigator.Rows.Count == 0)
{
string url = "./mr_navigator.aspx?source_page=mr_navigator2.aspx&client_id=" + hdfCurrentClientId.Value + "&project_id=" + hdfCurrentProjectId.Value + "&work_type=" + hdfWorkType.Value + "&in_project=" + hdfInProject.Value + GetNavigatorState() + "&no_results=yes";
Response.Redirect(url);
}
}
// For the grid
grdMRNavigator.DataSource = mrNavigatorTDS.MrNavigator;
grdMRNavigator.DataBind();
//... for the total rows
if (mrNavigatorTDS.MrNavigator.Rows.Count > 0)
{
lblTotalRows.Text = "Total Rows: " + mrNavigatorTDS.MrNavigator.Rows.Count;
lblTotalRows.Visible = true;
}
else
{
lblTotalRows.Visible = false;
}
}
else
{
// Restore TDS
mrNavigatorTDS = (MrNavigatorTDS)Session["mrNavigatorTDS"];
// ... for the total rows
if (mrNavigatorTDS.MrNavigator.Rows.Count > 0)
{
lblTotalRows.Text = "Total Rows: " + mrNavigatorTDS.MrNavigator.Rows.Count;
lblTotalRows.Visible = true;
}
else
{
lblTotalRows.Visible = false;
}
}
}
protected void btnExportList_Click(object sender, EventArgs e)
{
string url = "";
string headerValues = "";
int totalColumnsExport = 40;
int totalColumnsPreview = 39;
string client = "";
string name = "";
string project = "";
string title = "Point Repairs Search Results";
string columnsForReport = "";
int j;
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
client += "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
project = projectGateway.GetName(currentProjectId);
name = client + " > Project: " + project + " (" + projectGateway.GetProjectNumber(currentProjectId) + ")";
// ... for title view
if (hdfBtnOrigin.Value == "Go")
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
// ... Load name view
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(viewId, companyId);
title = workViewGateway.GetName(viewId);
}
// ... For comments option
string comments = "None";
headerValues = "";
columnsForReport = "";
// Establishing header values
if (grdPrNavigator.Columns[2].Visible) headerValues += "ID (Section)";
if (grdPrNavigator.Columns[3].Visible) headerValues += " * Sub Area";
if (grdPrNavigator.Columns[4].Visible) headerValues += " * Street";
if (grdPrNavigator.Columns[5].Visible) headerValues += " * USMH";
if (grdPrNavigator.Columns[6].Visible) headerValues += " * USMH Address";
if (grdPrNavigator.Columns[7].Visible) headerValues += " * DSMH";
if (grdPrNavigator.Columns[8].Visible) headerValues += " * DSMH Address";
if (grdPrNavigator.Columns[9].Visible) headerValues += " * Map Size";
if (grdPrNavigator.Columns[10].Visible) headerValues += " * Confirmed Size";
if (grdPrNavigator.Columns[11].Visible) headerValues += " * Map Length";
if (grdPrNavigator.Columns[12].Visible) headerValues += " * Steel Tape Length";
if (grdPrNavigator.Columns[13].Visible) headerValues += " * Video Length";
if (grdPrNavigator.Columns[14].Visible) headerValues += " * Laterals";
if (grdPrNavigator.Columns[15].Visible) headerValues += " * Live Laterals";
if (grdPrNavigator.Columns[16].Visible) headerValues += " * Client ID";
if (grdPrNavigator.Columns[17].Visible) headerValues += " * Measurements Taken By";
if (grdPrNavigator.Columns[18].Visible) headerValues += " * Pre-Flush Date";
if (grdPrNavigator.Columns[19].Visible) headerValues += " * Pre-Video Date";
if (grdPrNavigator.Columns[20].Visible) headerValues += " * P1 Date";
if (grdPrNavigator.Columns[21].Visible) headerValues += " * Repair Confirmation Date";
if (grdPrNavigator.Columns[22].Visible) headerValues += " * Traffic Control";
if (grdPrNavigator.Columns[23].Visible) headerValues += " * Material";
if (grdPrNavigator.Columns[24].Visible) headerValues += " * Bypass Required?";
if (grdPrNavigator.Columns[25].Visible) headerValues += " * Robotic Prep Required?";
if (grdPrNavigator.Columns[26].Visible) headerValues += " * CXI’s Removed";
if (grdPrNavigator.Columns[27].Visible) headerValues += " * Robotic Distances";
if (grdPrNavigator.Columns[28].Visible) headerValues += " * Proposed Lining Date";
if (grdPrNavigator.Columns[29].Visible) headerValues += " * Deadline Lining Date";
if (grdPrNavigator.Columns[30].Visible) headerValues += " * Final Video";
if (grdPrNavigator.Columns[31].Visible) headerValues += " * Estimated Joints";
if (grdPrNavigator.Columns[32].Visible) headerValues += " * Joints Test Sealed";
if (grdPrNavigator.Columns[33].Visible) headerValues += " * Issue Identified?";
if (grdPrNavigator.Columns[34].Visible) headerValues += " * LFS Issue?";
if (grdPrNavigator.Columns[35].Visible) headerValues += " * Client Issue?";
if (grdPrNavigator.Columns[36].Visible) headerValues += " * Sales Issue?";
if (grdPrNavigator.Columns[37].Visible) headerValues += " * Issue Given To Client?";
if (grdPrNavigator.Columns[38].Visible) headerValues += " * Issue Investigation?";
if (grdPrNavigator.Columns[39].Visible) headerValues += " * Issue Resolved?";
if (grdPrNavigator.Columns[40].Visible) headerValues += " * Comments";
if (grdPrNavigator.Columns[41].Visible) headerValues += " * Repair";
// Establishing columns to display
string[] columnsExcel = headerValues.Split('*');
// ... for visible columns
for (int i = 0; i < columnsExcel.Length; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=" + columnsExcel[i].Trim();
}
// ... For not visible columns
for (int i = columnsExcel.Length; i < totalColumnsExport; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=None";
}
// Report call
Page.Validate();
if (Page.IsValid)
{
PostPageChanges();
title = title.Replace("'", "%27");
Response.Write("<script language='javascript'> {window.open('./pr_print_search_results_report.aspx?" + columnsForReport + "&comments=" + comments + "&totalColumnsPreview=" + totalColumnsPreview + "&totalColumnsExport=" + totalColumnsExport + "&totalSelectedColumns=" + columnsExcel.Length + "&name=" + Server.UrlEncode(name) + "&title=" + Server.UrlEncode(title) + "&format=excel', '_blank', 'toolbar=no, location=no, directories=no, status=yes, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=800, height=680');}</script>");
}
if (url != "") Response.Redirect(url);
}
// ////////////////////////////////////////////////////////////////////////
// METHODS
//
private void Save()
{
bool existsAtGrid = false;
// Validate page
if (Page.IsValid)
{
SelectProjectLastUsedProjectsGateway selectProjectLastUsedProjectsVerifyGateway = new SelectProjectLastUsedProjectsGateway(selectProjectTDS);
if (selectProjectLastUsedProjectsVerifyGateway.Table.Rows.Count > 0)
{
// If exists the project in the grid
foreach (GridViewRow row in grdProjects.Rows)
{
// Grid Data
int gridClientId = Int32.Parse(((Label)row.FindControl("lblClientId")).Text.Trim());
int gridProjectId = Int32.Parse(((Label)row.FindControl("lblProjectId")).Text.Trim());
int gridUserId = Int32.Parse(((Label)row.FindControl("lblUserId")).Text.Trim());
int gridCompanyId = Int32.Parse(((Label)row.FindControl("lblCompanyId")).Text.Trim());
DateTime gridLastLoggedInDate = DateTime.Parse(((Label)row.FindControl("lblLastLoggedInDate")).Text.Trim());
string workType = hdfWorkType.Value;
// New Data
DateTime newLastLoggedInDate = DateTime.Now;
if ((gridClientId.ToString() == ddlClient.SelectedValue) && (gridProjectId.ToString() == ddlProject.SelectedValue) && (gridUserId == Int32.Parse(hdfLoginId.Value)) && (gridCompanyId == Int32.Parse(hdfCompanyId.Value)))
{
// Update if exists
SelectProjectLastUsedProjects model = new SelectProjectLastUsedProjects(selectProjectTDS);
model.UpdateLogginDate(gridClientId, gridProjectId, gridUserId, gridLastLoggedInDate, gridCompanyId, false, workType, newLastLoggedInDate);
existsAtGrid = true;
}
Session["selectProjectTDS"] = selectProjectTDS;
Session["lastUsedProjects"] = selectProjectTDS.LastUsedProjects;
grdProjects.DataBind();
grdProjects.PageIndex = grdProjects.PageCount - 1;
}
}
// If doesn't exists at grid
if (!existsAtGrid)
{
if (grdProjects.Rows.Count < 5)
{
// Add data if exist at grid's foot
GrdProjectAdd();
}
else
{
int index = 1;
foreach (GridViewRow row in grdProjects.Rows)
{
if (index == 5)
{
// Grid Data
int gridClientId = Int32.Parse(((Label)row.FindControl("lblClientId")).Text.Trim());
int gridProjectId = Int32.Parse(((Label)row.FindControl("lblProjectId")).Text.Trim());
int gridUserId = Int32.Parse(((Label)row.FindControl("lblUserId")).Text.Trim());
int gridCompanyId = Int32.Parse(((Label)row.FindControl("lblCompanyId")).Text.Trim());
DateTime gridLastLoggedInDate = DateTime.Parse(((Label)row.FindControl("lblLastLoggedInDate")).Text.Trim());
string workType = hdfWorkType.Value;
// New Data
int newProjectId = Int32.Parse(ddlProject.SelectedValue);
int newClientId = Int32.Parse(ddlClient.SelectedValue);
int newCompanyId = Int32.Parse(hdfCompanyId.Value);
int newUserId = Convert.ToInt32(Session["loginID"]);
DateTime newLastLoggedInDate = DateTime.Now;
string newWorkType = hdfWorkType.Value;
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(newProjectId);
string newProjectName = projectGateway.GetName(newProjectId) + " (" + projectGateway.GetProjectNumber(newProjectId) + ")";
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(newClientId, companyId);
string newClientName = companiesGateway.GetName(newClientId);
// Update if exists
SelectProjectLastUsedProjects model = new SelectProjectLastUsedProjects(selectProjectTDS);
model.Update(gridClientId, gridProjectId, gridUserId, gridCompanyId, workType, newClientId, newProjectId, newUserId, newLastLoggedInDate, newCompanyId, false, newWorkType, newProjectName, newClientName);
}
index = index + 1;
}
Session["selectProjectTDS"] = selectProjectTDS;
Session["lastUsedProjects"] = selectProjectTDS.LastUsedProjects;
grdProjects.DataBind();
grdProjects.PageIndex = grdProjects.PageCount - 1;
}
}
// Update data at bd
UpdateDatabase();
}
}
// ////////////////////////////////////////////////////////////////////////
// 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_MANHOLEREHABILITATION_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_MANHOLEREHABILITATION_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) || ((string)Request.QueryString["in_project"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in mr_edit.aspx");
}
// Tag Page
TagPage();
// 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;
lblNotLastBatch.Visible = false;
// ... mr_navigator2.aspx
if (Request.QueryString["source_page"] == "mr_navigator2.aspx")
{
StoreNavigatorState();
ViewState["update"] = "no";
// ... Set initial tab
if ((string)Session["dialogOpenedMr"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
manholeRehabilitationTDS = new ManholeRehabilitationTDS();
ManholeRehabilitationManholeDetails manholeRehabilitationManholeDetails = new ManholeRehabilitationManholeDetails(manholeRehabilitationTDS);
manholeRehabilitationManholeDetails.LoadByAssetId(assetId, companyId);
ManholeRehabilitationWorkDetails fullLengthLiningWorkDetails = new ManholeRehabilitationWorkDetails(manholeRehabilitationTDS);
fullLengthLiningWorkDetails.LoadByWorkIdAssetId(workId, assetId, companyId);
}
else
{
hdfActiveTab.Value = (string)Session["activeTabMr"];
// Restore datasets
manholeRehabilitationTDS = (ManholeRehabilitationTDS)Session["manholeRehabilitationTDS"];
}
// ... Store dataset
Session["manholeRehabilitationTDS"] = manholeRehabilitationTDS;
}
// ... mr_summary.aspx or mr_edit.aspx
if ((Request.QueryString["source_page"] == "mr_summary.aspx") || (Request.QueryString["source_page"] == "mr_edit.aspx"))
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// ... Restore dataset
manholeRehabilitationTDS = (ManholeRehabilitationTDS)Session["manholeRehabilitationTDS"];
// ... Set initial tab
if ((string)Session["dialogOpenedMr"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
}
else
{
hdfActiveTab.Value = (string)Session["activeTabMr"];
}
if (ViewState["update"].ToString().Trim() == "yes")
{
ManholeRehabilitationManholeDetails manholeRehabilitationManholeDetails = new ManholeRehabilitationManholeDetails(manholeRehabilitationTDS);
manholeRehabilitationManholeDetails.LoadByAssetId(assetId, companyId);
ManholeRehabilitationWorkDetails fullLengthLiningWorkDetails = new ManholeRehabilitationWorkDetails(manholeRehabilitationTDS);
fullLengthLiningWorkDetails.LoadByWorkIdAssetId(workId, assetId, companyId);
// ... Store dataset
Session["manholeRehabilitationTDS"] = manholeRehabilitationTDS;
}
}
// Set initial data
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcMrDetails.ActiveTabIndex = activeTab;
lblBatchDateRequired.Visible = false;
if ((hdfCurrentClientId.Value != "0") && (hdfCurrentProjectId.Value != "0"))
{
// ... 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 Manhole";
}
else
{
lblTitleClientName.Text = "";
lblTitleProjectName.Text = "";
}
// ... For batch dates
WorkManholeRehabilitationBatchList workManholeRehabilitationBatchList = new WorkManholeRehabilitationBatchList();
workManholeRehabilitationBatchList.LoadAndAddItem(-1, "(Select a batch)", companyId);
ddlRehabilitationBatchDate.DataSource = workManholeRehabilitationBatchList.Table;
ddlRehabilitationBatchDate.DataValueField = "BatchID";
ddlRehabilitationBatchDate.DataTextField = "Description";
ddlRehabilitationBatchDate.DataBind();
// ... ... Data for current manhole rehabilitation work
LoadManholeRehabilitationData(currentProjectId, assetId, companyId);
// ... ... Make panels visible
ShapeStructure();
// Databind
Page.DataBind();
// 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;
}
}
else
{
// Restore datasets
manholeRehabilitationTDS = (ManholeRehabilitationTDS)Session["manholeRehabilitationTDS"];
// Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcMrDetails.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_REHABASSESSMENT_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_DELETE"])))
{
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))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in ra_delete.aspx");
}
// Tag Page
TagPage();
// Prepare initial data
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
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 Sections";
// If coming from
// ... ra_navigator2.aspx
if (Request.QueryString["source_page"] == "ra_navigator2.aspx")
{
StoreNavigatorState();
ViewState["update"] = "no";
rehabAssessmentTDS = new RehabAssessmentTDS();
int workId = Int32.Parse(hdfWorkId.Value);
RehabAssessmentSectionDetails rehabAssessmentSectionDetails = new RehabAssessmentSectionDetails(rehabAssessmentTDS);
rehabAssessmentSectionDetails.LoadByWorkId(workId, companyId);
RehabAssessmentWorkDetails rehabAssessmentWorkDetails = new RehabAssessmentWorkDetails(rehabAssessmentTDS);
rehabAssessmentWorkDetails.LoadByWorkId(workId, companyId);
RehabAssessmentLateralDetails rehabAssessmentLateralDetails = new RehabAssessmentLateralDetails(rehabAssessmentTDS);
rehabAssessmentLateralDetails.LoadAllByWorkId(workId, companyId);
// Store dataset
Session["rehabAssessmentTDS"] = rehabAssessmentTDS;
}
// ... ra_summary.aspx
if (Request.QueryString["source_page"] == "ra_summary.aspx")
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// Restore dataset
rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"];
}
}
else
{
// Restore datasets
rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"];
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_VIEW"])))
{
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))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in jls_navigator2.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString();
hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString();
// Prepare initial data
// ... For sortByList
odsSortByList.DataBind();
ddlSortBy.DataSourceID = "odsSortByList";
ddlSortBy.DataValueField = "SortID";
ddlSortBy.DataTextField = "Name";
ddlSortBy.DataBind();
// ... For
odsViewForDisplayList.DataBind();
ddlCondition1.DataSourceID = "odsViewForDisplayList";
ddlCondition1.DataValueField = "ConditionID";
ddlCondition1.DataTextField = "Name";
ddlCondition1.DataBind();
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
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) + ")";
// If coming from
// ... jls_navigator.aspx or jls_navigator2.aspx
if ((Request.QueryString["source_page"] == "jls_navigator.aspx") || (Request.QueryString["source_page"] == "jls_navigator2.aspx"))
{
RestoreNavigatorState();
jlsNavigatorTDS = (JlsNavigatorTDS)Session["jlsNavigatorTDS"];
}
// ... flat_section_jls_edit.aspx, flat_section_jls_summary.aspx or jls_delete.aspx
if ((Request.QueryString["source_page"] == "flat_section_jls_edit.aspx") || (Request.QueryString["source_page"] == "flat_section_jls_summary.aspx") || (Request.QueryString["source_page"] == "jls_delete.aspx"))
{
RestoreNavigatorState();
if (Request.QueryString["update"] == "no")
{
jlsNavigatorTDS = (JlsNavigatorTDS)Session["jlsNavigatorTDS"];
}
else
{
// ... Delete store data
Session.Contents.Remove("jlsNavigatorTDS");
// ... Search data with updates
jlsNavigatorTDS = SubmitSearch();
// ... store datasets
Session["jlsNavigatorTDS"] = jlsNavigatorTDS;
// ... control of existing records
if (jlsNavigatorTDS.JlsNavigator.Rows.Count == 0)
{
string url = "./jls_navigator.aspx?source_page=jls_navigator2.aspx&client_id=" + hdfCurrentClientId.Value + "&project_id=" + hdfCurrentProjectId.Value + GetNavigatorState() + "&no_results=yes";
Response.Redirect(url);
}
}
}
// For the grid
grdJLNavigator.DataSource = jlsNavigatorTDS.JlsNavigator;
grdJLNavigator.DataBind();
// ... for the total rows
if (jlsNavigatorTDS.JlsNavigator.Rows.Count > 0)
{
lblTotalRows.Text = "Total Rows: " + jlsNavigatorTDS.JlsNavigator.Rows.Count;
lblTotalRows.Visible = true;
}
else
{
lblTotalRows.Visible = false;
}
}
else
{
// Restore TDS
jlsNavigatorTDS = (JlsNavigatorTDS)Session["jlsNavigatorTDS"];
// ... for the total rows
if (jlsNavigatorTDS.JlsNavigator.Rows.Count > 0)
{
lblTotalRows.Text = "Total Rows: " + jlsNavigatorTDS.JlsNavigator.Rows.Count;
lblTotalRows.Visible = true;
}
else
{
lblTotalRows.Visible = false;
}
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_VIEW"])))
{
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))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in jls_navigator.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString();
hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString();
// Prepare initial data
// ... For sortByList
odsSortByList.DataBind();
ddlSortBy.DataSourceID = "odsSortByList";
ddlSortBy.DataValueField = "SortID";
ddlSortBy.DataTextField = "Name";
ddlSortBy.DataBind();
// ... For
odsViewForDisplayList.DataBind();
ddlCondition1.DataSourceID = "odsViewForDisplayList";
ddlCondition1.DataValueField = "ConditionID";
ddlCondition1.DataTextField = "Name";
ddlCondition1.DataBind();
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
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) + ")";
// If coming from
// ... Left Menu
if ((Request.QueryString["source_page"] == "lm") || (Request.QueryString["source_page"] == "select_project.aspx"))
{
tdNoResults.Visible = false;
}
// ... jls_navigator2.aspx
if (Request.QueryString["source_page"] == "jls_navigator2.aspx")
{
RestoreNavigatorState();
if ((string)Request.QueryString["no_results"] == "yes")
{
tdNoResults.Visible = true;
}
else
{
tdNoResults.Visible = true;
}
}
}
}
// ////////////////////////////////////////////////////////////////////////
// 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;
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!Convert.ToBoolean(Session["sgLFS_APP_VIEW"]))
{
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"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in linning_plan.aspx");
}
// Tag page
hdfCurrentClient.Value = (string)Request.QueryString["client"];
// Prepare initial data
// ... for the client
int companyId = Int32.Parse(Session["companyID"].ToString());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(int.Parse(hdfCurrentClient.Value), companyId);
TextBox tbxCurrentClient = (TextBox)tkrpbLeftMenuCurrentClient.FindItemByValue("mCurrentClient").FindControl("tbxCurrentClient");
tbxCurrentClient.Text = companiesGateway.GetName(int.Parse(hdfCurrentClient.Value));
// ... for the grid
linningPlanTDS = new LinningPlanTDS();
LinningPlanGateway linningPlanGateway = new LinningPlanGateway(linningPlanTDS);
linningPlanGateway.ClearBeforeFill = false;
linningPlanGateway.LoadByCompaniesIdIssueWithLateralsNoOutOfScope(companyId, int.Parse(hdfCurrentClient.Value));
linningPlanGateway.LoadByCompaniesIdOtherIssueWithLaterals(companyId, int.Parse(hdfCurrentClient.Value));
grdLinningPlan.DataSource = linningPlanGateway.Table;
grdLinningPlan.DataBind();
// Check results
if (linningPlanTDS.LinningPlan.Rows.Count > 0)
{
pNoResults.Visible = false;
}
else
{
pNoResults.Visible = true;
}
// Store dataset
Session["linningPlanTDS"] = linningPlanTDS;
}
else
{
// Restore dataset
linningPlanTDS = (LinningPlanTDS) Session["linningPlanTDS"];
// ... for the grid
LinningPlanGateway linningPlanGateway = new LinningPlanGateway(linningPlanTDS);
linningPlanGateway.ClearBeforeFill = false;
int companyId = Int32.Parse(Session["companyID"].ToString());
linningPlanGateway.LoadByCompaniesIdIssueWithLateralsNoOutOfScope(companyId, int.Parse(hdfCurrentClient.Value));
linningPlanGateway.LoadByCompaniesIdOtherIssueWithLaterals(companyId, int.Parse(hdfCurrentClient.Value));
grdLinningPlan.DataSource = linningPlanGateway.Table;
grdLinningPlan.DataBind();
}
}
protected void btnPrintLateralLocationSheet_Click(object sender, EventArgs e)
{
string url = "";
string name = "";
string client = "";
string project = "";
string title = "Junction Lining Search Results";
int companyId = Int32.Parse(hdfCompanyId.Value);
int projectId = Int32.Parse(hdfCurrentProjectId.Value);
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
client += "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
project = projectGateway.GetName(currentProjectId);
name = client + " > Project: " + project + " (" + projectGateway.GetProjectNumber(currentProjectId) + ")";
// ... for title view
if (hdfBtnOrigin.Value == "Go")
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
// ... Load name view
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(viewId, companyId);
title = workViewGateway.GetName(viewId);
}
// ... For comments and history options
JlNavigator jlNavigator = new JlNavigator(jlNavigatorTDS);
// Report call
Page.Validate();
if (Page.IsValid)
{
PostPageChanges();
int assetId = GetFirstSectionAssetId();
if (assetId > 0)
{
Response.Write("<script language='javascript'> {window.open('./../../CWP/Common/jl_lateral_location_sheet_report.aspx?source_page=lm&project_id=" + hdfCurrentProjectId.Value + "&client_id=" + hdfCurrentClientId.Value + "', '_blank', 'toolbar=no, location=no, directories=no, status=yes, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=800, height=680');}</script>");
}
else
{
cvSelection.IsValid = false;
}
}
if (url != "") Response.Redirect(url);
}
protected void btnPreviewList_Click(object sender, EventArgs e)
{
string url = "";
string headerValues = "";
int totalColumnsPreview = 57;
int totalColumnsExport = 59;
string name = "";
string client = "";
string project = "";
string title = "Junction Lining Search Results";
int companyId = Int32.Parse(hdfCompanyId.Value);
int projectId = Int32.Parse(hdfCurrentProjectId.Value);
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
client += "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
project = projectGateway.GetName(currentProjectId);
name = client + " > Project: " + project + " (" + projectGateway.GetProjectNumber(currentProjectId) + ")";
// ... for title view
if (hdfBtnOrigin.Value == "Go")
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
// ... Load name view
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(viewId, companyId);
title = workViewGateway.GetName(viewId);
}
// ... For comments and history options
string comments = "None";
string history = "None";
JlNavigator jlNavigator = new JlNavigator(jlNavigatorTDS);
// Update for comments
jlNavigator.UpdateEnterForReport(projectId, companyId);
// Establishing header values
if (grdJLNavigator.Columns[2].Visible) headerValues += "LateralID";
if (grdJLNavigator.Columns[3].Visible) headerValues += " * Old CWP ID";
if (grdJLNavigator.Columns[4].Visible) headerValues += " * Client Lateral ID";
if (grdJLNavigator.Columns[5].Visible) headerValues += " * Hamilton Inspection Number";
if (grdJLNavigator.Columns[6].Visible) headerValues += " * Street";
if (grdJLNavigator.Columns[7].Visible) headerValues += " * MN";
if (grdJLNavigator.Columns[8].Visible) headerValues += " * USMH";
if (grdJLNavigator.Columns[9].Visible) headerValues += " * DSMH";
if (grdJLNavigator.Columns[10].Visible) headerValues += " * V1 Inspection";
if (grdJLNavigator.Columns[11].Visible) headerValues += " * Video Length To PL";
if (grdJLNavigator.Columns[12].Visible) headerValues += " * Depth Of Pipe";
if (grdJLNavigator.Columns[13].Visible) headerValues += " * Pipe Located";
if (grdJLNavigator.Columns[14].Visible) headerValues += " * Services Located";
if (grdJLNavigator.Columns[15].Visible) headerValues += " * Prep Type";
if (grdJLNavigator.Columns[16].Visible) headerValues += " * C/O Req.";
if (grdJLNavigator.Columns[17].Visible) headerValues += " * Pit Req.";
if (grdJLNavigator.Columns[18].Visible) headerValues += " * CO/Pit Location";
if (grdJLNavigator.Columns[19].Visible) headerValues += " * C/O Installed";
if (grdJLNavigator.Columns[20].Visible) headerValues += " * Backfilled Con.";
if (grdJLNavigator.Columns[21].Visible) headerValues += " * Backfilled Soil";
if (grdJLNavigator.Columns[22].Visible) headerValues += " * Grouted";
if (grdJLNavigator.Columns[23].Visible) headerValues += " * Cored";
if (grdJLNavigator.Columns[24].Visible) headerValues += " * Prepped";
if (grdJLNavigator.Columns[25].Visible) headerValues += " * Pre-Video";
if (grdJLNavigator.Columns[26].Visible) headerValues += " * Measured";
if (grdJLNavigator.Columns[27].Visible) headerValues += " * Connection Type";
if (grdJLNavigator.Columns[28].Visible) headerValues += " * Liner Type";
if (grdJLNavigator.Columns[29].Visible) headerValues += " * Flange";
if (grdJLNavigator.Columns[30].Visible) headerValues += " * Gasket";
if (grdJLNavigator.Columns[31].Visible) headerValues += " * Main Size";
if (grdJLNavigator.Columns[32].Visible) headerValues += " * Liner Size";
if (grdJLNavigator.Columns[33].Visible) headerValues += " * Lining Thru C/O";
if (grdJLNavigator.Columns[34].Visible) headerValues += " * Notice Delivered";
if (grdJLNavigator.Columns[35].Visible) headerValues += " * In Process";
if (grdJLNavigator.Columns[36].Visible) headerValues += " * In Stock";
if (grdJLNavigator.Columns[37].Visible) headerValues += " * Delivered";
if (grdJLNavigator.Columns[38].Visible) headerValues += " * Liner Installed";
if (grdJLNavigator.Columns[39].Visible) headerValues += " * Final Video";
if (grdJLNavigator.Columns[40].Visible) headerValues += " * Dist. From USMH";
if (grdJLNavigator.Columns[41].Visible) headerValues += " * Dist. From DSMH";
if (grdJLNavigator.Columns[42].Visible) headerValues += " * Post Contract Dig?";
if (grdJLNavigator.Columns[43].Visible) headerValues += " * C/O Cut Down?";
if (grdJLNavigator.Columns[44].Visible) headerValues += " * Final Restoration";
if (grdJLNavigator.Columns[45].Visible) headerValues += " * Cost";
if (grdJLNavigator.Columns[46].Visible) headerValues += " * Build / Rebuild";
if (grdJLNavigator.Columns[49].Visible) headerValues += " * Dig Required Prior To Lining";
if (grdJLNavigator.Columns[50].Visible) headerValues += " * Dig Required Prior To Lining Completed";
if (grdJLNavigator.Columns[51].Visible) headerValues += " * Dig Required After Lining";
if (grdJLNavigator.Columns[52].Visible) headerValues += " * Dig Required After Lining Completed";
if (grdJLNavigator.Columns[53].Visible) headerValues += " * Out Of Scope";
if (grdJLNavigator.Columns[54].Visible) headerValues += " * Hold - Client Issue";
if (grdJLNavigator.Columns[55].Visible) headerValues += " * Hold - Client Issue Resolved";
if (grdJLNavigator.Columns[56].Visible) headerValues += " * Hold - LFS Issue";
if (grdJLNavigator.Columns[57].Visible) headerValues += " * Hold - LFS Issue Resolved";
if (grdJLNavigator.Columns[58].Visible) headerValues += " * Requires Robotic Prep";
if (grdJLNavigator.Columns[59].Visible) headerValues += " * Requires Robotic Prep Completed";
// Establishing columns to display
string[] columns = headerValues.Split('*');
string columnsForReport = "";
int j;
// ... for visible columns
for (int i = 0; i < columns.Length; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=" + columns[i].Trim();
}
// ... For not visible columns
for (int i = columns.Length; i < totalColumnsPreview; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=None";
}
if (grdJLNavigator.Columns[47].Visible) { comments = "Comments"; }
if (grdJLNavigator.Columns[48].Visible) { history = "History"; }
// Report call
Page.Validate();
if (Page.IsValid)
{
PostPageChanges();
title = title.Replace("'", "%27");
Response.Write("<script language='javascript'> {window.open('./jl_print_search_results_report.aspx?" + columnsForReport + "&comments=" + comments + "&history=" + history + "&totalColumnsPreview=" + totalColumnsPreview + "&totalColumnsExport=" + totalColumnsExport + "&totalSelectedColumns=" + columns.Length + "&name=" + Server.UrlEncode(name) + "&title=" + Server.UrlEncode(title) + "&format=pdf', '_blank', 'toolbar=no, location=no, directories=no, status=yes, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=800, height=680');}</script>");
}
if (url != "") Response.Redirect(url);
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// 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))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in ra_summary.aspx");
}
// Tag Page
TagPage();
Session.Remove("raAddLateralsNewDummy");
// If coming from
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
int assetId = Int32.Parse(hdfAssetId.Value.Trim());
string workType = hdfWorkType.Value;
int workId = Int32.Parse(hdfWorkId.Value);
// ... ra_navigator2.aspx
if (Request.QueryString["source_page"] == "ra_navigator2.aspx")
{
StoreNavigatorState();
ViewState["update"] = "no";
// Set initial tab
if ((string)Session["dialogOpenedRa"] != "1")
{
rehabAssessmentTDS = new RehabAssessmentTDS();
RehabAssessmentSectionDetails rehabAssessmentSectionDetails = new RehabAssessmentSectionDetails(rehabAssessmentTDS);
rehabAssessmentSectionDetails.LoadByWorkId(workId, companyId);
RehabAssessmentWorkDetails rehabAssessmentWorkDetails = new RehabAssessmentWorkDetails(rehabAssessmentTDS);
rehabAssessmentWorkDetails.LoadByWorkId(workId, companyId);
int workIdFll = GetWorkId(currentProjectId, assetId, "Full Length Lining", companyId);
RehabAssessmentLateralDetails rehabAssessmentLateralDetails = new RehabAssessmentLateralDetails(rehabAssessmentTDS);
rehabAssessmentLateralDetails.LoadForEdit(workIdFll, assetId, companyId, currentProjectId);
hdfActiveTab.Value = Request.QueryString["active_tab"];
}
else
{
hdfActiveTab.Value = (string)Session["activeTabRa"];
// Restore dataset
rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"];
}
tcRaDetails.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value);
// Store dataset
Session["rehabAssessmentTDS"] = rehabAssessmentTDS;
}
// ... ra_delete.aspx or ra_edit.aspx
if ((Request.QueryString["source_page"] == "ra_delete.aspx") || (Request.QueryString["source_page"] == "ra_edit.aspx"))
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// Restore dataset
rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"];
// ... Set initial tab
if ((string)Session["dialogOpenedRa"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
}
else
{
hdfActiveTab.Value = (string)Session["activeTabRa"];
}
tcRaDetails.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value);
}
// Prepare initial data
// ... 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();
}
else
{
// Restore datasets
rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"];
// Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcRaDetails.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_APP_VIEW"]))
{
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"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in jliner_navigator2.aspx");
}
// Tag page
hdfCurrentClient.Value = (string)Request.QueryString["client"];
// ... for the ddl Sub areas
SectionSubArea sectionSubArea = new SectionSubArea();
sectionSubArea.LoadAndAddItem(int.Parse(hdfCurrentClient.Value), "(All)");
ddlSubArea.DataSource = sectionSubArea.Table;
ddlSubArea.DataValueField = "SubArea";
ddlSubArea.DataTextField = "SubArea";
ddlSubArea.DataBind();
// If coming from
// ... jliner_navigator.aspx or jliner_navigator2.aspx
if ((Request.QueryString["source_page"] == "jliner_navigator.aspx") || (Request.QueryString["source_page"] == "jliner_navigator2.aspx"))
{
RestoreNavigatorState();
jlinerNavigatorTDS = (JlinerNavigatorTDS)Session["jlinerNavigatorTDS"];
}
// ... flat_section_jliner_edit.aspx or flat_section_jliner_summary.aspx or jliner_delete.aspx
if ((Request.QueryString["source_page"] == "flat_section_jliner_edit.aspx") || (Request.QueryString["source_page"] == "flat_section_jliner_summary.aspx") || (Request.QueryString["source_page"] == "jliner_delete.aspx"))
{
RestoreNavigatorState();
if (Request.QueryString["update"] == "no")
{
jlinerNavigatorTDS = (JlinerNavigatorTDS)Session["jlinerNavigatorTDS"];
}
else
{
// ... Delete store data
Session.Contents.Remove("jlinerNavigatorTDS");
// ... Search data with updates
jlinerNavigatorTDS = SubmitSearch();
// ... store datasets
Session["jlinerNavigatorTDS"] = jlinerNavigatorTDS;
}
}
// ... jliner_delete.aspx
if (Request.QueryString["source_page"] == "jliner_delete.aspx")
{
if (jlinerNavigatorTDS.JlinerNavigator.Rows.Count == 0)
{
string url = "./jliner_navigator.aspx?source_page=jliner_navigator2.aspx&client=" + hdfCurrentClient.Value + GetNavigatorState() + "&no_results=no";
Response.Redirect(url);
}
}
// Prepare initial data
// ... for the client
int companyId = Int32.Parse(Session["companyID"].ToString());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(int.Parse(hdfCurrentClient.Value), companyId);
TextBox tbxCurrentClient = (TextBox)tkrpbLeftMenuCurrentClient.FindItemByValue("mCurrentClient").FindControl("tbxCurrentClient");
tbxCurrentClient.Text = companiesGateway.GetName(int.Parse(hdfCurrentClient.Value));
hdfClientName.Value = tbxCurrentClient.Text;
// ... for the grid
grdJlinerNavigator.DataSource = jlinerNavigatorTDS.JlinerNavigator;
grdJlinerNavigator.DataBind();
// ... for the total rows
if (jlinerNavigatorTDS.JlinerNavigator.Rows.Count > 0)
{
grdJlinerNavigator.Caption = String.Format("<table border='0' width='100%' cellpadding='0' cellspacing='0' style='font-weight: bold; font-size: 11px; color: #2F82C7; font-family: 'Microsoft Sans Serif';'><tr><td>Total Rows: {0}</td></tr></table>", jlinerNavigatorTDS.JlinerNavigator.Rows.Count);
grdJlinerNavigator.ShowHeader = true;
}
else
{
grdJlinerNavigator.ShowHeader = false;
}
}
else
{
// Restore TDS
jlinerNavigatorTDS = (JlinerNavigatorTDS)Session["jlinerNavigatorTDS"];
// ... for the total rows
if (jlinerNavigatorTDS.JlinerNavigator.Rows.Count > 0)
{
grdJlinerNavigator.Caption = String.Format("<table border='0' width='100%' cellpadding='0' cellspacing='0' style='font-weight: bold; font-size: 11px; color: #2F82C7; font-family: 'Microsoft Sans Serif';'><tr><td>Total Rows: {0}</td></tr></table>", jlinerNavigatorTDS.JlinerNavigator.Rows.Count);
grdJlinerNavigator.ShowHeader = true;
}
else
{
grdJlinerNavigator.ShowHeader = false;
}
}
}
protected void btnPrintLateralLocationSheet_Click(object sender, EventArgs e)
{
mForm7 master = (mForm7)this.Master;
ScriptManager scriptManager = (ScriptManager)master.FindControl("ScriptManagerMaster7");
if (!scriptManager.IsInAsyncPostBack)
{
string url = "";
string client = "";
string name = "";
string project = "";
string title = "Full Length Lining Search Results";
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
client += "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
project = projectGateway.GetName(currentProjectId);
name = client + " > Project: " + project + " (" + projectGateway.GetProjectNumber(currentProjectId) + ")";
// ... for title view
if (hdfBtnOrigin.Value == "Go")
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
// ... Load name view
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(viewId, companyId);
title = workViewGateway.GetName(viewId);
}
// Report call
Page.Validate();
if (Page.IsValid)
{
PostPageChanges();
int assetId = GetAssetId();
if (assetId > 0)
{
WorkGateway workGateway = new WorkGateway();
workGateway.LoadByProjectIdAssetIdWorkType(Int32.Parse(hdfCurrentProjectId.Value), assetId, "Full Length Lining", Int32.Parse(hdfCompanyId.Value));
int workId = workGateway.GetWorkId(assetId, "Full Length Lining", Int32.Parse(hdfCurrentProjectId.Value));
FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway();
fullLengthLiningWorkDetailsGateway.LoadByWorkIdAssetId(workId, assetId, Int32.Parse(hdfCompanyId.Value));
string measuredFrom = fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workId);
Response.Write("<script language='javascript'> {window.open('./../../CWP/Common/lateral_location_sheet_report.aspx?source_page=lm&project_id=" + hdfCurrentProjectId.Value + "&client_id=" + hdfCurrentClientId.Value + "&work_id=" + workId.ToString() + "&measured_from=" + measuredFrom + "&asset_id=" + assetId.ToString() + "', '_blank', 'toolbar=no, location=no, directories=no, status=yes, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=800, height=680');}</script>");
}
else
{
cvSelection.IsValid = false;
}
}
if (url != "") Response.Redirect(url);
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_DELETE"])))
{
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))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in jls_delete.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString();
hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString();
// Prepare initial data
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
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 Sections";
// If coming from
// ... jls_navigator2.aspx
if (Request.QueryString["source_page"] == "jls_navigator2.aspx")
{
StoreNavigatorState();
ViewState["update"] = "no";
}
// ... flat_section_jls_summary.aspx
if (Request.QueryString["source_page"] == "flat_section_jls_summary.aspx")
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
}
// Restore datasets
flatSectionJlsTDS = (FlatSectionJlsTDS)Session["flatSectionJlsTDS"];
}
else
{
// Restore datasets
flatSectionJlsTDS = (FlatSectionJlsTDS)Session["flatSectionJlsTDS"];
}
}
protected void btnExportList_Click(object sender, EventArgs e)
{
mForm7 master = (mForm7)this.Master;
ScriptManager scriptManager = (ScriptManager)master.FindControl("ScriptManagerMaster7");
if (!scriptManager.IsInAsyncPostBack)
{
string url = "";
string headerValues = "";
int totalColumnsExport = 85;
int totalColumnsPreview = 84;
string client = "";
string name = "";
string project = "";
string title = "Full Length Lining Search Results";
string columnsForReport = "";
int j;
// ... for client
int companyId = Int32.Parse(hdfCompanyId.Value);
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
client += "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
project = projectGateway.GetName(currentProjectId);
name = client + " > Project: " + project + " (" + projectGateway.GetProjectNumber(currentProjectId) + ")";
// ... for title view
if (hdfBtnOrigin.Value == "Go")
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
// ... Load name view
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(viewId, companyId);
title = workViewGateway.GetName(viewId);
}
// ... For comments option
string comments = "None";
headerValues = "";
columnsForReport = "";
// Establishing header values
if (grdFLNavigator.Columns[2].Visible) headerValues += "ID (Section)";
if (grdFLNavigator.Columns[3].Visible) headerValues += " * Old CWP ID";
if (grdFLNavigator.Columns[4].Visible) headerValues += " * Sub Area";
if (grdFLNavigator.Columns[5].Visible) headerValues += " * Street";
if (grdFLNavigator.Columns[6].Visible) headerValues += " * USMH";
if (grdFLNavigator.Columns[7].Visible) headerValues += " * DSMH";
if (grdFLNavigator.Columns[8].Visible) headerValues += " * Proposed Lining Date";
if (grdFLNavigator.Columns[9].Visible) headerValues += " * Deadline Lining Date";
if (grdFLNavigator.Columns[10].Visible) headerValues += " * P1 Date";
if (grdFLNavigator.Columns[11].Visible) headerValues += " * M1 Date";
if (grdFLNavigator.Columns[12].Visible) headerValues += " * M2 Date";
if (grdFLNavigator.Columns[13].Visible) headerValues += " * Install Date";
if (grdFLNavigator.Columns[14].Visible) headerValues += " * Final Video Date";
if (grdFLNavigator.Columns[15].Visible) headerValues += " * Confirmed Size";
if (grdFLNavigator.Columns[16].Visible) headerValues += " * Actual Length";
if (grdFLNavigator.Columns[17].Visible) headerValues += " * Thickness";
if (grdFLNavigator.Columns[18].Visible) headerValues += " * Comments";
if (grdFLNavigator.Columns[19].Visible) headerValues += " * Map Size";
if (grdFLNavigator.Columns[20].Visible) headerValues += " * Map Length";
if (grdFLNavigator.Columns[21].Visible) headerValues += " * Video Length";
if (grdFLNavigator.Columns[22].Visible) headerValues += " * Laterals";
if (grdFLNavigator.Columns[23].Visible) headerValues += " * Live Laterals";
if (grdFLNavigator.Columns[24].Visible) headerValues += " * Client ID";
if (grdFLNavigator.Columns[25].Visible) headerValues += " * Pre-Flush Date";
if (grdFLNavigator.Columns[26].Visible) headerValues += " * Pre-Video Date";
if (grdFLNavigator.Columns[27].Visible) headerValues += " * Issue Identified";
if (grdFLNavigator.Columns[28].Visible) headerValues += " * Issue LFS";
if (grdFLNavigator.Columns[29].Visible) headerValues += " * Issue Client";
if (grdFLNavigator.Columns[30].Visible) headerValues += " * Issue Sales";
if (grdFLNavigator.Columns[31].Visible) headerValues += " * Issue Given To Client";
if (grdFLNavigator.Columns[32].Visible) headerValues += " * Issue Investigation";
if (grdFLNavigator.Columns[33].Visible) headerValues += " * Issue Resolved";
if (grdFLNavigator.Columns[34].Visible) headerValues += " * CXIs Removed";
if (grdFLNavigator.Columns[35].Visible) headerValues += " * Material Type";
if (grdFLNavigator.Columns[36].Visible) headerValues += " * USMH Address";
if (grdFLNavigator.Columns[37].Visible) headerValues += " * USMH Depth";
if (grdFLNavigator.Columns[38].Visible) headerValues += " * USMH Mouth12";
if (grdFLNavigator.Columns[39].Visible) headerValues += " * USMH Mouth1";
if (grdFLNavigator.Columns[40].Visible) headerValues += " * USMH Mouth2";
if (grdFLNavigator.Columns[41].Visible) headerValues += " * USMH Mouth3";
if (grdFLNavigator.Columns[42].Visible) headerValues += " * USMH Mouth4";
if (grdFLNavigator.Columns[43].Visible) headerValues += " * USMH Mouth5";
if (grdFLNavigator.Columns[44].Visible) headerValues += " * DSMH Address";
if (grdFLNavigator.Columns[45].Visible) headerValues += " * DSMH Depth";
if (grdFLNavigator.Columns[46].Visible) headerValues += " * DSMH Mouth12";
if (grdFLNavigator.Columns[47].Visible) headerValues += " * DSMH Mouth1";
if (grdFLNavigator.Columns[48].Visible) headerValues += " * DSMH Mouth2";
if (grdFLNavigator.Columns[49].Visible) headerValues += " * DSMH Mouth3";
if (grdFLNavigator.Columns[50].Visible) headerValues += " * DSMH Mouth4";
if (grdFLNavigator.Columns[51].Visible) headerValues += " * DSMH Mouth5";
if (grdFLNavigator.Columns[52].Visible) headerValues += " * Traffic Control";
if (grdFLNavigator.Columns[53].Visible) headerValues += " * Site Details";
if (grdFLNavigator.Columns[54].Visible) headerValues += " * Pipe Size Change";
if (grdFLNavigator.Columns[55].Visible) headerValues += " * Standard Bypass";
if (grdFLNavigator.Columns[56].Visible) headerValues += " * Standard Bypass Comments";
if (grdFLNavigator.Columns[57].Visible) headerValues += " * Traffic Control Details";
if (grdFLNavigator.Columns[58].Visible) headerValues += " * Measurement Type";
if (grdFLNavigator.Columns[59].Visible) headerValues += " * Measurement FromMH";
if (grdFLNavigator.Columns[60].Visible) headerValues += " * Video Done From MH";
if (grdFLNavigator.Columns[61].Visible) headerValues += " * Video Done To MH";
if (grdFLNavigator.Columns[62].Visible) headerValues += " * M1 Measurement Taken By";
if (grdFLNavigator.Columns[63].Visible) headerValues += " * M2 Measurement Taken By";
if (grdFLNavigator.Columns[64].Visible) headerValues += " * Drop Pipe";
if (grdFLNavigator.Columns[65].Visible) headerValues += " * Drop Pipe Invert Depth";
if (grdFLNavigator.Columns[66].Visible) headerValues += " * Capped Laterals";
if (grdFLNavigator.Columns[67].Visible) headerValues += " * Line With ID";
if (grdFLNavigator.Columns[68].Visible) headerValues += " * Hydran tAddress";
if (grdFLNavigator.Columns[69].Visible) headerValues += " * Distance To Inversion MH";
if (grdFLNavigator.Columns[70].Visible) headerValues += " * Hydro Wire Within 10Ft Of Inversion MH";
if (grdFLNavigator.Columns[71].Visible) headerValues += " * Surface Grade";
if (grdFLNavigator.Columns[72].Visible) headerValues += " * Hydro Pulley";
if (grdFLNavigator.Columns[73].Visible) headerValues += " * Fridge Cart";
if (grdFLNavigator.Columns[74].Visible) headerValues += " * Two Pump";
if (grdFLNavigator.Columns[75].Visible) headerValues += " * Six Bypass";
if (grdFLNavigator.Columns[76].Visible) headerValues += " * Scaffolding";
if (grdFLNavigator.Columns[77].Visible) headerValues += " * Winch Extention";
if (grdFLNavigator.Columns[78].Visible) headerValues += " * Extra Generator";
if (grdFLNavigator.Columns[79].Visible) headerValues += " * Grey Cable Extension";
if (grdFLNavigator.Columns[80].Visible) headerValues += " * Easement Mats";
if (grdFLNavigator.Columns[81].Visible) headerValues += " * Ramp Required";
if (grdFLNavigator.Columns[82].Visible) headerValues += " * Camera Skid";
if (grdFLNavigator.Columns[83].Visible) headerValues += " * RoboticPrepCompleted";
if (grdFLNavigator.Columns[84].Visible) headerValues += " * RoboticPrepCompleted Date";
// Establishing columns to display
string[] columnsExcel = headerValues.Split('*');
// ... for visible columns
for (int i = 0; i < columnsExcel.Length; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=" + columnsExcel[i].Trim();
}
// ... For not visible columns
for (int i = columnsExcel.Length; i < totalColumnsExport; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=None";
}
// Report call
Page.Validate();
if (Page.IsValid)
{
PostPageChanges();
title = title.Replace("'", "%27");
Response.Write("<script language='javascript'> {window.open('./fl_print_search_results_report.aspx?" + columnsForReport + "&comments=" + comments + "&totalColumnsPreview=" + totalColumnsPreview + "&totalColumnsExport=" + totalColumnsExport + "&totalSelectedColumns=" + columnsExcel.Length + "&name=" + Server.UrlEncode(name) + "&title=" + Server.UrlEncode(title) + "&format=excel', '_blank', 'toolbar=no, location=no, directories=no, status=yes, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=800, height=680');}</script>");
}
if (url != "") Response.Redirect(url);
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_VIEW"])))
{
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["work_type"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in jl_navigator.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString();
hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString();
hdfWorkType.Value = Request.QueryString["work_type"].ToString();
// Prepare initial data
// ... For sortByList
odsSortByList.DataBind();
ddlSortBy.DataSourceID = "odsSortByList";
ddlSortBy.DataValueField = "SortID";
ddlSortBy.DataTextField = "Name";
ddlSortBy.DataBind();
// ... For
odsViewForDisplayList.DataBind();
odsViewForDisplayList2.DataBind();
// ... For view ddl
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
string workType = hdfWorkType.Value;
int loginId = Convert.ToInt32(Session["loginID"]);
string viewTypeGlobal = "";
string viewTypePersonal = "Personal";
// Global Views check
if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"]))
{
viewTypeGlobal = "Global";
}
WorkViewList workViewList = new WorkViewList();
workViewList.LoadAndAddItem(workType, viewTypeGlobal, viewTypePersonal, loginId, companyId);
ddlView.DataSource = workViewList.Table;
ddlView.DataValueField = "ViewID";
ddlView.DataTextField = "Name";
ddlView.DataBind();
ddlView.SelectedIndex = 1;
WorkTypeViewSubAreaList workTypeViewSubAreaList = new WorkTypeViewSubAreaList();
workTypeViewSubAreaList.LoadAndAddItem("Junction Lining", Int32.Parse(hdfCompanyId.Value), int.Parse(hdfCurrentProjectId.Value), "(All)");
ddlSubArea.DataSource = workTypeViewSubAreaList.Table;
ddlSubArea.DataValueField = "SubArea";
ddlSubArea.DataTextField = "SubArea";
ddlSubArea.DataBind();
// ... 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
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
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) + ")";
// If coming from
// ... Left Menu, select_project.aspx or Projects2.aspx
if ((Request.QueryString["source_page"] == "lm") || (Request.QueryString["source_page"] == "select_project.aspx") || (Request.QueryString["source_page"] == "Projects2.aspx"))
{
tdNoResults.Visible = false;
}
// ... jl_navigator2.aspx
if (Request.QueryString["source_page"] == "jl_navigator2.aspx")
{
RestoreNavigatorState();
if ((string)Request.QueryString["no_results"] == "yes")
{
tdNoResults.Visible = true;
}
else
{
tdNoResults.Visible = true;
}
}
}
}
protected void btnExportList_Click(object sender, EventArgs e)
{
string url = "";
string headerValues = "";
int totalColumnsExport = 53;
int totalColumnsPreview = 52;
string client = "";
string name = "";
string project = "";
string title = "Rehab Assessment Search Results";
string columnsForReport = "";
int j;
// ... for client
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
client += "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
project = projectGateway.GetName(currentProjectId);
name = client + " > Project: " + project + " (" + projectGateway.GetProjectNumber(currentProjectId) + ")";
// ... for title view
if (hdfBtnOrigin.Value == "Go")
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
// ... Load name view
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(viewId, companyId);
title = workViewGateway.GetName(viewId);
}
// ... For comments option
string comments = "None";
headerValues = "";
columnsForReport = "";
// Establishing header values
if (grdRANavigator.Columns[2].Visible) headerValues += "ID (Section)";
if (grdRANavigator.Columns[3].Visible) headerValues += " * Old CWP ID";
if (grdRANavigator.Columns[4].Visible) headerValues += " * Sub Area";
if (grdRANavigator.Columns[5].Visible) headerValues += " * Street";
if (grdRANavigator.Columns[6].Visible) headerValues += " * USMH";
if (grdRANavigator.Columns[7].Visible) headerValues += " * DSMH";
if (grdRANavigator.Columns[8].Visible) headerValues += " * Pre-Flush Date";
if (grdRANavigator.Columns[9].Visible) headerValues += " * Pre-Video Date";
if (grdRANavigator.Columns[10].Visible) headerValues += " * Map Size";
if (grdRANavigator.Columns[11].Visible) headerValues += " * Map Length";
if (grdRANavigator.Columns[12].Visible) headerValues += " * Thickness";
if (grdRANavigator.Columns[13].Visible) headerValues += " * Size_";
if (grdRANavigator.Columns[14].Visible) headerValues += " * Length";
if (grdRANavigator.Columns[15].Visible) headerValues += " * Comments";
if (grdRANavigator.Columns[16].Visible) headerValues += " * VideoLength";
if (grdRANavigator.Columns[17].Visible) headerValues += " * Laterals";
if (grdRANavigator.Columns[18].Visible) headerValues += " * LiveLaterals";
if (grdRANavigator.Columns[19].Visible) headerValues += " * ClientID";
if (grdRANavigator.Columns[20].Visible) headerValues += " * P1Date";
if (grdRANavigator.Columns[21].Visible) headerValues += " * CXIsRemoved";
if (grdRANavigator.Columns[22].Visible) headerValues += " * M1Date";
if (grdRANavigator.Columns[23].Visible) headerValues += " * MeasurementTakenBy";
if (grdRANavigator.Columns[24].Visible) headerValues += " * MaterialType";
if (grdRANavigator.Columns[25].Visible) headerValues += " * USMHAddress";
if (grdRANavigator.Columns[26].Visible) headerValues += " * USMHDepth";
if (grdRANavigator.Columns[27].Visible) headerValues += " * USMHMouth12";
if (grdRANavigator.Columns[28].Visible) headerValues += " * USMHMouth1";
if (grdRANavigator.Columns[29].Visible) headerValues += " * USMHMouth2";
if (grdRANavigator.Columns[30].Visible) headerValues += " * USMHMouth3";
if (grdRANavigator.Columns[31].Visible) headerValues += " * USMHMouth4";
if (grdRANavigator.Columns[32].Visible) headerValues += " * USMHMouth5";
if (grdRANavigator.Columns[33].Visible) headerValues += " * DSMHAddress";
if (grdRANavigator.Columns[34].Visible) headerValues += " * DSMHDepth";
if (grdRANavigator.Columns[35].Visible) headerValues += " * DSMHMouth12";
if (grdRANavigator.Columns[36].Visible) headerValues += " * DSMHMouth1";
if (grdRANavigator.Columns[37].Visible) headerValues += " * DSMHMouth2";
if (grdRANavigator.Columns[38].Visible) headerValues += " * DSMHMouth3";
if (grdRANavigator.Columns[39].Visible) headerValues += " * DSMHMouth4";
if (grdRANavigator.Columns[40].Visible) headerValues += " * DSMHMouth5";
if (grdRANavigator.Columns[41].Visible) headerValues += " * TrafficControl";
if (grdRANavigator.Columns[42].Visible) headerValues += " * SiteDetails";
if (grdRANavigator.Columns[43].Visible) headerValues += " * PipeSizeChange";
if (grdRANavigator.Columns[44].Visible) headerValues += " * StandardBypass";
if (grdRANavigator.Columns[45].Visible) headerValues += " * StandardBypassComments";
if (grdRANavigator.Columns[46].Visible) headerValues += " * TrafficControlDetails";
if (grdRANavigator.Columns[47].Visible) headerValues += " * MeasurementType";
if (grdRANavigator.Columns[48].Visible) headerValues += " * MeasurementFromMH";
if (grdRANavigator.Columns[49].Visible) headerValues += " * VideoDoneFromMH";
if (grdRANavigator.Columns[50].Visible) headerValues += " * VideoDoneToMH";
if (grdRANavigator.Columns[51].Visible) headerValues += " * RoboticPrepCompleted";
if (grdRANavigator.Columns[52].Visible) headerValues += " * RoboticPrepCompleted Date";
// Establishing columns to display
string[] columnsExcel = headerValues.Split('*');
// ... for visible columns
for (int i = 0; i < columnsExcel.Length; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=" + columnsExcel[i].Trim();
}
// ... For not visible columns
for (int i = columnsExcel.Length; i < totalColumnsExport; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=None";
}
// Report call
Page.Validate();
if (Page.IsValid)
{
PostPageChanges();
title = title.Replace("'", "%27");
Response.Write("<script language='javascript'> {window.open('./ra_print_search_results_report.aspx?" + columnsForReport + "&comments=" + comments + "&totalColumnsPreview=" + totalColumnsPreview + "&totalColumnsExport=" + totalColumnsExport + "&totalSelectedColumns=" + columnsExcel.Length + "&name=" + Server.UrlEncode(name) + "&title=" + Server.UrlEncode(title) + "&format=excel', '_blank', 'toolbar=no, location=no, directories=no, status=yes, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=800, height=680');}</script>");
}
if (url != "") Response.Redirect(url);
}
// ////////////////////////////////////////////////////////////////////////
// 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"])))
{
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_summary.aspx");
}
// Tag Page
TagPage();
Session.Remove("flAddLateralsNewDummy");
Session.Remove("wetOutCatalystsDetailsDummy");
// If comming from
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
int assetId = Int32.Parse(hdfAssetId.Value.Trim());
string workType = hdfWorkType.Value;
int workId = Int32.Parse(hdfWorkId.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"];
}
tcFlDetails.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value);
// Store dataset
Session["fullLengthLiningTDS"] = fullLengthLiningTDS;
}
// ... fl_delete.aspx or fl_edit.aspx
if ((Request.QueryString["source_page"] == "fl_delete.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"];
}
tcFlDetails.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value);
}
// Prepare initial data
// ... 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";
// ... for wet out section list
AssetSewerSectionList assetSewerSectionList = new AssetSewerSectionList();
assetSewerSectionList.LoadAndAddItem(Int32.Parse(hdfCurrentProjectId.Value), hdfWorkType.Value, "-1", "(All)", Int32.Parse(hdfCompanyId.Value));
cbxlWetOutDataSectionId.DataSource = assetSewerSectionList.Table;
cbxlWetOutDataSectionId.DataValueField = "SectionID";
cbxlWetOutDataSectionId.DataTextField = "FlowOrderID";
cbxlWetOutDataSectionId.DataBind();
cbxlInversionDataSectionId.DataSource = assetSewerSectionList.Table;
cbxlInversionDataSectionId.DataValueField = "SectionID";
cbxlInversionDataSectionId.DataTextField = "FlowOrderID";
cbxlInversionDataSectionId.DataBind();
// ... 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++)
{
cbxlWetOutDataSectionId.Items.FindByValue(runDetailsList[i]).Selected = true;
cbxlInversionDataSectionId.Items.FindByValue(runDetailsList[i]).Selected = true;
}
}
else
{
if (cbxlWetOutDataSectionId.Items.Count > 1)
{
cbxlWetOutDataSectionId.Items.FindByValue(hdfSectionId.Value).Selected = true;
}
}
}
else
{
// Restore datasets
fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"];
// Set initial tab
int activeTab = Int32.Parse(hdfActiveTab.Value);
tcFlDetails.ActiveTabIndex = activeTab;
// Load summary for inversionfield cure record
int companyId =Int32.Parse(hdfCompanyId.Value);
int workId = Int32.Parse(hdfWorkId.Value);
FlInversionFieldCureRecord FlInversionFieldCureRecordForSummary = new FlInversionFieldCureRecord();
FlInversionFieldCureRecordForSummary.Load(workId, companyId);
if (FlInversionFieldCureRecordForSummary.Table.Rows.Count > 0)
{
lblInversionDataFieldCureRecordSummary.Text = FlInversionFieldCureRecordForSummary.GetSummary();
}
}
}
private bool ProcessBulkUpload(string fName, out string bulkUploadResultMessage)
{
bool bulkUploadProccessed = true;
bulkUploadResultMessage = "";
AssetSewerSectionGateway assetSewerSectionGateway = new AssetSewerSectionGateway();
AppSettingsReader appSettingReader = new AppSettingsReader();
string excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel 8.0;HDR=YES;IMEX=1';Data Source=" + fName + ";";
OleDbConnection connection = new OleDbConnection(excelConnectionString);
OleDbCommand command = null;
OleDbDataReader dataReader = null;
try
{
try
{
connection.Open();
command = new OleDbCommand("select * from [sections]", connection);
dataReader = command.ExecuteReader();
dataReader.Close();
connection.Close();
}
catch (Exception ex)
{
bulkUploadResultMessage = "You did not define the 'sections' data range. Bulk upload ABORTED. Original message: " + ex.Message;
bulkUploadProccessed = false;
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
//--- Process bulk upload
if (bulkUploadProccessed)
{
connection.Open();
command = new OleDbCommand("select * from [sections]", connection);
dataReader = command.ExecuteReader();
int id = 0;
while (dataReader.Read())
{
if (!IsEmptyRow(dataReader))
{
bool deleted = false;
int companiesId = 0;
string client = "";
string subArea = "";
string street = "";
string usmh = "";
string dsmh = "";
string mapSize = ""; //Size_
string mapLength = ""; //ScaledLength
string actualLength = ""; //
string confirmedSize = "";
bool jlWork = false; // JL work
string usmhMn = "";
string dsmhMn = "";
string usmhDepth = "";
string dsmhDepth = "";
string steelTapeThruPipe = "";
string usmhAtMouth1200 = "";
string usmhAtMouth100 = "";
string usmhAtMouth200 = "";
string usmhAtMouth300 = "";
string usmhAtMouth400 = "";
string usmhAtMouth500 = "";
string dsmhAtMouth1200 = "";
string dsmhAtMouth100 = "";
string dsmhAtMouth200 = "";
string dsmhAtMouth300 = "";
string dsmhAtMouth400 = "";
string dsmhAtMouth500 = "";
string dataCell = null;
string dataCellToUpper = null;
//--- ... fill section row
string originalSectionId = dataReader.GetValue(dataReader.GetOrdinal("ID")).ToString().Trim();
for (int i = 0; i < dataReader.FieldCount; i++)
{
dataCell = dataReader.GetValue(i).ToString().Trim();
dataCellToUpper = dataReader.GetValue(i).ToString().Trim().ToUpper();
switch (dataReader.GetName(i).Trim())
{
case "ID":
originalSectionId = dataCell;
break;
case "COMPANIES_ID":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
companiesId = int.Parse(dataCell);
}
else
{
bulkUploadResultMessage = "Invalid value in 'COMPANIES_ID' column (" + originalSectionId + "). Bulk upload ABORTED.";
}
break;
case "SubArea":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
subArea = dataCell;
}
break;
case "Street":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
street = dataCell;
}
break;
case "USMH":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
usmh = dataCell;
}
break;
case "DSMH":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
dsmh = dataCell;
}
break;
case "Size_":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
if (Distance.IsValidDistance(dataCell))
{
mapSize = dataCell;
}
else
{
bulkUploadResultMessage = "Invalid value in 'Size_' column (" + originalSectionId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
break;
case "ScaledLength":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
if (Distance.IsValidDistance(dataCell))
{
mapLength = dataCell;
}
else
{
bulkUploadResultMessage = "Invalid value in 'ScaledLength' column (" + originalSectionId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
break;
case "ActualLength":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
if (Distance.IsValidDistance(dataCell))
{
actualLength = dataCell;
}
else
{
bulkUploadResultMessage = "Invalid value in 'ActualLength' column (" + originalSectionId + " " + dataCell + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
break;
case "ConfirmedSize":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
if (Distance.IsValidDistance(dataCell))
{
confirmedSize = dataCell;
}
else
{
bulkUploadResultMessage = "Invalid value in 'ConfirmedSize' column (" + originalSectionId + "). Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
}
break;
case "JLiner":
if ((dataCellToUpper == "YES") || (dataCellToUpper == "NO"))
{
jlWork = (dataCellToUpper == "YES") ? true : false;
}
break;
case "USMHMN":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
usmhMn = dataCell;
}
break;
case "DSMHMN":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
dsmhMn = dataCell;
}
break;
case "USMHDepth":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
usmhDepth = dataCell;
}
break;
case "DSMHDepth":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
dsmhDepth = dataCell;
}
break;
case "SteelTapeThruPipe":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
steelTapeThruPipe = dataCell;
}
break;
case "USMHAtMouth1200":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
usmhAtMouth1200 = dataCell;
}
break;
case "USMHAtMouth100":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
usmhAtMouth100 = dataCell;
}
break;
case "USMHAtMouth200":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
usmhAtMouth200 = dataCell;
}
break;
case "USMHAtMouth300":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
usmhAtMouth300 = dataCell;
}
break;
case "USMHAtMouth400":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
usmhAtMouth400 = dataCell;
}
break;
case "USMHAtMouth500":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
usmhAtMouth500 = dataCell;
}
break;
case "DSMHAtMouth1200":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
dsmhAtMouth1200 = dataCell;
}
break;
case "DSMHAtMouth100":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
dsmhAtMouth100 = dataCell;
}
break;
case "DSMHAtMouth200":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
dsmhAtMouth200 = dataCell;
}
break;
case "DSMHAtMouth300":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
dsmhAtMouth300 = dataCell;
}
break;
case "DSMHAtMouth400":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
dsmhAtMouth400 = dataCell;
}
break;
case "DSMHAtMouth500":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
dsmhAtMouth500 = dataCell;
}
break;
case "Deleted":
if ((dataCellToUpper == "YES") || (dataCellToUpper == "NO"))
{
deleted = (dataCellToUpper == "YES") ? true : false;
}
break;
default:
bulkUploadResultMessage = "Invalid column name '" + dataReader.GetName(i) + "' in section data range.";
bulkUploadProccessed = false;
break;
}
if (!bulkUploadProccessed)
{
break;
}
}
if (bulkUploadProccessed && jlWork && !deleted)
{
DataMigrationGateway dataMigrationGateway = new DataMigrationGateway(null);
Guid originalId = dataMigrationGateway.GetOriginalIdByCompanyIdCompaniesIdRecordIdStreet(int.Parse(hdfCompanyId.Value), companiesId, originalSectionId, street);
id = id + 1;
if (!dataMigrationGateway.IsMigratedSection(originalId, originalSectionId))
{
//--- Initialize
int companyId = Int32.Parse(hdfCompanyId.Value);
DataMigrationTDS dataSet = new DataMigrationTDS();
dataSet.JlDataMigration.Merge(dataMigration, true);
JlDataMigration model = new JlDataMigration(dataSet);
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(companiesId, companyId);
client = companiesGateway.GetName(companiesId);
model.Insert(originalId, originalSectionId, companiesId, client, subArea, street, usmh, dsmh, mapSize, mapLength, actualLength, confirmedSize, jlWork, usmhMn, dsmhMn, usmhDepth, dsmhDepth, steelTapeThruPipe, usmhAtMouth1200, usmhAtMouth100, usmhAtMouth200, usmhAtMouth300, usmhAtMouth400, usmhAtMouth500, dsmhAtMouth1200, dsmhAtMouth100, dsmhAtMouth200, dsmhAtMouth300, dsmhAtMouth400, dsmhAtMouth500, 0, 0, false, "No", 0, 0);
dataMigration = dataSet.JlDataMigration;
Session["dataMigration"] = dataSet.JlDataMigration;
}
}
}
}
dataReader.Close();
connection.Close();
}
}
catch (Exception ex)
{
if (!dataReader.IsClosed)
{
dataReader.Close();
}
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
throw ex;
}
return (bulkUploadProccessed) ? true : false;
}
private void GrdProjectAdd()
{
if (Page.IsValid)
{
int projectId = Int32.Parse(ddlProject.SelectedValue);
int clientId = Int32.Parse(ddlClient.SelectedValue);
int companyId = Int32.Parse(hdfCompanyId.Value);
int loginId = Convert.ToInt32(Session["loginID"]);
DateTime lastLoggedInDate = DateTime.Now;
bool deleted = false;
string workType = hdfWorkType.Value;
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
string projectName = projectGateway.GetName(projectId) + " (" + projectGateway.GetProjectNumber(projectId) + ")";
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(clientId, companyId);
string clientName = companiesGateway.GetName(clientId);
SelectProjectLastUsedProjects model = new SelectProjectLastUsedProjects(selectProjectTDS);
model.Insert(clientId, projectId, loginId, lastLoggedInDate, companyId, deleted, workType, projectName, clientName, false);
Session.Remove("lastUsedProjectsDummy");
Session["selectProjectTDS"] = selectProjectTDS;
Session["lastUsedProjects"] = selectProjectTDS.LastUsedProjects;
grdProjects.DataBind();
grdProjects.PageIndex = grdProjects.PageCount - 1;
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_APP_VIEW"]) && Convert.ToBoolean(Session["sgLFS_APP_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"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in flat_section_jliner_summary.aspx");
}
// Tag page
hdfCurrentClient.Value = (string)Request.QueryString["client"];
// Restore datasets
flatSectionJlinerTDS = (FlatSectionJlinerTDS)Session["flatSectionJlinerTDS"];
// Prepare initial data
// ... for the client
int companyId = Int32.Parse(Session["companyID"].ToString());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(int.Parse(hdfCurrentClient.Value), companyId);
TextBox tbxCurrentClient = (TextBox)tkrpbLeftMenuCurrentClient.FindItemByValue("mCurrentClient").FindControl("tbxCurrentClient");
tbxCurrentClient.Text = companiesGateway.GetName(int.Parse(hdfCurrentClient.Value));
// If coming from
// ... jliner_navigator2.aspx
if (Request.QueryString["source_page"] == "jliner_navigator2.aspx")
{
StoreNavigatorState();
}
// ... jliner_delete.aspx or flat_section_jliner_edit.aspx
if ((Request.QueryString["source_page"] == "jliner_delete.aspx") || (Request.QueryString["source_page"] == "flat_section_jliner_edit.aspx"))
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
}
// Grid filter
odsFlatSectionJliner.FilterExpression = "(Deleted = 0)";
if (grdvJliner.Rows.Count == 0)
{
Response.Redirect("./jliner_navigator2.aspx?source_page=flat_section_jliner_summary.aspx&client=" + hdfCurrentClient.Value + GetNavigatorState() + "&update=" + (string)ViewState["update"]);
}
if (Session["rowFocus"] != null)
{
this.SetFocusGridView();
}
}
else
{
// Restore datasets
flatSectionJlinerTDS = (FlatSectionJlinerTDS)Session["flatSectionJlinerTDS"];
// Grid filter
odsFlatSectionJliner.FilterExpression = "(Deleted = 0)";
if (grdvJliner.Rows.Count == 0)
{
Response.Redirect("./jliner_navigator2.aspx?source_page=flat_section_jliner_summary.aspx&client=" + hdfCurrentClient.Value + GetNavigatorState() + "&update=" + (string)ViewState["update"]);
}
}
}
// ////////////////////////////////////////////////////////////////////////
// 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_APP_VIEW"]))
{
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"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in jliner_navigator.aspx");
}
// Tag page
hdfCurrentClient.Value = (string)Request.QueryString["client"];
// Prepare initial data
// ... for the client
int companyId = Int32.Parse(Session["companyID"].ToString());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(int.Parse(hdfCurrentClient.Value), companyId);
TextBox tbxCurrentClient = (TextBox)tkrpbLeftMenuCurrentClient.FindItemByValue("mCurrentClient").FindControl("tbxCurrentClient");
tbxCurrentClient.Text = companiesGateway.GetName(int.Parse(hdfCurrentClient.Value));
// ... for the ddl Sub areas
SectionSubArea sectionSubArea = new SectionSubArea();
sectionSubArea.LoadAndAddItem(int.Parse(hdfCurrentClient.Value), "(All)");
ddlSubArea.DataSource = sectionSubArea.Table;
ddlSubArea.DataValueField = "SubArea";
ddlSubArea.DataTextField = "SubArea";
ddlSubArea.DataBind();
// If coming from
// ... Left Menu or jliner_main
if ((Request.QueryString["source_page"] == "lm") || (Request.QueryString["source_page"] == "jliner_main.aspx"))
{
pNoResults.Visible = false;
}
// ... jliner_navigator2.aspx
if (Request.QueryString["source_page"] == "jliner_navigator2.aspx")
{
RestoreNavigatorState();
if ((string)Request.QueryString["no_results"] == "yes")
{
pNoResults.Visible = true;
}
else
{
pNoResults.Visible = false;
}
}
}
}
protected void tkrmTop_ItemClick(object sender, RadMenuEventArgs e)
{
if (e.Item.Value == "mPreview")
{
if (prLiningPlanTDS.PlLiningPlan.Rows.Count > 0)
{
Page.Validate();
if (Page.IsValid)
{
PostPageChanges();
string name = "";
string client = "";
string project = "";
// ... for client
int companyId = Int32.Parse(hdfCompanyId.Value);
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
client += "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
project = projectGateway.GetName(currentProjectId);
name = client + " > Project: " + project + " (" + projectGateway.GetProjectNumber(currentProjectId) + ")";
Response.Write("<script language='javascript'> {window.open('./pr_lining_plan_report.aspx?name=" + name + "', '_blank', 'toolbar=no, location=no, directories=no, status=yes, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=800, height=680');}</script>");
}
}
}
}
// ////////////////////////////////////////////////////////////////////////
// STEP1 - GENERAL INFORMATION - METHODS
//
private void StepGeneralInformationIn()
{
// Set instruction
Label instruction = (Label)this.Master.FindControl("lblInstruction");
instruction.Text = "Please provide general information";
if (rbtnBeginTemplate.Checked)
{
int costingSheetTemplateId = Int32.Parse(hdfSelectedIdTemplate.Value);
if (costingSheetTemplateId != 0)
{
// Prepare initial data
// ... for template
foreach (ProjectCostingSheetAddTDS.TemplateInformationRow row in (ProjectCostingSheetAddTDS.TemplateInformationDataTable)Session["templateInformation"])
{
if (row.CostingSheetTemplateID == costingSheetTemplateId)
{
tbxName.Text = row.Name;
cbxRehabAssessmentData.Checked = row.RAData;
cbxFullLengthLiningData.Checked = row.FLLData;
cbxPointRepairData.Checked = row.PRData; ;
cbxJunctionLiningData.Checked = row.JLData;
cbxManholeRehabData.Checked = row.MRData;
cbxMobilizationData.Checked = row.MOBData;
cbxOtherData.Checked = row.OtherData;
cbxLabourHour.Checked = row.LabourHourData;
cbxTrucksEquipment.Checked = row.UnitData;
cbxMaterial.Checked = row.MaterialData;
cbxSubcontractor.Checked = row.SubcontractorData;
cbxOtherCost.Checked = row.MiscData;
cbxRevenueInformation.Checked = row.RevenueIncluded;
luEndSaveTemplate.SelectedValue = row.CostingSheetTemplateID.ToString();
try
{
DateTime startDate = new DateTime(row.Year, row.Month, row.Day);
tkrdpFrom.SelectedDate = startDate;
}
catch { }
try
{
DateTime endDate = new DateTime(row.Year2, row.Month2, row.Day2);
tkrdpTo.SelectedDate = endDate;
}
catch { }
}
}
}
//foreach (ProjectTDS.LFS_PROJECTRow row in (ProjectTDS.LFS_PROJECTDataTable)project.Table)
//{
// // step 1
// thisId = Convert.ToInt32(row[0].ToString());
// // step 2
// thisName = Convert.ToString(row[8].ToString());
// // step 3
// TreeNode newNode = new TreeNode(thisName, thisId.ToString());
// newNode.ShowCheckBox = true;
// newNode.SelectAction = TreeNodeSelectAction.None;
// // step 4
// nodes.Add(newNode);
// newNode.ToggleExpandState();
//}
}
Int32 thisId;
String thisName;
TreeNodeCollection nodes;
CompaniesGateway companies = new CompaniesGateway();
companies.LoadByCompaniesId(int.Parse(hdfClientId.Value), int.Parse(hdfCompanyId.Value));
string nameCompany = companies.GetName(int.Parse(hdfClientId.Value));
ProjectGateway project = new ProjectGateway();
project.LoadByClientId(int.Parse(hdfClientId.Value));
TreeNode tnParent = new TreeNode();
tnParent.Text = nameCompany;
tnParent.Value = "0";
tnParent.ShowCheckBox = true;
tnParent.SelectAction = TreeNodeSelectAction.None;
tvProjectsRoot.Nodes.Add(tnParent);
tnParent.ToggleExpandState();
PopulateNodes(project.Table, tnParent.ChildNodes);
}
protected void btnExportList_Click(object sender, EventArgs e)
{
mForm7 master = (mForm7)this.Master;
ScriptManager scriptManager = (ScriptManager)master.FindControl("ScriptManagerMaster7");
if (!scriptManager.IsInAsyncPostBack)
{
string url = "";
string headerValues = "";
int totalColumnsExport = 11;
int totalColumnsPreview = 11;
string client = "";
string name = "";
string project = "";
string title = "Manhole Rehabilitation Search Results";
string columnsForReport = "";
int j;
// ... for client
int companyId = Int32.Parse(hdfCompanyId.Value);
int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString());
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
client += "Client: " + companiesGateway.GetName(currentClientId);
// ... for project
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString());
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(currentProjectId);
project = projectGateway.GetName(currentProjectId);
name = client + " > Project: " + project + " (" + projectGateway.GetProjectNumber(currentProjectId) + ")";
// ... for title view
if (hdfBtnOrigin.Value == "Go")
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
// ... Load name view
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(viewId, companyId);
title = workViewGateway.GetName(viewId);
}
// ... For comments option
string comments = "None";
headerValues = "";
columnsForReport = "";
// Establishing header values
if (grdMRNavigator.Columns[1].Visible) headerValues += "Manhole No";
if (grdMRNavigator.Columns[2].Visible) headerValues += " * Street";
if (grdMRNavigator.Columns[3].Visible) headerValues += " * Latitude";
if (grdMRNavigator.Columns[4].Visible) headerValues += " * Longitude";
if (grdMRNavigator.Columns[5].Visible) headerValues += " * Shape";
if (grdMRNavigator.Columns[6].Visible) headerValues += " * Location";
if (grdMRNavigator.Columns[7].Visible) headerValues += " * Condition Rating";
if (grdMRNavigator.Columns[8].Visible) headerValues += " * Prepped Date";
if (grdMRNavigator.Columns[9].Visible) headerValues += " * Sprayed Date";
if (grdMRNavigator.Columns[10].Visible) headerValues += " * Batch Date";
if (grdMRNavigator.Columns[11].Visible) headerValues += " * Comments";
// Establishing columns to display
string[] columnsExcel = headerValues.Split('*');
// ... for visible columns
for (int i = 0; i < columnsExcel.Length; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=" + columnsExcel[i].Trim();
}
// ... For not visible columns
for (int i = columnsExcel.Length; i < totalColumnsExport; i++)
{
j = i + 1;
columnsForReport += "&header" + j + "=None";
}
// Report call
Page.Validate();
if (Page.IsValid)
{
PostPageChanges();
title = title.Replace("'", "%27");
Response.Write("<script language='javascript'> {window.open('./mr_print_search_results_report.aspx?" + columnsForReport + "&comments=" + comments + "&totalColumnsPreview=" + totalColumnsPreview + "&totalColumnsExport=" + totalColumnsExport + "&totalSelectedColumns=" + columnsExcel.Length + "&name=" + Server.UrlEncode(name) + "&title=" + Server.UrlEncode(title) + "&format=excel', '_blank', 'toolbar=no, location=no, directories=no, status=yes, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=800, height=680');}</script>");
}
if (url != "") Response.Redirect(url);
}
}
private void Generate()
{
mReport1 master = (mReport1)this.Master;
// Get Data
LiquiForce.LFSLive.BL.CWP.Jliner.JlinerToBuildReport jlinertoBuildReport = new LiquiForce.LFSLive.BL.CWP.Jliner.JlinerToBuildReport();
int companyId = Convert.ToInt32(Session["companyID"]);
if (ddlSelectAClient.SelectedValue == "-1")
{
jlinertoBuildReport.Load(companyId);
int count = jlinertoBuildReport.Table.Rows.Count;
}
else
{
jlinertoBuildReport.LoadByCompaniesID(companyId, int.Parse(ddlSelectAClient.SelectedValue));
}
// ... Autofill liner in Process
if (ckbxAutofillLinerInProcess.Checked)
{
try
{
jlinertoBuildReport.UpdateForReport(companyId);
}
catch
{
string url = string.Format("./error_page.aspx?error={0}", "Autofill Liner In Process Failed. Please check your Database");
Response.Redirect(url);
}
}
// ... set properties to master page
master.Data = jlinertoBuildReport.Data;
master.Table = jlinertoBuildReport.TableName;
// Get report
if (jlinertoBuildReport.Table.Rows.Count > 0)
{
if (master.Format == "pdf")
{
master.Report = new rJlinerToBuildReport();
}
else
{
master.Report = new rJlinerToBuildReportExport();
}
// ... set parameters to report
if (master.Format == "pdf")
{
if (ddlSelectAClient.SelectedValue != "-1")
{
// ... for client
int currentClientId = Int32.Parse(ddlSelectAClient.SelectedValue);
LiquiForce.LFSLive.DA.Resources.Companies.CompaniesGateway companiesGateway = new LiquiForce.LFSLive.DA.Resources.Companies.CompaniesGateway();
companiesGateway.LoadByCompaniesId(currentClientId, companyId);
master.SetParameter("Client", companiesGateway.GetName(currentClientId));
}
else
{
master.SetParameter("Client", "All");
}
LiquiForce.LFSLive.DA.RAF.LoginGateway loginGateway = new LiquiForce.LFSLive.DA.RAF.LoginGateway();
loginGateway.LoadByLoginId(Convert.ToInt32(Session["loginID"]), companyId);
string user = loginGateway.GetLastName(Convert.ToInt32(Session["loginID"]), companyId) + " " + loginGateway.GetFirstName(Convert.ToInt32(Session["loginID"]), companyId);
master.SetParameter("User", user.Trim());
// Report format
master.Report.PrintOptions.PaperOrientation = PaperOrientation.Portrait;
master.Report.PrintOptions.PaperSize = PaperSize.PaperLetter;
}
}
}
