private void browseForDBFileButtonClick(object sender, EventArgs e) { OpenFileDialog openDialog = new OpenFileDialog(); openDialog.InitialDirectory = @"c:\"; openDialog.Filter = "Access database files (*.mdb)|*.mdb"; openDialog.FilterIndex = 2; openDialog.RestoreDirectory = true; openDialog.Multiselect = false; string filePath = ""; if (openDialog.ShowDialog() == DialogResult.OK) { filePath = openDialog.FileName.ToString(); filePathLabel.Text = filePath; Import import = new Import(filePath); foreach (Curriculum c in import.Curriculums) { mDBManager.Lessons.Add(c); } foreach (Teacher t in import.Teachers) { if (t.Color == Color.Empty) { t.Color = RandomColor.GetRandomColor(); } mDBManager.Teachers.Add(t); } foreach (Subject s in import.Subjects) { if (s.Color == Color.Empty) { s.Color = RandomColor.GetRandomColor(); } mDBManager.Subjects.Add(s); } foreach (Class c in import.Classes) { if (c.Color == Color.Empty) { c.Color = RandomColor.GetRandomColor(); } mDBManager.Classes.Add(c); } } }
public static void Main() { Import import = new Import(@"D:\ScheduleWorks\Data.mdb"); Console.WriteLine("hey: {0}", import.Subjects.Count); /*BasicClass b = new BasicClass(1, "1", "first", "I"); EducationForm e = new EducationForm(1, "day'n'night", "dnn"); Class shit = new Class(1, "a", b); List<ClassDetails> details = new List<ClassDetails> { new ClassDetails(2, 0, new ClassType(1, "die", "die"), b, e) }; details[0].SetDetailed(shit); shit.SetDetails(details); Console.WriteLine(shit.Division); shit.Details[0].Detailed.Division = "die, m**********r!"; Console.WriteLine(shit.Division);*/ foreach (var item in import.Curriculums) { Console.WriteLine("{0}\n{1} {2}\n{3} {4}", item.ID, item.Class.Division, item.Class.Grade, item.Subject.Name, item.HoursPerWeek); } }