/// <summary>
        /// ProcessForReport
        /// </summary>
        /// <param name="linningPlanTDS">TDS for process</param>
        public void ProcessForReport(LinningPlanTDS linningPlanTDS)
        {
            LinningPlanJlinerGateway linningPlanJlinerGateway = new LinningPlanJlinerGateway(Data);
            linningPlanJlinerGateway.ClearBeforeFill = false;
            LinningPlanJliner linningPlanJliner = new LinningPlanJliner(Data);

            foreach (LinningPlanTDS.LinningPlanRow linningPlanRow in linningPlanTDS.LinningPlan.Rows)
            {
                if (linningPlanRow.Selected != "9")
                {
                    // Create row for report
                    LinningPlanTDS.LinningPlanRow newRow = ((LinningPlanTDS.LinningPlanDataTable)Table).NewLinningPlanRow();

                    newRow.ID = linningPlanRow.ID;
                    newRow.COMPANY_ID = linningPlanRow.COMPANY_ID;
                    newRow.RecordID = linningPlanRow.RecordID;
                    if (!linningPlanRow.IsStreetNull()) newRow.Street = linningPlanRow.Street;
                    if (!linningPlanRow.IsConfirmedSizeNull()) newRow.ConfirmedSize = linningPlanRow.ConfirmedSize;
                    if (!linningPlanRow.IsBypassRequiredNull()) newRow.BypassRequired = linningPlanRow.BypassRequired;
                    if (!linningPlanRow.IsDegreeOfTrafficControlNull()) newRow.DegreeOfTrafficControl = linningPlanRow.DegreeOfTrafficControl;
                    if (!linningPlanRow.IsNumLatsNull()) newRow.NumLats = linningPlanRow.NumLats;
                    if (!linningPlanRow.IsNotLinedYetNull()) newRow.NotLinedYet = linningPlanRow.NotLinedYet;
                    if (!linningPlanRow.IsActualLengthNull()) newRow.ActualLength = linningPlanRow.ActualLength;
                    if (!linningPlanRow.IsUSMHNull()) newRow.USMH = linningPlanRow.USMH;
                    if (!linningPlanRow.IsDSMHNull()) newRow.DSMH = linningPlanRow.DSMH;
                    if (!linningPlanRow.IsAllMeasuredNull()) newRow.AllMeasured = linningPlanRow.AllMeasured;
                    if (!linningPlanRow.IsDate_Null()) newRow.Date_ = linningPlanRow.Date_;
                    if (!linningPlanRow.IsFlusherNull()) newRow.Flusher = linningPlanRow.Flusher;
                    if (!linningPlanRow.IsFlusherMNNull()) newRow.FlusherMN = linningPlanRow.FlusherMN;
                    if (!linningPlanRow.IsLinerNull()) newRow.Liner = linningPlanRow.Liner;
                    if (!linningPlanRow.IsLinerMNNull()) newRow.LinerMN = linningPlanRow.LinerMN;
                    if (!linningPlanRow.IsRotatorNull()) newRow.Rotator = linningPlanRow.Rotator;
                    if (!linningPlanRow.IsRotatorMNNull()) newRow.RotatorMN = linningPlanRow.RotatorMN;
                    if (!linningPlanRow.IsCompressorNull()) newRow.Compressor = linningPlanRow.Compressor;
                    if (!linningPlanRow.IsCompressorMNNull()) newRow.CompressorMN = linningPlanRow.CompressorMN;
                    newRow.Selected = linningPlanRow.Selected;
                    if (!linningPlanRow.IsLinerMNTypeNull()) newRow.LinerMNType = linningPlanRow.LinerMNType; else newRow.LinerMNType = "";

                    ((LinningPlanTDS.LinningPlanDataTable)Table).AddLinningPlanRow(newRow);

                    // Select jliners for report
                    linningPlanJlinerGateway.LoadByIdMn(linningPlanRow.ID, linningPlanRow.COMPANY_ID, newRow.LinerMNType);
                    linningPlanJliner.UpdateCommentsForReport();
                }
            }
        }
 /// <summary>
 /// InitData
 /// </summary>
 protected override void InitData()
 {
     _data = new LinningPlanTDS();
 }
        // ////////////////////////////////////////////////////////////////////////
        // EVENTS
        //
        protected void Page_Load(object sender, EventArgs e)
        {
            // Register client scripts
            this.RegisterClientScripts();

            if (!IsPostBack)
            {
                // Security check
                if (!Convert.ToBoolean(Session["sgLFS_APP_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"] == null))
                {
                    Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in linning_plan.aspx");
                }

                // Tag page
                hdfCurrentClient.Value = (string)Request.QueryString["client"];

                // Prepare initial data

                // ...  for the client
                int companyId = Int32.Parse(Session["companyID"].ToString());
                CompaniesGateway companiesGateway = new CompaniesGateway();
                companiesGateway.LoadByCompaniesId(int.Parse(hdfCurrentClient.Value), companyId);
                TextBox tbxCurrentClient = (TextBox)tkrpbLeftMenuCurrentClient.FindItemByValue("mCurrentClient").FindControl("tbxCurrentClient");
                tbxCurrentClient.Text = companiesGateway.GetName(int.Parse(hdfCurrentClient.Value));

                // ... for the grid
                linningPlanTDS = new LinningPlanTDS();
                LinningPlanGateway linningPlanGateway = new LinningPlanGateway(linningPlanTDS);
                linningPlanGateway.ClearBeforeFill = false;

                linningPlanGateway.LoadByCompaniesIdIssueWithLateralsNoOutOfScope(companyId, int.Parse(hdfCurrentClient.Value));
                linningPlanGateway.LoadByCompaniesIdOtherIssueWithLaterals(companyId, int.Parse(hdfCurrentClient.Value));

                grdLinningPlan.DataSource = linningPlanGateway.Table;
                grdLinningPlan.DataBind();

                // Check results
                if (linningPlanTDS.LinningPlan.Rows.Count > 0)
                {
                    pNoResults.Visible = false;
                }
                else
                {
                    pNoResults.Visible = true;
                }

                // Store dataset
                Session["linningPlanTDS"] = linningPlanTDS;
            }
            else
            {
                // Restore dataset
                linningPlanTDS = (LinningPlanTDS) Session["linningPlanTDS"];

                // ... for the grid
                LinningPlanGateway linningPlanGateway = new LinningPlanGateway(linningPlanTDS);
                linningPlanGateway.ClearBeforeFill = false;
                int companyId = Int32.Parse(Session["companyID"].ToString());
                linningPlanGateway.LoadByCompaniesIdIssueWithLateralsNoOutOfScope(companyId, int.Parse(hdfCurrentClient.Value));
                linningPlanGateway.LoadByCompaniesIdOtherIssueWithLaterals(companyId, int.Parse(hdfCurrentClient.Value));

                grdLinningPlan.DataSource = linningPlanGateway.Table;
                grdLinningPlan.DataBind();
            }
        }