private JlNavigatorTDS SubmitSearch()
{
// Retrieve clauses
string whereClause = GetWhereClause();
string orderByClause = GetOrderByClause();
string conditionValue = "";
string conditionValue2 = "";
string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
// ... Load data for condition 1
WorkTypeViewConditionGateway workTypeViewConditionGateway = new WorkTypeViewConditionGateway();
workTypeViewConditionGateway.LoadByWorkTypeConditionId(workType, int.Parse(ddlCondition1.SelectedValue), companyId);
conditionValue = workTypeViewConditionGateway.GetColumn_(workType, companyId, int.Parse(ddlCondition1.SelectedValue));
// ... If condition 2 exists
if (ddlCondition2.SelectedValue != "-1")
{
// ... Load data for condition 2
WorkTypeViewConditionGateway workTypeViewConditionGateway2 = new WorkTypeViewConditionGateway();
workTypeViewConditionGateway2.LoadByWorkTypeConditionId(workType, int.Parse(ddlCondition2.SelectedValue), companyId);
conditionValue2 = workTypeViewConditionGateway2.GetColumn_(workType, companyId, int.Parse(ddlCondition2.SelectedValue));
}
JlNavigator jlNavigator = new JlNavigator();
jlNavigator.Load(whereClause, orderByClause, conditionValue, tbxCondition1.Text.Trim(), conditionValue2, tbxCondition2.Text.Trim(), companyId, currentProjectId, workType);
return (JlNavigatorTDS)jlNavigator.Data;
}
private JlNavigatorTDS SubmitSearchForViews()
{
string sqlCommand = "";
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
JlNavigator jlNavigator = new JlNavigator();
string workType = "Junction Lining Lateral";
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
// ... Load SqlCommand
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(viewId, companyId);
sqlCommand = workViewGateway.GetSqlCommand(viewId);
// ... Load data
jlNavigator.LoadForViewsProjectIdCompanyIdWorkType(sqlCommand, currentProjectId, companyId, workType);
return (JlNavigatorTDS)jlNavigator.Data;
}
private void UpdateDatabase()
{
DB.Open();
DB.BeginTransaction();
try
{
int companyId = Int32.Parse(hdfCompanyId.Value);
// Update Comments and History
FlatSectionJlCommentDetails flatSectionJlCommentDetails = new FlatSectionJlCommentDetails(flatSectionJlTDS);
flatSectionJlCommentDetails.Save(companyId);
FlatSectionJlHistoryDetails flatSectionJlHistoryDetails = new FlatSectionJlHistoryDetails(flatSectionJlTDS);
flatSectionJlHistoryDetails.Save(companyId);
// Update FlatSectionJl for new Comments
int workId = Int32.Parse(hdfWorkId.Value.Trim());
string workType = "Junction Lining Lateral";
FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS);
flatSectionJl.UpdateCommentsHistoryForSummaryEdit(workId, workType, companyId);
JlNavigator jlNavigator = new JlNavigator(jlNavigatorTDS);
jlNavigator.UpdateComments(workId, workType, companyId);
Session["flatSectionJlTDS"] = flatSectionJlTDS;
Session["jlNavigatorTDS"] = jlNavigatorTDS;
DB.CommitTransaction();
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
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);
}
private void PostPageChanges()
{
JlNavigator jlNavigator = new JlNavigator(jlNavigatorTDS);
// Update jlNavigator rows
foreach (GridViewRow row in grdJLNavigator.Rows)
{
string assetIdLabel = ((Label)row.FindControl("lblAssetID")).Text.Trim();
int assetId = Int32.Parse(assetIdLabel.ToString().Trim());
bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;
jlNavigator.Update(assetId, selected);
}
jlNavigator.Data.AcceptChanges();
// Store datasets
Session["jlNavigatorTDS"] = jlNavigatorTDS;
}
// ////////////////////////////////////////////////////////////////////////
// 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_navigator2.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
// ... jl_navigator.aspx or jl_navigator2.aspx
if ((Request.QueryString["source_page"] == "jl_navigator.aspx") || (Request.QueryString["source_page"] == "jl_navigator2.aspx"))
{
// Restore data
RestoreNavigatorState();
jlNavigatorTDS = (JlNavigatorTDS)Session["jlNavigatorTDS"];
}
// ... flat_section_jl_edit.aspx, flat_section_jl_summary.aspx or jl_delete.aspx
if ((Request.QueryString["source_page"] == "flat_section_jl_edit.aspx") || (Request.QueryString["source_page"] == "flat_section_jl_summary.aspx") || (Request.QueryString["source_page"] == "jl_delete.aspx"))
{
RestoreNavigatorState();
if (Request.QueryString["update"] == "no")
{
jlNavigatorTDS = (JlNavigatorTDS)Session["jlNavigatorTDS"];
}
else
{
// ... Delete store data
Session.Contents.Remove("jlNavigatorTDS");
// ... Search data with updates
if (hdfBtnOrigin.Value == "Search")
{
jlNavigatorTDS = SubmitSearch();
}
else
{
if (hdfBtnOrigin.Value == "Go")
{
jlNavigatorTDS = SubmitSearchForViews();
}
}
// ... store datasets
Session["jlNavigatorTDS"] = jlNavigatorTDS;
}
}
// ... jl_delete.aspx, flat_section_jl_summary.aspx or flat_section_jl_edit.aspx
if ((Request.QueryString["source_page"] == "jl_delete.aspx") || (Request.QueryString["source_page"] == "flat_section_jl_summary.aspx") || (Request.QueryString["source_page"] == "flat_section_jl_edit.aspx"))
{
if (jlNavigatorTDS.JlNavigator.Rows.Count == 0)
{
string url = "./jl_navigator.aspx?source_page=jl_navigator2.aspx&client_id=" + hdfCurrentClientId.Value + "&project_id=" + hdfCurrentProjectId.Value + "&work_type=" + hdfWorkType.Value + GetNavigatorState() + "&no_results=yes";
Response.Redirect(url);
}
}
// Update for comments
JlNavigator jlNavigator = new JlNavigator(jlNavigatorTDS);
jlNavigator.UpdateEnterForComments();
// Store data
Session["jlNavigatorTDS"] = jlNavigatorTDS;
// For the grid
grdJLNavigator.DataSource = jlNavigatorTDS.JlNavigator;
grdJLNavigator.DataBind();
// ... for the total rows
if (jlNavigatorTDS.JlNavigator.Rows.Count > 0)
{
lblTotalRows.Text = "Total Rows: " + jlNavigatorTDS.JlNavigator.Rows.Count;
lblTotalRows.Visible = true;
}
else
{
lblTotalRows.Visible = false;
}
}
else
{
// Restore TDS
jlNavigatorTDS = (JlNavigatorTDS)Session["jlNavigatorTDS"];
// Update for comments
JlNavigator jlNavigator = new JlNavigator(jlNavigatorTDS);
jlNavigator.UpdateEnterForComments();
// ... for the total rows
if (jlNavigatorTDS.JlNavigator.Rows.Count > 0)
{
lblTotalRows.Text = "Total Rows: " + jlNavigatorTDS.JlNavigator.Rows.Count;
lblTotalRows.Visible = true;
}
else
{
lblTotalRows.Visible = false;
}
}
}