private void LoadTechnical()
        {
            // Data for Technical tab
            ProjectTechnicalGateway projectTechnicalGateway = new ProjectTechnicalGateway(projectTDS);

            if (projectTDS.LFS_PROJECT_TECHNICAL.Rows.Count == 0)
            {
                // ... If the project has no Technical
                ProjectTechnical projectTechnical = new ProjectTechnical(projectTDS);
                projectTechnical.Insert(int.Parse(hdfProjectId.Value), false, false, false, null, false, false, null, null, null, Int32.Parse(hdfCompanyId.Value.Trim()));
            }
            else
            {
                // ... If the project has Technical
                cbxAvailableDrawings.Checked = projectTechnicalGateway.GetDrawings(int.Parse(hdfProjectId.Value));
                cbxAvailableVideo.Checked = projectTechnicalGateway.GetVideo(int.Parse(hdfProjectId.Value));
                //cbxGroundConditions.Checked = projectTechnicalGateway.GetGroundConditions(int.Parse(hdfProjectId.Value));
                //tbxGroundCondition.Text = projectTechnicalGateway.GetGrounConditionsNotes(int.Parse(hdfProjectId.Value));
                //cbxReviewVideoInspections.Checked = projectTechnicalGateway.GetReviewVideo(int.Parse(hdfProjectId.Value));
                //cbxStrangeConfigurations.Checked = projectTechnicalGateway.GetStrangeConfigurations(int.Parse(hdfProjectId.Value));
                //tbxStrangeConfigurations.Text = projectTechnicalGateway.GetStrangeConfigurationsNotes(int.Parse(hdfProjectId.Value));
                //tbxFurtherObservations.Text = projectTechnicalGateway.GetFurtherObservations(int.Parse(hdfProjectId.Value));
                //tbxRestrictiveFactors.Text = projectTechnicalGateway.GetRestrictiveFactors(int.Parse(hdfProjectId.Value));
            }
        }
        private void InsertProjectTechnical(int originalProjectId)
        {
            // ... Data for current project
            ProjectTechnicalGateway projectTechnicalGateway = new ProjectTechnicalGateway(projectTDS);
            projectTechnicalGateway.LoadByProjectId(originalProjectId);

            if (projectTechnicalGateway.Table.Rows.Count > 0)
            {
                // ... Definition of general variables
                bool availableDrawings = projectTechnicalGateway.GetDrawings(originalProjectId);
                bool availableVideo = projectTechnicalGateway.GetVideo(originalProjectId);
                bool groundConditions = projectTechnicalGateway.GetGroundConditions(originalProjectId);
                string grounConditionNotes = null; if (projectTechnicalGateway.GetGrounConditionsNotes(originalProjectId) != "") grounConditionNotes = projectTechnicalGateway.GetGrounConditionsNotes(originalProjectId);
                bool reviewVideoInspections = projectTechnicalGateway.GetReviewVideo(originalProjectId);
                bool strangeConfigurations = projectTechnicalGateway.GetStrangeConfigurations(originalProjectId);
                string strangeConfigurationsNotes = null; if (projectTechnicalGateway.GetStrangeConfigurationsNotes(originalProjectId) != "") strangeConfigurationsNotes = projectTechnicalGateway.GetStrangeConfigurationsNotes(originalProjectId);
                string furtherObservations = null; if (projectTechnicalGateway.GetFurtherObservations(originalProjectId) != "") furtherObservations = projectTechnicalGateway.GetFurtherObservations(originalProjectId);
                string restrictiveFactors = null; if (projectTechnicalGateway.GetRestrictiveFactors(originalProjectId) != "") restrictiveFactors = projectTechnicalGateway.GetRestrictiveFactors(originalProjectId);

                // ... Insert Technical
                ProjectTechnical projectTechnical = new ProjectTechnical(projectTDS);
                projectTechnical.Insert(0, availableDrawings, availableVideo, groundConditions, grounConditionNotes, reviewVideoInspections, strangeConfigurations, strangeConfigurationsNotes, furtherObservations, restrictiveFactors, Int32.Parse(hdfCompanyId.Value.Trim()));
            }
        }