//public static QuestionPercentage GetQuestionPercentage(int CertificationID)
        //{
        //    QuestionPercentage questionPercentage = null;
        //    try
        //    {
        //        questionPercentage = questionPercentage = cntxt.QuestionPercentages.Where(x => x.CertificationId == CertificationID).First();
        //    }
        //    catch (Exception)
        //    {


        //    }


        //    return questionPercentage;
        //}



        //public static Decimal GetKnowledgeAreaQuestionPercentageofCertification(int questionpercentageid, int knowledgeareaid)
        //{
        //    Decimal percentage = 0;

        //    try
        //    {
        //        var q = cntxt.QuestionPercentageDetails.Where(x => x.QuestionPercentageId == questionpercentageid && x.KnowledgeAreaId == knowledgeareaid).First();
        //    }
        //    catch (Exception)
        //    {


        //    }

        //    return percentage;

        //}


        //public static QuestionPercentage CreateQuestionPercentage(int CertificationID)
        //{
        //    QuestionPercentage questionPercentage = null;


        //    if (CertificationID != 0)
        //    {

        //        questionPercentage = GetQuestionPercentage(CertificationID);


        //        if (questionPercentage == null)
        //        {
        //            questionPercentage = new QuestionPercentage();
        //            questionPercentage.QuestionPercentageId = 0;
        //            questionPercentage.CertificationId = CertificationID;

        //        }



        //        List<KnowledgeArea> knowledgeArealist = KnowledgeAreaRepository.GetAllknowledgeAreaOfCertification(CertificationID);

        //        foreach (KnowledgeArea element in knowledgeArealist)
        //        {

        //            if (!questionPercentage.QuestionPercentageDetails.Any(f => f.KnowledgeAreaId == element.KnowledgeAreaId))
        //            {

        //                QuestionPercentageDetail det = new QuestionPercentageDetail();
        //                det.KnowledgeAreaId = element.KnowledgeAreaId;
        //                det.KnowledgeArea = element;
        //                det.TotalPercentage = 0;

        //                questionPercentage.QuestionPercentageDetails.Add(det);
        //            }



        //        }

        //    }

        //    return questionPercentage;
        //}


        public static void InsertQuestionPercentageDetails(QuestionPercentageDetail questionPercentageDetail)
        {
            if (questionPercentageDetail.QuestionPercentageDetailId != 0)
            {
            }

            else
            {
                cntxt.QuestionPercentageDetails.Add(questionPercentageDetail);
                cntxt.SaveChanges();
            }
        }
Beispiel #2
0
        public static QuestionPercentage CreateQuestionPercentage(int CertificationID)
        {
            QuestionPercentage questionPercentage = null;


            if (CertificationID != 0)
            {
                questionPercentage = GetQuestionPercentage(CertificationID);


                if (questionPercentage == null)
                {
                    questionPercentage = new QuestionPercentage();
                    questionPercentage.QuestionPercentageId = 0;
                    questionPercentage.CertificationId      = CertificationID;
                }



                List <KnowledgeArea> knowledgeArealist = KnowledgeAreaRepository.GetAllknowledgeAreaOfCertification(CertificationID);

                foreach (KnowledgeArea element in knowledgeArealist)
                {
                    if (!questionPercentage.QuestionPercentageDetails.Any(f => f.KnowledgeAreaId == element.KnowledgeAreaId))
                    {
                        QuestionPercentageDetail det = new QuestionPercentageDetail();
                        det.KnowledgeAreaId = element.KnowledgeAreaId;
                        det.KnowledgeArea   = element;
                        det.TotalPercentage = 0;

                        questionPercentage.QuestionPercentageDetails.Add(det);
                    }
                }
            }

            return(questionPercentage);
        }