private void SetSubjects() { DataBaseWorker.OpenConnection(); var items = DataBaseWorker.ExecuteQuery("SELECT Name FROM Disciplines"); DataBaseWorker.CloseConnection(); string[] arr = items.Rows.OfType <DataRow>().Select(k => k[0].ToString()).ToArray(); comboBoxDiscipline.Items.Add("Все предметы"); comboBoxDiscipline.Items.AddRange(arr); }
private Dictionary <string, string> FillDic() { DataBaseWorker.OpenConnection(); SubjectId = (int)DataBaseWorker.ExecuteQuery($"SELECT Id FROM Disciplines WHERE Name = N'{SubjectName}'") .Rows[0].ItemArray[0]; var dic = new Dictionary <string, string>() { ["Direction"] = Direction, ["Direction2"] = Direction, ["Direction3"] = Direction, ["Discipline"] = SubjectName, ["Discipline2"] = SubjectName, ["AuditoryLessons"] = GetFromDB("AuditoryLessons"), ["Competencies"] = GetFromDB("Competencies"), ["CourseWork"] = GetFromDB("CourseWork"), ["CreditUnits"] = GetFromDB("CreditUnits") + " зачётных единиц", ["Director"] = GetFromDB("Director"), ["EdForm"] = GetFromDB("EdForm"), ["Hours"] = GetFromDB("Hours"), ["Hours2"] = GetFromDB("Hours"), ["IndependentWork"] = GetFromDB("IndependentWorkBySemester"), ["InteractiveWatch"] = GetFromDB("InteractiveWatch"), ["LaboratoryExercises"] = GetFromDB("LaboratoryExercises"), ["Lectures"] = GetFromDB("Lectures"), ["Position"] = GetFromDB("Position"), ["Profile"] = GetFromDB("Profile"), ["Protocol"] = GetFromDB("Protocol").Split('№')[0].Trim() + ", протокол № " + GetFromDB("Protocol").Split('№')[1].Trim(), ["Standart"] = GetFromDB("Standart"), ["Workshops"] = GetFromDB("Workshops"), ["TypeOfLessons"] = GetFromDB("TypesOfLessons"), ["SumIndependentWork"] = GetFromDB("SumIndependentWork"), ["StudyProgram"] = GetFromDB("StudyProgram") }; return(dic); }