示例#1
0
        private void CriteriaRankingForm_Load(object sender, EventArgs e)
        {
            mainForm = (MainForm)this.MdiParent;
            criteriaWeightController = new CriteriaWeightController();
            try
            {
                currentTopicId = mainForm.getCurrentTopic().topicId.ToString();
            }
            catch
            {
                this.Close();
            }


            criteriaController = new CriteriaController();
            criteriaController.autoInsertCriteriaWeight(currentTopicId);

            loadDynamicUI();

            triggerUpdateLabelConsistencyInfo();
        }
示例#2
0
        public void autoInsertCriteriaWeight(string topicId)
        {
            CriteriaWeightController criteriaWeightController = new CriteriaWeightController();
            List <List <Criteria> >  criteriaPairsList        = criteriaWeightController.generateCriteriaPair(topicId);

            for (int i = 0; i < criteriaPairsList.Count; i++)
            {
                string criteria1Id = criteriaPairsList.ElementAt(i).ElementAt(0).criteriaId.ToString();
                string criteria2Id = criteriaPairsList.ElementAt(i).ElementAt(1).criteriaId.ToString();

                if (!checkIsCriteriaWeightExist(criteria1Id, criteria2Id))
                {
                    conn.Open();
                    cmd.CommandText =
                        "INSERT INTO CriteriaWeight(Criteria1Id, Criteria2Id) " +
                        "VALUES (" + criteria1Id + "," + criteria2Id + ")";
                    cmd.ExecuteNonQuery();
                    conn.Close();
                }
            }
        }