/// <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; }