public ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable GetProjectAddSectionsNew()
{
projectAddSectionsNew = (ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable)Session["projectAddSectionsNewDummy"];
if (projectAddSectionsNew == null)
{
projectAddSectionsNew = (ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable)Session["projectAddSectionsNew"];
}
return projectAddSectionsNew;
}
protected void grdProjectAddSectionsNew_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
// Update section
Page.Validate("AddSectionsUpdate");
if (Page.IsValid)
{
int id = (int)e.Keys["ID"];
int companyId = Int32.Parse(hdfCompanyId.Value);
string sectionId = ((Label)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[0].FindControl("lblSectionIdEdit")).Text;
string street = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxStreetEdit")).Text;
string usmh = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxUsmhEdit")).Text;
string dsmh = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxDsmhEdit")).Text;
string mapSize = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxMapSizeEdit")).Text;
string mapLength = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxMapLengthEdit")).Text;
string clientId = "";
if (((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxClientIdEdit")).Text.Trim() != "")
{
clientId = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxClientIdEdit")).Text;
}
string sectionMaterial = "";
if (((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("ddlSectionMaterialEdit")).SelectedValue != "-1")
{
sectionMaterial = ((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("ddlSectionMaterialEdit")).SelectedValue;
}
bool cbxRA = ((CheckBox)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("cbxRehabAssessmentWorkEdit")).Checked;
bool cbxFLL = ((CheckBox)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("cbxFullLengthLiningWorkEdit")).Checked;
bool cbxPR = ((CheckBox)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("cbxPointRepairsWorkEdit")).Checked;
bool cbxJL = ((CheckBox)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("cbxJunctionLiningWorkEdit")).Checked;
bool cbxMHRehabUsmh = ((CheckBox)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("cbxMHRehabUsmhEdit")).Checked;
bool cbxMHRehabDsmh = ((CheckBox)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("cbxMHRehabDsmhEdit")).Checked;
string usmhStreet = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxUsmhStreetEdit")).Text.Trim();
string usmhLatitude = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxUsmhLatitudeEdit")).Text.Trim();
string usmhLongitude = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxUsmhLongitudeEdit")).Text.Trim();
string usmhShape = ((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlUsmhShapeEdit")).SelectedValue;
string usmhLocation = ((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlUsmhLocationEdit")).SelectedValue;
int? usmhConditionRating = null;
if (((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlUsmhConditionRatingEdit")).SelectedValue != "-1")
{
usmhConditionRating = Int32.Parse(((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlUsmhConditionRatingEdit")).SelectedValue);
}
int? usmhMaterialId = null;
string usmhMaterial = "";
if (((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlUsmhMaterialEdit")).SelectedValue != "-1")
{
usmhMaterialId = Int32.Parse(((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlUsmhMaterialEdit")).SelectedValue);
AssetSewerMHMaterialTypeGateway assetSewerMHMaterialTypeGatewayForUsmh = new AssetSewerMHMaterialTypeGateway();
assetSewerMHMaterialTypeGatewayForUsmh.LoadByMaterialId((int)usmhMaterialId, companyId);
usmhMaterial = assetSewerMHMaterialTypeGatewayForUsmh.GetMaterialType((int)usmhMaterialId);
}
string dsmhStreet = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxDsmhStreetEdit")).Text.Trim();
string dsmhLatitude = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxDsmhLatitudeEdit")).Text.Trim();
string dsmhLongitude = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxDsmhLongitudeEdit")).Text.Trim();
string dsmhShape = ((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlDsmhShapeEdit")).SelectedValue;
string dsmhLocation = ((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlDsmhLocationEdit")).SelectedValue;
int? dsmhConditionRating = null;
if (((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlDsmhConditionRatingEdit")).SelectedValue != "-1")
{
dsmhConditionRating = Int32.Parse(((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlDsmhConditionRatingEdit")).SelectedValue);
}
int? dsmhMaterialId = null;
string dsmhMaterial = "";
if (((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlDsmhMaterialEdit")).SelectedValue != "-1")
{
dsmhMaterialId = Int32.Parse(((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlDsmhMaterialEdit")).SelectedValue);
AssetSewerMHMaterialTypeGateway assetSewerMHMaterialTypeGatewayForDsmh = new AssetSewerMHMaterialTypeGateway();
assetSewerMHMaterialTypeGatewayForDsmh.LoadByMaterialId((int)dsmhMaterialId, companyId);
dsmhMaterial = assetSewerMHMaterialTypeGatewayForDsmh.GetMaterialType((int)dsmhMaterialId);
}
// ... get structure data
string usmhTopDiameter = "";
string usmhTopDepth = "";
string usmhDownDiameter = "";
string usmhDownDepth = "";
int? usmhManholeRugs = null;
string usmhRectangle1LongSide = "";
string usmhRectangle1ShortSide = "";
string usmhRectangle2LongSide = "";
string usmhRectangle2ShortSide = "";
string usmhTotalSurfaceArea = "";
string dsmhTopDiameter = "";
string dsmhTopDepth = "";
string dsmhDownDiameter = "";
string dsmhDownDepth = "";
int? dsmhManholeRugs = null;
string dsmhRectangle1LongSide = "";
string dsmhRectangle1ShortSide = "";
string dsmhRectangle2LongSide = "";
string dsmhRectangle2ShortSide = "";
string dsmhTotalSurfaceArea = "";
// Update datasets
ProjectAddSectionsTDS dataSet = new ProjectAddSectionsTDS();
dataSet.ProjectAddSectionsNew.Merge(projectAddSectionsNew, true);
ProjectAddSectionsNew model = new ProjectAddSectionsNew(dataSet);
// Update
model.Update(id, sectionId, street, usmh, dsmh, cbxJL, cbxRA, cbxFLL, cbxPR, false, sectionId, mapSize, mapLength, usmhStreet, usmhLatitude, usmhLongitude, usmhShape, usmhLocation, usmhConditionRating, usmhMaterialId, usmhMaterial, usmhTopDiameter, usmhTopDepth, usmhDownDiameter, usmhDownDepth, usmhManholeRugs, usmhRectangle1LongSide, usmhRectangle1ShortSide, usmhRectangle2LongSide, usmhRectangle2ShortSide, usmhTotalSurfaceArea, dsmhStreet, dsmhLatitude, dsmhLongitude, dsmhShape, dsmhLocation, dsmhConditionRating, dsmhMaterialId, dsmhMaterial, dsmhTopDiameter, dsmhTopDepth, dsmhDownDiameter, dsmhDownDepth, dsmhManholeRugs, dsmhRectangle1LongSide, dsmhRectangle1ShortSide, dsmhRectangle2LongSide, dsmhRectangle2ShortSide, dsmhTotalSurfaceArea, sectionMaterial, clientId, cbxMHRehabUsmh, cbxMHRehabDsmh);
Session["projectAddSectionsNew"] = dataSet.ProjectAddSectionsNew;
projectAddSectionsNew = dataSet.ProjectAddSectionsNew;
}
else
{
e.Cancel = true;
}
}
protected void grdProjectAddSectionsNew_RowDataBound(object sender, GridViewRowEventArgs e)
{
// Edit controls
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate))))
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int id = Int32.Parse(((Label)e.Row.FindControl("lblID")).Text);
ProjectAddSectionsTDS dataSet = new ProjectAddSectionsTDS();
dataSet.ProjectAddSectionsNew.Merge(projectAddSectionsNew, true);
ProjectAddSectionsNew model = new ProjectAddSectionsNew(dataSet);
projectAddSectionsNew = dataSet.ProjectAddSectionsNew;
ProjectAddSectionsNewGateway projectAddSectionsNewGatewayForGrid = new ProjectAddSectionsNewGateway(dataSet);
if (projectAddSectionsNewGatewayForGrid.Table.Rows.Count > 0)
{
((DropDownList)e.Row.FindControl("ddlSectionMaterialEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetSectionMaterial(id).ToString();
((DropDownList)e.Row.FindControl("ddlUsmhShapeEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetUsmhShape(id);
((DropDownList)e.Row.FindControl("ddlUsmhLocationEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetUsmhLocation(id);
((DropDownList)e.Row.FindControl("ddlUsmhConditionRatingEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetUsmhConditionRating(id).ToString();
((DropDownList)e.Row.FindControl("ddlUsmhMaterialEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetUsmhMaterialId(id).ToString();
((DropDownList)e.Row.FindControl("ddlDsmhShapeEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetDsmhShape(id);
((DropDownList)e.Row.FindControl("ddlDsmhLocationEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetDsmhLocation(id);
((DropDownList)e.Row.FindControl("ddlDsmhConditionRatingEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetDsmhConditionRating(id).ToString();
((DropDownList)e.Row.FindControl("ddlDsmhMaterialEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetDsmhMaterialId(id).ToString();
}
}
// Footer Item
if (e.Row.RowType == DataControlRowType.Footer)
{
switch (hdfWorkType.Value)
{
case "All":
((CheckBox)e.Row.FindControl("cbxRehabAssessmentWorkAdd")).Checked = true;
((CheckBox)e.Row.FindControl("cbxFullLengthLiningWorkAdd")).Checked = true;
((CheckBox)e.Row.FindControl("cbxPointRepairsWorkAdd")).Checked = true;
((CheckBox)e.Row.FindControl("cbxJunctionLiningWorkAdd")).Checked = true;
((CheckBox)e.Row.FindControl("cbxMHRehabUsmhAdd")).Checked = true;
((CheckBox)e.Row.FindControl("cbxMHRehabDsmhAdd")).Checked = true;
break;
case "Rehab Assessment":
((CheckBox)e.Row.FindControl("cbxRehabAssessmentWorkAdd")).Checked = true;
((CheckBox)e.Row.FindControl("cbxFullLengthLiningWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxPointRepairsWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxJunctionLiningWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxMHRehabUsmhAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxMHRehabDsmhAdd")).Checked = false;
break;
case "Full Length Lining":
((CheckBox)e.Row.FindControl("cbxRehabAssessmentWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxFullLengthLiningWorkAdd")).Checked = true;
((CheckBox)e.Row.FindControl("cbxPointRepairsWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxJunctionLiningWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxMHRehabUsmhAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxMHRehabDsmhAdd")).Checked = false;
break;
case "Point Repairs":
((CheckBox)e.Row.FindControl("cbxRehabAssessmentWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxFullLengthLiningWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxPointRepairsWorkAdd")).Checked = true;
((CheckBox)e.Row.FindControl("cbxJunctionLiningWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxMHRehabUsmhAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxMHRehabDsmhAdd")).Checked = false;
break;
case "Junction Lining":
((CheckBox)e.Row.FindControl("cbxRehabAssessmentWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxFullLengthLiningWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxPointRepairsWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxJunctionLiningWorkAdd")).Checked = true;
((CheckBox)e.Row.FindControl("cbxMHRehabUsmhAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxMHRehabDsmhAdd")).Checked = false;
break;
case "Manhole Rehabilitation":
((CheckBox)e.Row.FindControl("cbxRehabAssessmentWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxFullLengthLiningWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxPointRepairsWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxJunctionLiningWorkAdd")).Checked = false;
((CheckBox)e.Row.FindControl("cbxMHRehabUsmhAdd")).Checked = true;
((CheckBox)e.Row.FindControl("cbxMHRehabDsmhAdd")).Checked = true;
break;
}
}
}
protected void ProjectAddSectionsNewEmptyFix(GridView grdView)
{
if (grdView.Rows.Count == 0)
{
ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable dt = new ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable();
dt.AddProjectAddSectionsNewRow(-1, "", "", "", "", false, false, false, false, "", "", "", false, "", "", "", "","", -1, "", "","","", "", -1, "", "","","","","","","","","",-1, "","","","","",-1,"","","","","", -1, -1, "", "", false, false);
Session["projectAddSectionsNewDummy"] = dt;
grdView.DataBind();
}
// normally executes at all postbacks
if (grdView.Rows.Count == 1)
{
ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable dt = (ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable)Session["projectAddSectionsNewDummy"];
if (dt != null)
{
// hide row
grdView.Rows[0].Visible = false;
grdView.Rows[0].Controls.Clear();
}
}
}
// ////////////////////////////////////////////////////////////////////////
// INITIAL 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["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 project_add_sections.aspx");
}
// Security check
if ((string)Request.QueryString["work_type"] == "Rehab Assessment")
{
if (!(Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_ADD"])))
{
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_ADD"])))
{
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_ADD"])))
{
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_ADD"])))
{
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_ADD"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
// Tag Page
TagPage();
// Prepare initial data
Session.Remove("projectAddSectionsNew");
Session.Remove("projectAddSectionsNewDummy");
Session.Remove("projectAddSectionsSearch");
Session.Remove("projectAddSectionsSearchDummy");
Session.Remove("projectAddSectionsTemp");
Session.Remove("projectAddSectionsTempDummy");
// Initialize viewstate variables
ViewState["StepFrom"] = "Out";
// If coming from
// ... ra_navigator.aspx, ra_navigator2.aspx, jl_navigator.aspx, jl_navigator2.aspx, project_sections_navigator.aspx, project_sections_navigator2.aspx, fl_navigator.aspx, fl_navigator2.aspx, ra_lining_plan.aspx, fl_edit.aspx, fl_summary.aspx, ra_edit.aspx, ra_summary.aspx, flat_section_jl_summary.aspx, flat_section_jl_edit.aspx, flat_section_jls_summary.aspx, flat_section_jls_edit.aspx, jl_lining_plan.aspx, pr_navigator.aspx, pr_navigator2.aspx, pr_summay.aspx, pr_edit.aspx, pr_lining_plan, mr_navigator.aspx, mr_navigator2.aspx, mr_edit.aspx, mr_summary.aspx
if ((Request.QueryString["source_page"] == "ra_navigator.aspx") || (Request.QueryString["source_page"] == "ra_navigator2.aspx") || (Request.QueryString["source_page"] == "jl_navigator.aspx") || (Request.QueryString["source_page"] == "jl_navigator2.aspx") || (Request.QueryString["source_page"] == "project_sections_navigator.aspx") || (Request.QueryString["source_page"] == "project_sections_navigator2.aspx") || (Request.QueryString["source_page"] == "fl_navigator.aspx") || (Request.QueryString["source_page"] == "fl_navigator2.aspx") || (Request.QueryString["source_page"] == "ra_lining_plan.aspx") || (Request.QueryString["source_page"] == "fl_edit.aspx") || (Request.QueryString["source_page"] == "fl_summary.aspx") || (Request.QueryString["source_page"] == "ra_edit.aspx") || (Request.QueryString["source_page"] == "ra_summary.aspx") || (Request.QueryString["source_page"] == "flat_section_jl_summary.aspx") || (Request.QueryString["source_page"] == "flat_section_jl_edit.aspx") || (Request.QueryString["source_page"] == "flat_section_jls_summary.aspx") || (Request.QueryString["source_page"] == "flat_section_jls_edit.aspx") || (Request.QueryString["source_page"] == "jl_lining_plan.aspx") || (Request.QueryString["source_page"] == "pr_navigator.aspx") || (Request.QueryString["source_page"] == "pr_navigator2.aspx") || (Request.QueryString["source_page"] == "pr_summary.aspx") || (Request.QueryString["source_page"] == "pr_edit.aspx") || (Request.QueryString["source_page"] == "pr_lining_plan.aspx") || (Request.QueryString["source_page"] == "mr_navigator.aspx") || (Request.QueryString["source_page"] == "mr_navigator2.aspx") || (Request.QueryString["source_page"] == "mr_edit.aspx") || (Request.QueryString["source_page"] == "mr_summary.aspx"))
{
// ... Initialize tables
projectAddSectionsNew = new ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable();
projectAddSectionsSearch = new ProjectAddSectionsTDS.ProjectAddSectionsSearchDataTable();
projectAddSectionsTemp = new ProjectAddSectionsTDS.ProjectAddSectionsTempDataTable();
// ... Store tables
Session["projectAddSectionsNew"] = projectAddSectionsNew;
Session["projectAddSectionsSearch"] = projectAddSectionsSearch;
Session["projectAddSectionsTemp"] = projectAddSectionsTemp;
}
// StepSection1In
wzSections.ActiveStepIndex = 0;
StepBeginIn();
}
else
{
// Restore tables
projectAddSectionsNew = (ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable) Session["projectAddSectionsNew"];
projectAddSectionsSearch = (ProjectAddSectionsTDS.ProjectAddSectionsSearchDataTable)Session["projectAddSectionsSearch"];
projectAddSectionsTemp = (ProjectAddSectionsTDS.ProjectAddSectionsTempDataTable)Session["projectAddSectionsTemp"];
}
// control for postback
hdfTag.Value = DateTime.Now.ToLongTimeString();
}
