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(); }
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(); } } }