private void EditButton_Click(object sender, RoutedEventArgs e)
{
MainInfoTable Save = dbContext.db.MainInfoTable.FirstOrDefault(Item => Item.ID == selecteditems.ID);
Save.HeadOfTheDepartament.NumberManager = Convert.ToInt32(tbNumberManager.Text);
Save.HeadOfTheDepartament.NameManager = tbNameManager.Text;
Save.Teacher.NumberTeacher = Convert.ToInt32(tbNumberTeacher.Text);
Save.Teacher.FullName = (tbFullnameTeacher.Text);
Save.Teacher.TheAddress = (tbAdress.Text);
Save.Teacher.Position = (comboPosition.Text);
Save.Teacher.AcademicDegree = (ComboAcademDegree.Text);
Save.Classroom.NumberClassrom = Convert.ToInt32(tbNumberClassrom.Text);
Save.Classroom.Party = (tbParty.Text);
Save.Classroom.TheDateOfThe = (DateTime)tbTheDateOfThe.SelectedDate;
Save.Classroom.LectureStartTime = tbLectureStartTime.Text;
Save.Classroom.LectureEndTime = tbLectureEndTime.Text;
Save.Lesson.NumberDiscipline = Convert.ToInt32(tbNumberDiscipline.Text);
Save.Lesson.DisciplineName = (tbDisciplineName.Text);
Save.Lesson.NumberOfHours = Convert.ToInt32(tbNumberOfHours.Text);
Save.Lesson.ControlType = (comboControlType.Text);
Save.Lesson.DisciplineSection = (comboDisciplineSection.Text);
dbContext.db.SaveChanges();
MessageBox.Show("Вы изменили данные!", "Изменение", MessageBoxButton.OK, MessageBoxImage.Information);
NavigationService.GoBack();
}
public EditPage(MainInfoTable selecteditems)
{
InitializeComponent();
this.selecteditems = selecteditems;
tbNumberManager.Text = Convert.ToString(selecteditems.HeadOfTheDepartament.NumberManager);
tbNameManager.Text = selecteditems.HeadOfTheDepartament.NameManager;
tbNumberTeacher.Text = Convert.ToString(selecteditems.Teacher.NumberTeacher);
tbFullnameTeacher.Text = selecteditems.Teacher.FullName;
tbAdress.Text = selecteditems.Teacher.TheAddress;
comboPosition.Text = selecteditems.Teacher.Position;
ComboAcademDegree.Text = selecteditems.Teacher.AcademicDegree;
tbNumberClassrom.Text = Convert.ToString(selecteditems.Classroom.NumberClassrom);
tbParty.Text = Convert.ToString(selecteditems.Classroom.Party);
tbTheDateOfThe.Text = Convert.ToString(selecteditems.Classroom.TheDateOfThe);
tbLectureStartTime.Text = selecteditems.Classroom.LectureStartTime;
tbLectureEndTime.Text = selecteditems.Classroom.LectureEndTime;
tbNumberDiscipline.Text = Convert.ToString(selecteditems.Lesson.NumberDiscipline);
tbDisciplineName.Text = selecteditems.Lesson.DisciplineName;
tbNumberOfHours.Text = Convert.ToString(selecteditems.Lesson.NumberOfHours);
comboControlType.Text = selecteditems.Lesson.ControlType;
comboDisciplineSection.Text = selecteditems.Lesson.DisciplineSection;
}
private void ButtonDelete_Click(object sender, RoutedEventArgs e)
{
try
{
MainInfoTable deleteWork = (MainInfoTable)MainTable.SelectedItem;
if (MessageBox.Show(messageBoxText: "Вы действительно хотите удалить выбранную строку?", "Уведомление", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
if (deleteWork != null)
{
dbContext.db.MainInfoTable.Remove(deleteWork);
dbContext.db.SaveChanges();
Page_Loaded(sender: null, e: null);
MessageBox.Show("Вы удалили строку", "Оповещание", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
throw new Exception(message: "Вы не выбрали строку которые хотите удалить!");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.Source, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void AddButton_Click(object sender, RoutedEventArgs e)
{
MainInfoTable newMainInfoTable = new MainInfoTable();
HeadOfTheDepartament newHeadOfTheDepartament = new HeadOfTheDepartament();
Lesson newLesson = new Lesson();
Teacher newTeacher = new Teacher();
Classroom newClassroom = new Classroom();
newHeadOfTheDepartament.NumberManager = Convert.ToInt32(tbNumberManager.Text);
newHeadOfTheDepartament.NameManager = tbNameManager.Text;
newTeacher.NumberTeacher = Convert.ToInt32(tbNumberTeacher.Text);
newTeacher.FullName = tbFullnameTeacher.Text;
newTeacher.TheAddress = tbAdress.Text;
newTeacher.Position = comboPosition.Text;
newTeacher.AcademicDegree = ComboAcademDegree.Text;
newClassroom.NumberClassrom = Convert.ToInt32(tbNumberClassrom.Text);
newClassroom.Party = (tbParty.Text);
newClassroom.TheDateOfThe = (DateTime)tbTheDateOfThe.SelectedDate;
newClassroom.LectureStartTime = (tbLectureStartTime.Text);
newClassroom.LectureEndTime = tbLectureEndTime.Text;
newLesson.NumberDiscipline = Convert.ToInt32(tbNumberDiscipline.Text);
newLesson.DisciplineName = tbDisciplineName.Text;
newLesson.NumberOfHours = Convert.ToInt32(tbNumberOfHours.Text);
newLesson.ControlType = comboControlType.Text;
newLesson.DisciplineSection = comboDisciplineSection.Text;
dbContext.db.Teacher.Add(newTeacher);
dbContext.db.Classroom.Add(newClassroom);
dbContext.db.Lesson.Add(newLesson);
dbContext.db.HeadOfTheDepartament.Add(newHeadOfTheDepartament);
dbContext.db.MainInfoTable.Add(newMainInfoTable);
newMainInfoTable.idTeacher = newHeadOfTheDepartament.ID;
newMainInfoTable.idClassroom = newHeadOfTheDepartament.ID;
newMainInfoTable.idLesson = newHeadOfTheDepartament.ID;
newMainInfoTable.idHeadOfTheDepartament = newHeadOfTheDepartament.ID;
dbContext.db.SaveChanges();
MessageBox.Show("Вы добавили данные", "Уведомление");
}
private void ButtonEdit_Click(object sender, RoutedEventArgs e)
{
try
{
MainInfoTable EditWork = (MainInfoTable)MainTable.SelectedItem;
if (EditWork != null)
{
NavigationService.Navigate(new EditPage(EditWork));
}
else
{
throw new Exception("Вы не выбрали не одного элменента!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.Source, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public MoreInfoPage(MainInfoTable selecteditem)
{
InitializeComponent();
this.selecteditem = selecteditem;
}
