// ////////////////////////////////////////////////////////////////////////
        //  METHODS
        //
        public ManholeRehabilitationTDS.CommentDetailsDataTable GetCommentsNew()
        {
            manholeRehabilitationCommentDetails = (ManholeRehabilitationTDS.CommentDetailsDataTable)Session["manholeRehabilitationCommentDetailsDummy"];
            if (manholeRehabilitationCommentDetails == null)
            {
                manholeRehabilitationCommentDetails = ((ManholeRehabilitationTDS.CommentDetailsDataTable)Session["manholeRehabilitationCommentDetails"]);
            }

            return manholeRehabilitationCommentDetails;
        }
        protected void AddCommentsNewEmptyFix(GridView grdComments)
        {
            if (grdComments.Rows.Count == 0)
            {
                int companyId = Int32.Parse(hdfCompanyId.Value);
                ManholeRehabilitationTDS.CommentDetailsDataTable dt = new ManholeRehabilitationTDS.CommentDetailsDataTable();
                dt.AddCommentDetailsRow(-1, -1, "", "", -1, DateTime.Now, "", -1, false, companyId, false, "", false, "");
                Session["manholeRehabilitationCommentDetailsDummy"] = dt;

                grdComments.DataBind();
            }

            // Normally executes at all postbacks
            if (grdComments.Rows.Count == 1)
            {
                ManholeRehabilitationTDS.CommentDetailsDataTable dt = (ManholeRehabilitationTDS.CommentDetailsDataTable)Session["manholeRehabilitationCommentDetailsDummy"];
                if (dt != null)
                {
                    grdComments.Rows[0].Visible = false;
                    grdComments.Rows[0].Controls.Clear();
                }
            }
        }
        // ////////////////////////////////////////////////////////////////////////
        // EVENTS
        //
        protected void Page_Load(object sender, EventArgs e)
        {
            // Register client scripts
            this.RegisterClientScripts();

            if (!IsPostBack)
            {
                // Security check
                if (!(Convert.ToBoolean(Session["sgLFS_CWP_MANHOLEREHABILITATION_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_MANHOLEREHABILITATION_EDIT"])))
                {
                    Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
                }

                // Validate query string
                if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["client_id"] == null) || ((string)Request.QueryString["project_id"] == null) || ((string)Request.QueryString["work_id"] == null) || ((string)Request.QueryString["asset_id"] == null) || ((string)Request.QueryString["in_project"] == null))
                {
                    Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in mr_comments.aspx");
                }

                // Tag Page
                hdfCompanyId.Value = Session["companyID"].ToString();
                hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString();
                hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString();
                hdfInProject.Value = Request.QueryString["in_project"].ToString();
                hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString();
                hdfAdminPermission.Value = Convert.ToBoolean(Session["sgLFS_CWP_MANHOLEREHABILITATION_ADMIN"]).ToString();
                hdfWorkType.Value = "Manhole Rehabilitation";
                hdfWorkId.Value = Request.QueryString["work_id"].ToString();
                hdfAssetId.Value = Request.QueryString["asset_id"].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);

                // Prepare initial data
                Session.Remove("manholeRehabilitationCommentDetailsDummy");

                // If coming from
                // ... mr_summary.aspx and mr_edit.aspx
                if (Request.QueryString["source_page"] == "mr_summary.aspx" || Request.QueryString["source_page"] == "mr_edit.aspx")
                {
                    StoreNavigatorState();
                    ViewState["update"] = Request.QueryString["update"];

                    manholeRehabilitationTDS = (ManholeRehabilitationTDS)Session["manholeRehabilitationTDS"];

                    int assetId = Int32.Parse(hdfAssetId.Value.Trim());
                    int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim());
                    int workId = Int32.Parse(hdfWorkId.Value.Trim());

                    // ... If the project has works
                    if (workId != 0)
                    {
                        ManholeRehabilitationCommentDetailsGateway manholeRehabilitationCommentDetailsGateway = new ManholeRehabilitationCommentDetailsGateway(manholeRehabilitationTDS);
                        manholeRehabilitationCommentDetailsGateway.LoadAllByWorkIdWorkType(workId,companyId, "Manhole Rehabilitation");

                        ManholeRehabilitationCommentDetails manholeRehabilitationCommentDetailsForLoad = new ManholeRehabilitationCommentDetails(manholeRehabilitationCommentDetailsGateway.Data);
                        manholeRehabilitationCommentDetailsForLoad.UpdateForProcess();
                    }

                    // ... Store datasets
                    Session["manholeRehabilitationTDS"] = manholeRehabilitationTDS;
                    Session["manholeRehabilitationCommentDetails"] = manholeRehabilitationTDS.CommentDetails;
                }
            }
            else
            {
                // Restore datasets
                manholeRehabilitationTDS = (ManholeRehabilitationTDS)Session["manholeRehabilitationTDS"];
                manholeRehabilitationCommentDetails = manholeRehabilitationTDS.CommentDetails;

                // Store
                Session["manholeRehabilitationCommentDetails"] = manholeRehabilitationTDS.CommentDetails;
            }
        }