// /////////////////////////////////////////////////////////////////////////////////////////////////////
        //
        // STEP2 - SUMMARY
        //
        // ////////////////////////////////////////////////////////////////////////
        // STEP2 - SUMMARY - METHODS
        //
        private void StepSummaryIn()
        {
            // Set instruction
            Label instruction = (Label)this.Master.FindControl("lblInstruction");
            instruction.Text = "Summary";

            int parentProject = Convert.ToInt32(ddlParentProject.SelectedValue);
            int childProject = Convert.ToInt32(ddlChildProject.SelectedValue);
            int companyId = Convert.ToInt32(hdfCompanyId.Value);

            CommentsMigration commentsMigration = new CommentsMigration(commentsMigrationTDS);
            commentsMigration.LoadByProjectId(parentProject, childProject, companyId);

            // Initialize summary
            tbxSummary.Text = GetSummary();
        }
        private void UpdateDatabase()
        {
            DB.Open();
            DB.BeginTransaction();
            try
            {
                int parentProject = Convert.ToInt32(ddlParentProject.SelectedValue);
                int childProject = Convert.ToInt32(ddlChildProject.SelectedValue);
                int companyId = Convert.ToInt32(hdfCompanyId.Value);

                CommentsMigration commentsMigration = new CommentsMigration(commentsMigrationTDS);
                commentsMigration.Save(parentProject, childProject, companyId);

                DB.CommitTransaction();

                // Store datasets
                commentsMigrationTDS.AcceptChanges();
                Session["commentsMigrationTDS"] = commentsMigrationTDS;
            }
            catch (Exception ex)
            {
                DB.RollbackTransaction();

                string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
                Response.Redirect(url);
            }
        }
        private string GetSummary()
        {
            string summary = "GENERAL INFORMATION \n";
            summary = summary + "\n Sections: \n";

            CommentsMigration commentsMigration = new CommentsMigration(commentsMigrationTDS);
            summary += commentsMigration.GetSummary();

            return summary;
        }