// /////////////////////////////////////////////////////////////////////////////////////////////////////
        // STEP1 - BEGIN
        //
        // ////////////////////////////////////////////////////////////////////////
        // STEP1 - BEGIN - AUXILIAR EVENTS
        //
        protected void ddlFieldToUpdate_SelectedIndexChanged(object sender, EventArgs e)
        {
            // Date fields
            if ((ddlFieldToUpdate.SelectedValue == "VideoInspection") || (ddlFieldToUpdate.SelectedValue == "PipeLocated") || (ddlFieldToUpdate.SelectedValue == "ServicesLocated") || (ddlFieldToUpdate.SelectedValue == "CoInstalled")
                || (ddlFieldToUpdate.SelectedValue == "BackfilledConcrete") || (ddlFieldToUpdate.SelectedValue == "BackfilledSoil") || (ddlFieldToUpdate.SelectedValue == "Grouted") || (ddlFieldToUpdate.SelectedValue == "Cored")
                || (ddlFieldToUpdate.SelectedValue == "Prepped") || (ddlFieldToUpdate.SelectedValue == "PreVideo") || (ddlFieldToUpdate.SelectedValue == "Measured") || (ddlFieldToUpdate.SelectedValue == "NoticeDelivered")
                || (ddlFieldToUpdate.SelectedValue == "InProcess") || (ddlFieldToUpdate.SelectedValue == "InStock") || (ddlFieldToUpdate.SelectedValue == "Delivered") || (ddlFieldToUpdate.SelectedValue == "LinerInstalled")
                || (ddlFieldToUpdate.SelectedValue == "FinalVideo") || (ddlFieldToUpdate.SelectedValue == "CoCutDown") || (ddlFieldToUpdate.SelectedValue == "FinalRestoration")
                || (ddlFieldToUpdate.SelectedValue == "DigRequiredPriorToLiningCompleted") || (ddlFieldToUpdate.SelectedValue == "DigRequiredAfterLiningCompleted") || (ddlFieldToUpdate.SelectedValue == "HoldClientIssueResolved")
                || (ddlFieldToUpdate.SelectedValue == "HoldLFSIssueResolved") || (ddlFieldToUpdate.SelectedValue == "LateralRequiresRoboticPrepCompleted")
               )
            {
                tkrdpValue.Visible = true;
                cbxValue.Visible = false;
                ddlCoPitLocationValue.Visible = false;
                tbxComments.Visible = false;
                ddlPrepType.Visible = false;
                ddlLinerType.Visible = false;
                tbxValue.Visible = false;
            }
            else
            {
                tbxValue.Visible = false;

                // String fields
                if (ddlFieldToUpdate.SelectedValue == "CoPitLocation")
                {
                    tkrdpValue.Visible = false;
                    cbxValue.Visible = false;
                    ddlCoPitLocationValue.Visible = true;
                    ddlPrepType.Visible = false;
                    ddlLinerType.Visible = false;
                    tbxComments.Visible = false;
                }

                // String fields
                if (ddlFieldToUpdate.SelectedValue == "PrepType")
                {
                    tkrdpValue.Visible = false;
                    cbxValue.Visible = false;
                    ddlCoPitLocationValue.Visible = false;
                    ddlPrepType.Visible = true;
                    ddlLinerType.Visible = false;
                    tbxComments.Visible = false;
                }

                // String fields
                if (ddlFieldToUpdate.SelectedValue == "LinerType")
                {
                    tkrdpValue.Visible = false;
                    cbxValue.Visible = false;
                    ddlCoPitLocationValue.Visible = false;
                    ddlPrepType.Visible = false;
                    ddlLinerType.Visible = true;
                    tbxComments.Visible = false;
                }

                // String fields
                if (ddlFieldToUpdate.SelectedValue == "ContractYear")
                {
                    tkrdpValue.Visible = false;
                    cbxValue.Visible = false;
                    ddlCoPitLocationValue.Visible = false;
                    ddlPrepType.Visible = false;
                    ddlLinerType.Visible = false;
                    tbxComments.Visible = false;
                    tbxValue.Visible = true;
                }

                // Boolean fields
                if ((ddlFieldToUpdate.SelectedValue == "CoRequired") || (ddlFieldToUpdate.SelectedValue == "OutOfScope") || (ddlFieldToUpdate.SelectedValue == "DigRequiredPriorToLining") || (ddlFieldToUpdate.SelectedValue == "DigRequiredAfterLining") || (ddlFieldToUpdate.SelectedValue == "HoldClientIssue")
                    || (ddlFieldToUpdate.SelectedValue == "HoldLFSIssue") || (ddlFieldToUpdate.SelectedValue == "LateralRequiresRoboticPrep"))
                {
                    tkrdpValue.Visible = false;
                    cbxValue.Visible = true;
                    ddlCoPitLocationValue.Visible = false;
                    ddlPrepType.Visible = false;
                    ddlLinerType.Visible = false;
                    tbxComments.Visible = false;
                }

                // Special fields - Comment
                if (ddlFieldToUpdate.SelectedValue == "Comment")
                {
                    tkrdpValue.Visible = false;
                    cbxValue.Visible = false;
                    ddlCoPitLocationValue.Visible = false;
                    ddlPrepType.Visible = false;
                    ddlLinerType.Visible = false;
                    tbxComments.Visible = true;

                    FlatSectionJlCommentDetailsGateway flatSectionJlCommentDetailsGateway = new FlatSectionJlCommentDetailsGateway(flatSectionJlTDS);
                    flatSectionJlCommentDetailsGateway.ClearBeforeFill = false;
                    FlatSectionJl flatSectionJl = new FlatSectionJl(flatSectionJlTDS);
                    DataView dataViewFlatSectionJl = new DataView(flatSectionJlTDS.FlatSectionJl);
                    dataViewFlatSectionJl.RowFilter = "(Selected = 1) AND (Deleted = 0)";

                    foreach (DataRowView row in dataViewFlatSectionJl)
                    {
                        int workId = Int32.Parse(row["WorkID"].ToString());
                        int companyId = Int32.Parse(Session["companyID"].ToString());

                        // Get comments
                        flatSectionJlCommentDetailsGateway.LoadAllByWorkIdWorkType(workId, companyId, "Junction Lining Lateral");
                    }
                }
            }
        }