/// <summary>
/// LoadByProjectIdJlNavigatorTDS
/// </summary>
/// <param name="projectId">projectId</param>
/// <param name="jlNavigatorTDS">jlNavigatorTDS</param>
/// <param name="companyId">companyId</param>
public void LoadByProjectIdJlNavigatorTDS(int projectId, JlNavigatorTDS jlNavigatorTDS, int companyId)
{
ArrayList sections = new ArrayList();
LateralLocationSheetReportGateway lateralLocationSheetReportGateway = new LateralLocationSheetReportGateway(Data);
lateralLocationSheetReportGateway.ClearBeforeFill = false;
foreach (JlNavigatorTDS.JlNavigatorRow jlNavigatorRow in jlNavigatorTDS.JlNavigator)
{
if (jlNavigatorRow.Selected)
{
if (!sections.Contains(jlNavigatorRow.AssetID))
{
sections.Add(jlNavigatorRow.AssetID);
int assetId = jlNavigatorRow.AssetID;
int workIdFll = GetWorkId(projectId, assetId, "Full Length Lining", companyId);
string measuredFrom = "USMH";
if (workIdFll > 0)
{
FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway();
fullLengthLiningWorkDetailsGateway.LoadByWorkIdAssetId(workIdFll, assetId, companyId);
measuredFrom = fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workIdFll);
}
// Get Data
lateralLocationSheetReportGateway.LoadByAssetId(assetId, companyId);
UpdateForReportForJunctionLining(assetId, workIdFll, projectId, measuredFrom, companyId);
}
}
}
lateralLocationSheetReportGateway.ClearBeforeFill = true;
}
// ////////////////////////////////////////////////////////////////////////
// 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["row_asset_id"] == null) || ((string)Request.QueryString["row_focus"] == null) || ((string)Request.QueryString["work_type"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in jl_comments.aspx");
}
// Tag Page
hdfCompanyId.Value = Session["companyID"].ToString();
hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString();
hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString();
hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString();
hdfAssetId.Value = Convert.ToString(Request.QueryString["row_asset_id"]);
hdfAdminPermission.Value = Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_ADMIN"]).ToString();
hdfWorkType.Value = Request.QueryString["work_type"].ToString();
hdfSection_.Value = Request.QueryString["section_"].ToString();
hdfUpdate.Value = "yes";
// ... Names for UserList
string workType = hdfWorkType.Value.Trim();
int companyId = Int32.Parse(hdfCompanyId.Value);
LoginGateway loginGateway = new LoginGateway();
loginGateway.LoadByLoginId(Convert.ToInt32(hdfLoginId.Value), companyId);
hdfCreatedBy.Value = loginGateway.GetLastName(Convert.ToInt32(hdfLoginId.Value), companyId) + " " + loginGateway.GetFirstName(Convert.ToInt32(hdfLoginId.Value), companyId);
hdfCreationDateTime.Value = DateTime.Now.ToString();
// Prepare initial data
Session.Remove("flatSectionJlCommentDetailsDummy");
// If coming from
// ... flat_section_jl_summary.aspx or flat_section_jl_edit.aspx
if (Request.QueryString["source_page"] == "flat_section_jl_summary.aspx" || Request.QueryString["source_page"] == "flat_section_jl_edit.aspx")
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
Session["rowFocus"] = Convert.ToInt32(Request.QueryString["row_focus"].ToString());
// ... Load comments to edit
flatSectionJlTDS = (FlatSectionJlTDS)Session["flatSectionJlTDS"];
jlNavigatorTDS = (JlNavigatorTDS)Session["jlNavigatorTDS"];
// Get workId
int assetId = Int32.Parse(hdfAssetId.Value.Trim());
int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
int jlWorkId = 0;
int raWorkId = 0;
int flWorkId = 0;
WorkGateway searchWorkGateway = new WorkGateway();
searchWorkGateway.LoadByProjectIdAssetIdWorkType(currentProjectId, assetId, "Junction Lining Lateral", companyId);
// ... If the project has jl works
if (searchWorkGateway.Table.Rows.Count > 0)
{
jlWorkId = searchWorkGateway.GetWorkId(assetId, "Junction Lining Lateral", currentProjectId);
// ... ...Tag Page
hdfWorkId.Value = jlWorkId.ToString().Trim();
// ... ...Get ra work id for comments
int section_ = Int32.Parse(hdfSection_.Value) ;
WorkGateway workGatewayRAFL = new WorkGateway();
// ... ...Get fl work id for comments
workGatewayRAFL.LoadByProjectIdAssetIdWorkType(currentProjectId, section_, "Full Length Lining", companyId);
if (workGatewayRAFL.Table.Rows.Count > 0)
{
flWorkId = workGatewayRAFL.GetWorkId(section_, "Full Length Lining", currentProjectId);
}
workGatewayRAFL.LoadByProjectIdAssetIdWorkType(currentProjectId, section_, "Rehab Assessment", companyId);
if (workGatewayRAFL.Table.Rows.Count > 0)
{
raWorkId = workGatewayRAFL.GetWorkId(section_, "Rehab Assessment", currentProjectId);
}
// ... ...Get comments
FlatSectionJlCommentDetailsGateway flatSectionJlCommentDetailsGateway = new FlatSectionJlCommentDetailsGateway(flatSectionJlTDS);
flatSectionJlCommentDetailsGateway.LoadAllByJlWorkIdRaWorkIdFlWorkId(jlWorkId, raWorkId, flWorkId, companyId);
FlatSectionJlCommentDetails flatSectionJlCommentDetails = new FlatSectionJlCommentDetails(flatSectionJlCommentDetailsGateway.Data);
flatSectionJlCommentDetails.UpdateForProcess();
// ... ...Get history
FlatSectionJlHistoryDetailsGateway flatSectionJlHistoryDetailsGateway = new FlatSectionJlHistoryDetailsGateway(flatSectionJlTDS);
flatSectionJlHistoryDetailsGateway.LoadAllByJlWorkIdRaWorkIdFlWorkId(jlWorkId, raWorkId, flWorkId, companyId);
}
// ... Store datasets
Session["flatSectionJlTDS"] = flatSectionJlTDS;
Session["jlNavigatorTDS"] = jlNavigatorTDS;
Session["flatSectionJlCommentDetails"] = flatSectionJlTDS.FlatSectionJlCommentDetails;
}
}
else
{
// Restore datasets
flatSectionJlTDS = (FlatSectionJlTDS)Session["flatSectionJlTDS"];
jlNavigatorTDS = (JlNavigatorTDS)Session["jlNavigatorTDS"];
flatSectionJlCommentDetails = flatSectionJlTDS.FlatSectionJlCommentDetails;
// Store
Session["flatSectionJlCommentDetails"] = flatSectionJlTDS.FlatSectionJlCommentDetails;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
// Tag Page
hdfBtnOrigin.Value = "Search";
string url = "";
// Delete store data
Session.Contents.Remove("jlNavigatorTDS");
// Get data from DA gateway
jlNavigatorTDS = SubmitSearch();
// Show results
if (jlNavigatorTDS.JlNavigator.Rows.Count > 0)
{
// ... Store data
Session["jlNavigatorTDS"] = jlNavigatorTDS;
// ... Go to the results page
url = "./jl_navigator2.aspx?source_page=jl_navigator2.aspx&client_id=" + hdfCurrentClientId.Value + "&project_id=" + hdfCurrentProjectId.Value + "&work_type=" + hdfWorkType.Value + GetNavigatorState();
}
else
{
// ... Go to the search page
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);
}
}
// ////////////////////////////////////////////////////////////////////////
// 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;
}
}
}
/// <summary>
/// InitData
/// </summary>
protected override void InitData()
{
_data = new JlNavigatorTDS();
}