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