private void Add() { var context = new TeacherVM(departments.ToArray()); var wind = new NewTeacher() { DataContext = context }; wind.ShowDialog(); if (wind.DialogResult == true) { bool res = false; if (context.Teacher != null) { res = RequestToDataBase.Instance.requestInsertIntoTeacher(context.Teacher); } if (context.Teacher.DepartmentTwo != null && context.Teacher.PostTwo != null) { res = RequestToDataBase.Instance.requestInsertIntoTeacherDepartmentTwo(context.Teacher) || res; } if (res) { ClassTeacher.Clear(); foreach (var value in RequestToDataBase.Instance.ReadTeachers()) { ClassTeacher.Add(value); } } } }
private void Remove() { if (Index >= 0) { var teacher = ClassTeacher[Index]; var list = new List <int>(); var element = ClassTeacher.Where(c => c.CodeOfTeacher == teacher.CodeOfTeacher).Select(t => t.CodeOfTeacher); foreach (var item in element) { list.Add(item); } if (list.Count == 2) { if (RequestToDataBase.Instance.requestDeleteFromTeacherAndDepartments(ClassTeacher, Index)) { ClassTeacher.Clear(); foreach (var value in RequestToDataBase.Instance.ReadTeachers()) { ClassTeacher.Add(value); } } } else { if (RequestToDataBase.Instance.requestDeleteFromTeacher(ClassTeacher, Index)) { ClassTeacher.Clear(); foreach (var value in RequestToDataBase.Instance.ReadTeachers()) { ClassTeacher.Add(value); } } } } }
private void Add() { var context = new TeacherVM(departments.ToArray()); var wint = new NewTeacher() { DataContext = context }; wint.ShowDialog(); System.Console.WriteLine(context.Teacher != null); if (context.Teacher != null) { ClassTeacher.Add(context.Teacher); } }
private void Load() { string pathToCsv = ""; OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.Filter = "Файл csv|*.csv"; if (openFileDialog.ShowDialog() == true) { pathToCsv = openFileDialog.FileName; } if (File.Exists(pathToCsv)) { char[] delimiters = new char[] { ';' }; using (StreamReader reader = new StreamReader(pathToCsv, System.Text.Encoding.Default)) { while (true) { string line = reader.ReadLine(); if (line == null) { break; } string[] parts = line.Split(delimiters); bool exist = false; foreach (var teacher in ClassTeacher) { if (teacher.FIO.Equals(parts[0].Trim(' ')) && (teacher.Department.NameOfDepartment.Equals(parts[4].Trim(' ')))) { exist = true; } } if (!exist) { Department Department = null; foreach (var dep in departments) { if (dep.NameOfDepartment.Equals(parts[4].Trim(' '))) { Department = dep; } } if (Department != null) { Teacher teacher = new Teacher { FIO = parts[0].Trim(' '), Post = parts[1].Trim(' '), Mail = parts[2].Trim(' '), IsReadLecture = Convert.ToBoolean(parts[3]), Department = Department }; if (RequestToDataBase.Instance.requestInsertIntoTeacher(teacher)) { ClassTeacher.Add(teacher); } if (parts.Length == 6) { Department DepartmentTwo = null; foreach (var dep in departments) { if (dep.NameOfDepartment.Equals(parts[5].Trim(' '))) { DepartmentTwo = dep; } } if (DepartmentTwo != null) { teacher.DepartmentTwo = DepartmentTwo; if (RequestToDataBase.Instance.requestInsertIntoTeacherDepartmentTwo(teacher)) { ClassTeacher.Clear(); foreach (var value in RequestToDataBase.Instance.ReadTeachers()) { ClassTeacher.Add(value); } } } } } } } } } }