static void Main(string[] args) { var context = new MyDbcontext(); context.SubSubClasses.Add(new SubSubClass()); context.SaveChanges(); }
public void AddTeacher(string FirstName, string SecondName, string LastName, int Phone, string Email) { if (!(string.IsNullOrEmpty(FirstName) && string.IsNullOrWhiteSpace(FirstName)) && !(string.IsNullOrEmpty(SecondName) && string.IsNullOrWhiteSpace(SecondName)) && !(string.IsNullOrEmpty(LastName) && string.IsNullOrWhiteSpace(LastName)) && !(string.IsNullOrEmpty(Email) && string.IsNullOrWhiteSpace(Email))) { Teacher teacher = new Teacher() { FirstName = FirstName, SecondName = SecondName, LastName = LastName, Phone = Phone, Email = Email }; using (var db = new MyDbcontext()) { db.Teachers.Add(teacher); db.SaveChanges(); } } else { throw new System.InvalidOperationException("Fields are empty"); } }
public AddChairModel() { using (var db = new MyDbcontext()) { ObservableCollection <Teacher> teachers = new ObservableCollection <Teacher>(db.Teachers); Teachers = new ReadOnlyObservableCollection <Teacher>(teachers); } }
public void AddTeacher(Teacher ctz) { if (ctz != null) { _Teachers.Add(ctz); using (var db = new MyDbcontext()) { db.Teachers.Add(ctz); db.SaveChanges(); } } }
private static MyDbcontext CreateDbContext() { //从当前请求的线程取值 db = CallContext.GetData("s") as MyDbcontext; if (db == null) { db = new MyDbcontext(); //把上下文对象存入当前请求的线程中 CallContext.SetData("s", db); } return(db); }
public void RefreshTables() { _Teachers.Clear(); _Chairs.Clear(); _Facultys.Clear(); using (var db = new MyDbcontext()) { _Teachers.AddRange(db.Teachers); _Chairs.AddRange(db.Chairs); _Facultys.AddRange(db.Faculties); } }
public MainWindowModel() { Teachers = new ReadOnlyObservableCollection <Teacher>(_Teachers); Chairs = new ReadOnlyObservableCollection <Chair>(_Chairs); Facultys = new ReadOnlyObservableCollection <Faculty>(_Facultys); using (var db = new MyDbcontext()) { _Teachers.AddRange(db.Teachers); _Chairs.AddRange(db.Chairs); _Facultys.AddRange(db.Faculties); } }
private void btnSearch_Click(object sender, RoutedEventArgs e) { using (var db = new MyDbcontext()) { try { if (cbFromTable.SelectedIndex == 0) { Teacher tch = new Teacher(); switch (cbFromColumn.SelectedIndex) { case 0: tch = (from i in db.Teachers where i.FirstName == tbSearchQuery.Text select i).First(); break; case 1: tch = (from i in db.Teachers where i.SecondName == tbSearchQuery.Text select i).First(); break; case 2: tch = (from i in db.Teachers where i.LastName == tbSearchQuery.Text select i).First(); break; case 3: tch = (from i in db.Teachers where i.Phone == Convert.ToInt32(tbSearchQuery.Text) select i).First(); break; case 4: tch = (from i in db.Teachers where i.Email == tbSearchQuery.Text select i).First(); break; } tblResult.Text += tch + "\n"; } else if (cbFromTable.SelectedIndex == 1) { Faculty fcl = new Faculty(); switch (cbFromColumn.SelectedIndex) { case 0: fcl = (from i in db.Faculties where i.NameFaculty == tbSearchQuery.Text select i).First(); break; case 1: fcl = (from i in db.Faculties where i.ShortNameFaculty == tbSearchQuery.Text select i).First(); break; } tblResult.Text += fcl + "\n"; } else if (cbFromTable.SelectedIndex == 2) { Chair chr = new Chair(); switch (cbFromColumn.SelectedIndex) { case 0: chr = (from i in db.Chairs where i.NameChair == tbSearchQuery.Text select i).First(); break; case 1: chr = (from i in db.Chairs where i.ShortNameChair == tbSearchQuery.Text select i).First(); break; } tblResult.Text +=chr + "\n"; } } catch (InvalidOperationException) { tblResult.Text += "Ничего не найдено"; } } }
public void AddChair(string name, string shortname, Teacher teacher) { Chair chair = new Chair() { NameChair = name, ShortNameChair = shortname, }; using (var db = new MyDbcontext()) { db.Chairs.Add(chair); db.SaveChanges(); } }
public void AddFaculty(string NameF, string ShortNameF, Teacher tch) { Faculty fcl = new Faculty() { NameFaculty = NameF, ShortNameFaculty = ShortNameF }; using (var db = new MyDbcontext()) { db.Faculties.Add(fcl); db.SaveChanges(); } }
private void cbFromTable_SelectionChanged(object sender, SelectionChangedEventArgs e) { using (var db = new MyDbcontext()) { switch (cbFromTable.SelectedIndex) { case 0: cbFromColumn.ItemsSource = tchFields; break; case 1: cbFromColumn.ItemsSource = fclFields; break; case 2: cbFromColumn.ItemsSource =chrFields; break; } cbFromColumn.SelectedIndex = 0; } }
public void EditCitizen(string name, string secondname, string lastname, int phone, string email) { using (var db = new MyDbcontext()) { Teacher tch = new Teacher() { FirstName = name, LastName = lastname, SecondName = secondname, Phone = phone, Email = email }; var teacher = (from i in db.Teachers where i.Id == tch.Id select i).First(); teacher.FirstName = tch.FirstName; teacher.LastName = tch.LastName; teacher.SecondName = tch.SecondName; teacher.Phone = tch.Phone; teacher.Email = tch.Email; db.SaveChanges(); Debug.WriteLine("Изменение завершено"); } }
public StudentInfoRepository(MyDbcontext infocontext) { _infocontext = infocontext; }
public DrugaKlasaModelsController(MyDbcontext context) { _context = context; }
public MainWindowVM() { _model.PropertyChanged += (sender, args) => { RaisePropertyChanged(args.PropertyName); }; FindComplexSearch = new DelegateCommand(() => { Search cs = new Search(); cs.Show(); }); RefreshTeacherTable = new DelegateCommand(() => { _model.RefreshTables(); }); AddTeacher = new DelegateCommand(() => { AddTeacherWindow atw = new AddTeacherWindow(); atw.ShowDialog(); _model.RefreshTables(); }); EditTeacher = new DelegateCommand(() => { EditTeacherWindow ecw = new EditTeacherWindow(); ecw.DataContext = SelectedTeacher; Teacher tch = SelectedTeacher; if (ecw.ShowDialog() == true) { using (var db = new MyDbcontext()) { var Teacher = (from i in db.Teachers where i.Id == tch.Id select i).First(); Teacher.FirstName = tch.FirstName; Teacher.LastName = tch.LastName; Teacher.SecondName = tch.SecondName; db.SaveChanges(); } _model.RefreshTables(); } }); DeleteTeacher = new DelegateCommand(() => { using (var db = new MyDbcontext()) { var Teacher = (from i in db.Teachers where i.Id == SelectedTeacher.Id select i).First(); db.Teachers.Remove(Teacher); db.SaveChanges(); } _model.RefreshTables(); }); AddChair = new DelegateCommand(() => { AddChairWindow apw = new AddChairWindow(); apw.DataContext = new AddChairVM(); apw.ShowDialog(); _model.RefreshTables(); }); EditChair = new DelegateCommand(() => { EditChairWindow epw = new EditChairWindow(); Chair chr = SelectedChair; epw.DataContext = chr; if (epw.ShowDialog() == true) { using (var db = new MyDbcontext()) { var Chair = (from i in db.Chairs where i.Id == chr.Id select i).First(); Chair.NameChair = chr.NameChair; Chair.ShortNameChair = chr.ShortNameChair; db.SaveChanges(); } _model.RefreshTables(); } }); DeleteChair = new DelegateCommand(() => { using (var db = new MyDbcontext()) { var Chair = (from i in db.Chairs where i.Id == SelectedChair.Id select i).First(); db.Chairs.Remove(Chair); db.SaveChanges(); } _model.RefreshTables(); }); AddFaculty = new DelegateCommand(() => { AddFacultyWindow adw = new AddFacultyWindow(); adw.DataContext = new AddFacultyVM(); adw.ShowDialog(); _model.RefreshTables(); }); EditFaculty = new DelegateCommand(() => { EditFacultyWindow edw = new EditFacultyWindow(); Faculty fcl = SelectedFaculty; edw.DataContext = fcl; if (edw.ShowDialog() == true) { using (var db = new MyDbcontext()) { var Faculty = (from i in db.Faculties where i.Id == fcl.Id select i).First(); Faculty.NameFaculty = fcl.NameFaculty; Faculty.ShortNameFaculty = fcl.ShortNameFaculty; db.SaveChanges(); } _model.RefreshTables(); } }); DeleteFaculty = new DelegateCommand(() => { using (var db = new MyDbcontext()) { var Faculty = (from i in db.Faculties where i.Id == SelectedFaculty.Id select i).First(); db.Faculties.Remove(Faculty); db.SaveChanges(); } _model.RefreshTables(); }); FindByCypher = new DelegateCommand(() => { FindByCypherWindow fbc = new FindByCypherWindow(); fbc.Show(); }); SaveToJSON = new DelegateCommand(() => { _model.SaveToJSON(Teachers, Chairs, Faculties); MessageBox.Show("Все сохранено"); }); }
public LoaisController(MyDbcontext context) { _context = context; }
public HomeController(MyDbcontext context) { _context = context; }