// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// DeleteDirect
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="companyId">companyId</param>
public void DeleteDirect(int viewId, int companyId)
{
WorkViewDisplay workViewDisplay = new WorkViewDisplay(null);
workViewDisplay.DeleteDirect(viewId, companyId);
WorkViewCondition workViewCondition = new WorkViewCondition(null);
workViewCondition.DeleteDirect(viewId, companyId);
WorkViewSort workViewSort = new WorkViewSort(null);
workViewSort.DeleteDirect(viewId, companyId);
WorkViewGateway workViewGateway = new WorkViewGateway(null);
workViewGateway.Delete(viewId, companyId);
}
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);
}
}
protected void btnViewDelete_Click(object sender, EventArgs e)
{
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
if (!Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_DELETE"]))
{
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(viewId, companyId);
string viewType = workViewGateway.GetType(viewId);
if (viewType == "Global")
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
UpdateDatabaseForViews();
// ... For view ddl
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;
}
private MrNavigatorTDS SubmitSearchForViews()
{
string sqlCommand = "";
int viewId = Int32.Parse(ddlView.SelectedValue.Trim());
MrNavigator mrNavigator = new MrNavigator();
string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
bool inProject = bool.Parse(hdfInProject.Value);
// ... Load SqlCommand
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(viewId, companyId);
sqlCommand = workViewGateway.GetSqlCommand(viewId);
// ... Load data
mrNavigator.LoadForViewsProjectIdCompanyIdWorkType(sqlCommand, currentProjectId, companyId, workType, inProject);
return (MrNavigatorTDS)mrNavigator.Data;
}
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);
}
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;
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Validate query string
if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["work_type"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in view_add.aspx");
}
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_VIEWS_ADD"])))
{
if ((string)Request.QueryString["work_type"] == "Rehab Assessment")
{
if (!(Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_VIEW"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
if ((string)Request.QueryString["work_type"] == "Full Length Lining")
{
if (!(Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_VIEW"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
if ((string)Request.QueryString["work_type"] == "Junction Lining")
{
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.");
}
}
if ((string)Request.QueryString["work_type"] == "Point Repairs")
{
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.");
}
}
if ((string)Request.QueryString["work_type"] == "Manhole Rehabilitation")
{
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.");
}
}
}
// Tag page
hdfWorkType.Value = (string)Request.QueryString["work_type"];
hdfProjectId.Value = (string)Request.QueryString["project_id"];
hdfCompanyId.Value = Session["companyID"].ToString();
hdfUpdate.Value = "no";
ViewState["columnsToDisplayPageIndex"] = 0;
ViewState["sortPageIndex"] = 0;
Session.Remove("workTypeViewDisplay");
Session.Remove("workTypeViewDisplayDummy");
Session.Remove("workTypeViewSort");
Session.Remove("workTypeViewSortDummy");
Session.Remove("workViewDisplayTemp");
Session.Remove("workViewSortTemp");
Session.Remove("workViewConditionNew");
Session.Remove("workViewConditionNewDummy");
WorkViewGateway workViewGateway = new WorkViewGateway();
hdfViewId.Value = (workViewGateway.GetLastViewId()+1).ToString().Trim();
// Prepare initial data
// ... For view type
WorkViewTypeList workViewTypeList = new WorkViewTypeList(new DataSet());
workViewTypeList.LoadAndAddItem("(Select a type)", Int32.Parse(hdfCompanyId.Value));
ddlType.DataSource = workViewTypeList.Table;
ddlType.DataValueField = "Type";
ddlType.DataTextField = "Type";
ddlType.DataBind();
ddlType.SelectedIndex = 0;
// ... Global Views check
if (!Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_ADD"]))
{
ddlType.Items.Remove("Global");
}
// If coming from
// ... ra_navigator.aspx, ra_navigator2.aspx, fl_navigator.aspx, fl_navigator2.aspx, jl_navigator.aspx, jl_navigator2.aspx, pr_navigator.aspx or pr_navigator2.aspx , mr_navigator.aspx, mr_navigator2.aspx
if ((Request.QueryString["source_page"] == "ra_navigator.aspx") || (Request.QueryString["source_page"] == "ra_navigator2.aspx") || (Request.QueryString["source_page"] == "fl_navigator.aspx") || (Request.QueryString["source_page"] == "fl_navigator2.aspx") || (Request.QueryString["source_page"] == "jl_navigator.aspx") || (Request.QueryString["source_page"] == "jl_navigator2.aspx") || (Request.QueryString["source_page"] == "pr_navigator.aspx") || (Request.QueryString["source_page"] == "pr_navigator2.aspx") || (Request.QueryString["source_page"] == "mr_navigator.aspx") || (Request.QueryString["source_page"] == "mr_navigator2.aspx"))
{
// ... For Grids
workViewTDS = new WorkViewTDS();
workTypeViewDisplay = new WorkViewTDS.LFS_WORK_TYPE_VIEW_DISPLAYDataTable();
workTypeViewSort = new WorkViewTDS.LFS_WORK_TYPE_VIEW_SORTDataTable();
workViewDisplayTemp = new WorkViewTDS.WorkViewDisplayTempDataTable();
workViewSortTemp = new WorkViewTDS.WorkViewSortTempDataTable();
workViewConditionNew = new WorkViewTDS.WorkViewConditionNewDataTable();
// ... Store datasets
Session["workViewTDS"] = workViewTDS;
Session["workTypeViewDisplay"] = workTypeViewDisplay;
Session["workTypeViewSort"] = workTypeViewSort;
Session["workViewDisplayTemp"] = workViewDisplayTemp;
Session["workViewSortTemp"] = workViewSortTemp;
Session["workViewConditionNew"] = workViewConditionNew;
}
// StepSection1In
wzViews.ActiveStepIndex = 0;
StepBeginIn();
}
else
{
// Restore datasets
workViewTDS = (WorkViewTDS)Session["workViewTDS"];
workTypeViewDisplay = (WorkViewTDS.LFS_WORK_TYPE_VIEW_DISPLAYDataTable)Session["workTypeViewDisplay"];
workTypeViewSort = (WorkViewTDS.LFS_WORK_TYPE_VIEW_SORTDataTable)Session["workTypeViewSort"];
workViewDisplayTemp = (WorkViewTDS.WorkViewDisplayTempDataTable)Session["workViewDisplayTemp"];
workViewSortTemp = (WorkViewTDS.WorkViewSortTempDataTable)Session["workViewSortTemp"];
workViewConditionNew = (WorkViewTDS.WorkViewConditionNewDataTable)Session["workViewConditionNew"];
}
// control for postback
hdfTag.Value = DateTime.Now.ToLongTimeString();
}
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);
}
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);
}
}
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);
}
}
/// <summary>
/// SaveForEdit
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="loginId">loginId</param>
/// <param name="name">name</param>
/// <param name="type">type</param>
/// <param name="logic">logic</param>
/// <param name="sqlCommand">sqlCommand</param>
/// <param name="workType">workType</param>
/// <param name="companyId">companyId</param>
public void SaveForEdit(int viewId, int loginId, string name, string type, string logic, string sqlCommand, string workType, int companyId, string newName, string newType)
{
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(viewId, companyId);
int originalViewId = viewId;
int originalLoginId = workViewGateway.GetLoginId(viewId);
string originalName = workViewGateway.GetName(viewId);
string originalType = workViewGateway.GetType(viewId);
string originalLogic = workViewGateway.GetLogic(viewId);
string originalSqlCommand = workViewGateway.GetSqlCommand(viewId);
string originalWorkType = workViewGateway.GetWorkType(viewId);
bool originalDeleted = workViewGateway.GetDeleted(viewId);
int originalCompanyId = workViewGateway.GetCompanyId(viewId);
UpdateDirect(originalViewId, originalLoginId, originalName, originalType, originalLogic, originalSqlCommand, originalWorkType, originalDeleted, originalCompanyId, viewId, loginId, newName, newType, logic, sqlCommand, workType, false, companyId);
}
/// <summary>
/// InsertDirect
/// </summary>
/// <param name="viewId">viewId</param>
/// <param name="loginId">loginId</param>
/// <param name="name">name</param>
/// <param name="type">type</param>
/// <param name="logic">logic</param>
/// <param name="sqlCommand">sqlCommand</param>
/// <param name="workType">workType</param>
/// <param name="deleted">deleted</param>
/// <param name="companyId">companyId</param>
public void InsertDirect(int viewId, int loginId, string name, string type, string logic, string sqlCommand, string workType, bool deleted, int companyId)
{
WorkViewGateway workViewGateway = new WorkViewGateway(null);
workViewGateway.Insert(viewId, loginId, name, type, logic, sqlCommand, workType, deleted, companyId);
}
/// <summary>
/// UpdateDirect
/// </summary>
/// <param name="originalViewId">originalViewId</param>
/// <param name="originalLoginId">originalLoginId</param>
/// <param name="originalName">originalName</param>
/// <param name="originalType">originalType</param>
/// <param name="origianlLogic">origianlLogic</param>
/// <param name="originalSqlCommand">originalSqlCommand</param>
/// <param name="originalWorkType">originalWorkType</param>
/// <param name="originalDeleted">originalDeleted</param>
/// <param name="originalCompanyId">originalCompanyId</param>
/// <param name="newViewID">newViewID</param>
/// <param name="newLoginId">newLoginId</param>
/// <param name="newName">newName</param>
/// <param name="newType">newType</param>
/// <param name="newLogic">newLogic</param>
/// <param name="newSqlCommand">newSqlCommand</param>
/// <param name="newWorkType">newWorkType</param>
/// <param name="newDeleted">newDeleted</param>
/// <param name="newCompanyId">newCompanyId</param>
public void UpdateDirect(int originalViewId, int originalLoginId, string originalName, string originalType, string origianlLogic, string originalSqlCommand, string originalWorkType, bool originalDeleted, int originalCompanyId, int newViewID, int newLoginId, string newName, string newType, string newLogic, string newSqlCommand, string newWorkType, bool newDeleted, int newCompanyId)
{
WorkViewGateway workViewGateway = new WorkViewGateway(null);
workViewGateway.Update(originalViewId, originalLoginId, originalName, originalType, origianlLogic, originalSqlCommand, originalWorkType, originalDeleted, originalCompanyId, newViewID, newLoginId, newName, newType, newLogic, newSqlCommand, newWorkType, newDeleted, newCompanyId);
}
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 bool StepConditionsNext()
{
// Validate data
bool validData = true;
// Edit if there is data to save
Page.Validate("ConditionsUpdate");
if (!Page.IsValid) validData = false;
if (validData)
{
// Conditions Gridview, if the gridview is edition mode
if (grdConditions.EditIndex >= 0)
{
grdConditions.UpdateRow(grdConditions.EditIndex, true);
grdConditions.DataBind();
}
}
Page.Validate("ConditionsNext");
if (!Page.IsValid) validData = false;
if (validData)
{
// Add conditions if exists at footer
if (ValidateFooterNext())
{
GrdConditionsAdd();
}
WorkViewGateway workViewGateway = new WorkViewGateway();
workViewGateway.LoadByViewId(int.Parse(hdfViewId.Value), int.Parse(hdfCompanyId.Value));
workViewConditionTemp.Rows.Clear();
// create dataset
WorkViewTDS dataSet = new WorkViewTDS();
dataSet.WorkViewConditionNew.Merge(workViewConditionNew, true);
dataSet.WorkViewConditionTemp.Merge(workViewConditionTemp, true);
// process conditions
WorkViewConditionTemp model = new WorkViewConditionTemp(dataSet);
WorkViewConditionNew modelLogic = new WorkViewConditionNew(dataSet);
string originalLogic = workViewGateway.GetLogic(int.Parse(hdfViewId.Value));
string newLogic = modelLogic.GetConditionsByDefault();
ArrayList aConditions = new ArrayList();
aConditions = modelLogic.GetConditions();
bool isConditionsUpdate = false;
if (originalLogic.Trim() != newLogic.Trim())
{
foreach (string conditionNumber in aConditions)
{
if (!originalLogic.Contains(conditionNumber))
{
isConditionsUpdate = true;
}
}
if (!isConditionsUpdate)
{
if (Session["conditionsUpdate"] != null)
{
if (Session["conditionsUpdate"].ToString() == "true")
{
isConditionsUpdate = true;
}
}
}
}
else
{
tbxLogic.Text = originalLogic.Trim();
}
if (isConditionsUpdate)
{
tbxLogic.Text = newLogic.Trim();
}
else
{
tbxLogic.Text = originalLogic.Trim();
}
// get changes
workViewConditionNew.Rows.Clear();
workViewConditionNew.Merge(modelLogic.Table);
workViewConditionTemp.Rows.Clear();
workViewConditionTemp.Merge(model.Table);
//// store tables
Session.Remove("workViewConditionNewDummy");
Session.Remove("workViewConditionTempDummy");
Session["workViewConditionNew"] = workViewConditionNew;
Session["workViewConditionTemp"] = workViewConditionTemp;
Session["conditionsUpdate"] = null;
return true;
}
else
{
return false;
}
}
