/// <summary>
    /// To load Intake Form details from database
    /// </summary>
    /// <returns></returns>
    private DataTable GetIntakeFormdetails()
    {
        IntakeFormBAL IntakeFormBAL = new IntakeFormBAL();
        DataTable     DtIntakeGet   = new DataTable();

        try
        {
            DtIntakeGet = IntakeFormBAL.LoadAllIntakeForm(LoginUser, Ret);
        }
        catch
        {
        }
        finally
        {
            IntakeFormBAL = null;
        }
        return(DtIntakeGet);
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        int Result;
        int WS1PhaseId,
            WS1StatusId,
            StakeholderRelationshipManagerId,
            ReviewCourseOutlines,
            WS1PlanValidated,
            AlignmentWithKBSAStrategyId,
            AlignmentWithKPMGStrategyId,
            BusinessImpactOnProcessId,
            BusinessImpactOnPeopleId,
            BusinessImpactOnBottomLineId,
            CostBudgetImpactId,
            CostReasonablenessId,
            RiskToKPMGId,
            RiskToKBSAId,
            WS2PrioritizationFlag,
            WS2PrioritizationScore,
            WS2FlagOutput;
        string DecisionMaker,
            TrainingNeedName,
            BackgroundInformation,
            ProblemStatement,
            BusinessReasonsAndDrivers,
            StakeholderPerceptionOfPriority,
            RequestedSolution,
            CommentsOnRequestedTimeline,
            TargetAudienceDescription,
            CurrentBusinessAndPerformanceState,
            DesiredBusinessAndPerformanceOutcomes,
            CauseOfGap,
            SummarizeGapAssessment,
            AnalyzeSolutionDescription,
            DescriptionOfTheTopics,
            ImpactedBusinessGoal,
            SummaryofImpactonALDcurriculumALDFirmresources,
            OtherComments,
            CommentsonProposedTimeline,
            WS2ConditionalPriorityTiers;
        DateTime Origin_MeetingDate,
            ProposedDateofTrainingImplementation,
            ProposedDateofTrainingCompletion,
            RequestedTrainingCompletationDate,
            RequestedTrainingImplementationDate;
        // fields with multivalue
        string IntakeFormStakeholderID,
            TargetAudienceByLevel,
            Industries,
            Specialites,
            ApplicableToOtherFunctions,
            ResourcesStakeholderCanPotentiallyProvide,
            RecomendedReviewerTypes,
            SignificantImpactOnTraining,
            AnalyzeSolution,
            CurriculumKeywords;
        WS1PhaseId = 1;
        WS1StatusId = Convert.ToInt32(ddlWSStatus.SelectedValue);
        StakeholderRelationshipManagerId = Convert.ToInt32(ddlSRM.SelectedValue);
        DecisionMaker = txtDesicionMaker.Text;
        Origin_MeetingDate = Convert.ToDateTime(txtOrigin_MeetingDate.Text);
        TrainingNeedName = txtTrainingNeedName.Text;
        BackgroundInformation = txtBackgroundInformation.Text;
        ProblemStatement = txtProblemStatement.Text;
        BusinessReasonsAndDrivers = txtBusinessReasonsAndDrivers.Text;
        StakeholderPerceptionOfPriority = txtStakeholderPerceptionOfPriority.Text;
        RequestedSolution = txtRequestedSolution.Text;
        RequestedTrainingImplementationDate = Convert.ToDateTime(txtRequestedTrainingImplementationDate.Text);
        RequestedTrainingCompletationDate = Convert.ToDateTime(txtRequestedTrainingCompletationDate.Text);
        CommentsOnRequestedTimeline = txtCommentsOnRequestedTimeline.Text;
        TargetAudienceDescription = txtTargetAudienceDescription.Text;
        ReviewCourseOutlines = 0;
        CurrentBusinessAndPerformanceState = txtCurrentBusinessAndPerformanceState.Text;
        DesiredBusinessAndPerformanceOutcomes = txtDesiredBusinessAndPerformanceOutcomes.Text;
        CauseOfGap = txtCauseOfGap.Text;
        SummarizeGapAssessment = txtSummarizeGapAssessment.Text;
        AnalyzeSolutionDescription = txtAnalyzeSolutionDescription.Text;
        DescriptionOfTheTopics = txtDescriptionOfTheTopics.Text;
        ImpactedBusinessGoal = txtImpactedBusinessGoal.Text;
        SummaryofImpactonALDcurriculumALDFirmresources = txtSummaryofImpactonALDcurriculumALDFirmresources.Text;
        OtherComments = txtOtherComments.Text;
        ProposedDateofTrainingImplementation = Convert.ToDateTime(txtProposedDateofTrainingImplementation.Text);
        ProposedDateofTrainingCompletion = Convert.ToDateTime(txtProposedDateofTrainingCompletion.Text);
        CommentsonProposedTimeline = txtCommentsonProposedTimeline.Text;
        WS1PlanValidated = Convert.ToInt32(ddlWS1PlanValidated.SelectedValue);
        AlignmentWithKBSAStrategyId = Convert.ToInt32(ddlAlignmentWithKBSAStrategy.SelectedValue);
        AlignmentWithKPMGStrategyId = Convert.ToInt32(ddlAlignmentWithKPMGStrategy.SelectedValue);
        BusinessImpactOnProcessId = Convert.ToInt32(ddlBusinessImpactOnProcess.SelectedValue);
        BusinessImpactOnPeopleId = Convert.ToInt32(ddlBusinessImpactOnPeople.SelectedValue);
        BusinessImpactOnBottomLineId = Convert.ToInt32(ddlBusinessImpactOnBottomLine.SelectedValue);
        CostBudgetImpactId = Convert.ToInt32(ddlCostBudgetImpact.SelectedValue);
        CostReasonablenessId = Convert.ToInt32(ddlCostReasonableness.SelectedValue);
        RiskToKPMGId = Convert.ToInt32(ddlRiskToKPMG.SelectedValue);
        RiskToKBSAId = Convert.ToInt32(ddlRiskToKBSA.SelectedValue);
        WS2PrioritizationFlag = 1;
        WS2PrioritizationScore = 2;
        WS2FlagOutput = 1;
        WS2ConditionalPriorityTiers = lblWS2ConditionalPriorityTiers.Text;
        IntakeFormBAL IntakeFormBAL = new IntakeFormBAL();
        IntakeFormStakeholderID = GetStakeholderXml();
        TargetAudienceByLevel = GetTargetAudienceByLevelXml();
        Industries = GetIndustriesXml();
        Specialites = GetSpecialitesXml();
        ApplicableToOtherFunctions = GetApplicableToOtherFunctionsXml();
        ResourcesStakeholderCanPotentiallyProvide = GetResourcesStakeholderCanPotentiallyProvideXml();
        RecomendedReviewerTypes = GetRecomendedReviewerTypesXml();
        SignificantImpactOnTraining = GetSignificantImpactOnTrainingXml();
        AnalyzeSolution = GetAnalyzeSolutionXml();
        CurriculumKeywords = GetCurriculumKeywordsXml();
        if (chkReviewCourseOutlines.Checked == true)
        {
            ReviewCourseOutlines = 1;
        }
        else if (chkReviewCourseOutlines.Checked == false)
        {
            ReviewCourseOutlines = 0;
        }

            Result = IntakeFormBAL.InsertIntakeForm(WS1PhaseId, WS1StatusId, StakeholderRelationshipManagerId,
                IntakeFormStakeholderID, DecisionMaker, Origin_MeetingDate,
                TrainingNeedName, BackgroundInformation, ProblemStatement, BusinessReasonsAndDrivers,
                StakeholderPerceptionOfPriority, RequestedSolution, RequestedTrainingImplementationDate,
                RequestedTrainingCompletationDate, CommentsOnRequestedTimeline, TargetAudienceByLevel, Industries,
                Specialites, ApplicableToOtherFunctions, TargetAudienceDescription,
                ResourcesStakeholderCanPotentiallyProvide, ReviewCourseOutlines, RecomendedReviewerTypes,
                CurrentBusinessAndPerformanceState, SignificantImpactOnTraining,
                DesiredBusinessAndPerformanceOutcomes, CauseOfGap, SummarizeGapAssessment, AnalyzeSolution,
                AnalyzeSolutionDescription, CurriculumKeywords, DescriptionOfTheTopics,
                ImpactedBusinessGoal, SummaryofImpactonALDcurriculumALDFirmresources, OtherComments,
                ProposedDateofTrainingImplementation, ProposedDateofTrainingCompletion,
                CommentsonProposedTimeline, WS1PlanValidated, AlignmentWithKBSAStrategyId, AlignmentWithKPMGStrategyId,
                BusinessImpactOnProcessId, BusinessImpactOnPeopleId,
                BusinessImpactOnBottomLineId, CostBudgetImpactId, CostReasonablenessId, RiskToKPMGId, RiskToKBSAId,
                WS2PrioritizationFlag, WS2FlagOutput, WS2PrioritizationScore,
                WS2ConditionalPriorityTiers, LoginUser, Ret);
    }
    /// <summary>
    /// To get details of particular Intake Form ID Stakeholder Details
    /// </summary>
    /// <param name="IntFmId"></param>
    /// <returns></returns>
    private DataTable GetTrainingImpactOnDetails(int IntFmId)
    {
        IntakeFormBAL IntakeFormBAL = new IntakeFormBAL();
        DataTable DtStkholderDet = new DataTable();
        try
        {
            DtStkholderDet = IntakeFormBAL.SelectTrainingImpactOnDetails(IntFmId, LoginUser, Ret);
        }
        catch
        {

        }
        finally
        {
            IntakeFormBAL = null;
        }

        return DtStkholderDet;
    }
    /// <summary>
    /// To get details of particular Intake Form ID
    /// </summary>
    /// <param name="IntFmId"></param>
    /// <returns></returns>
    private DataTable GetIntakeFormDetails(int IntFmId)
    {
        IntakeFormBAL IntakeFormBAL = new IntakeFormBAL();
        DataTable DtIntakeDet = new DataTable();
        try
        {
            DtIntakeDet = IntakeFormBAL.SelectIntakeFormId(IntFmId, LoginUser, Ret);
        }
        catch
        {

        }
        finally
        {
           IntakeFormBAL = null;
        }

        return DtIntakeDet;
    }
    /// <summary>
    /// To load Intake Form details from database 
    /// </summary>
    /// <returns></returns>
    private DataTable GetIntakeFormdetails()
    {
        IntakeFormBAL  IntakeFormBAL=new IntakeFormBAL();
        DataTable DtIntakeGet = new DataTable();
        try
        {
            DtIntakeGet = IntakeFormBAL.LoadAllIntakeForm(LoginUser, Ret);
        }
        catch
        {

        }
        finally
        {
            IntakeFormBAL = null;
        }
        return DtIntakeGet;
    }