Example #1
0
        // gets ALL systems from a given uId
        public Inventory(string uId)
        {
            DBAContext dBAContext = new DBAContext();

            var result = (from Answers in dBAContext.Answers
                          orderby Answers.AId
                          where Answers.UId == uId
                          select Answers.AId).Distinct().ToList();

            int numOfSystems = result.Count();

            getSections();
            getSystems(uId, numOfSystems);
        }
Example #2
0
        public InventoryItem(string uId, string aId)
        {
            DBAContext  dBAContext = new DBAContext();
            Environment e          = new Environment();

            SectionScores = new int[Environment.NumSec];
            int iaId = int.Parse(aId);

            for (int i = 1; i <= Environment.NumQus; i++)
            {
                Answer a = (from t in dBAContext.Answers where ((uId == t.UId) & (i == t.QId) & (iaId == t.AId)) select t).FirstOrDefault();

                if (a == null)
                {
                    if (e.GetQuestionRO(i - 1) == "0" || e.GetQuestionRO(i - 1) == null)
                    {
                        HasUnanswered = true;
                    }
                    else
                    {
                        int    ro        = int.Parse(e.GetQuestionRO(i - 1));
                        Answer aReliesOn = (from t in dBAContext.Answers where ((uId == t.UId) & (ro == t.QId) & (iaId == t.AId)) select t).FirstOrDefault();

                        if (aReliesOn == null || aReliesOn.Value != e.GetQuestionROV(ro - 1))
                        {
                            HasUnanswered = true;
                        }
                    }
                }
                else
                {
                    if (a.programName != null)
                    {
                        Name = a.programName.Trim();
                    }
                    else
                    {
                        Name = "";
                    }

                    AId = a.AId;
                    int sectionNum = e.GetQuestionSection(a.QId);

                    if (a.Value == true)
                    {
                        SectionScores[sectionNum] += e.GetQuestionYV(a.QId - 1);
                    }
                    else if (a.Value == false)
                    {
                        SectionScores[sectionNum] += e.GetQuestionNV(a.QId - 1);
                    }

                    if (a.LastUsed > LastUsed)
                    {
                        LastUsed = a.LastUsed;
                    }
                }
            }

            int scoreDivisor = 9;

            for (int i = 0; i < SectionScores.Length; i++)
            {
                SectionScores[i] /= scoreDivisor;
            }
        }