/// <summary> /// Метод для добавлення групи /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button3_Click(object sender, EventArgs e) { if (textBoxGroupname.Text != string.Empty && comboBox1.SelectedIndex != -1 && textBox1.Text != string.Empty && comboBoxSemester.SelectedIndex != -1) { int semestr = int.Parse(comboBoxSemester.Text); dataBase.Groups.Add(new ProgramLogicDll.Group { Name = textBoxGroupname.Text, Profession = comboBox1.Text, HoursOfStudy = textBox1.Text, Semesters = dataBase.Semesters.Where(sem => sem.SemesterNumber == semestr).FirstOrDefault(), Students = students, Teachers = teachers }); dataBase.SaveChanges(); foreach (var item in students) { dataBase.Students.Where(stud => stud.StudentId == item.StudentId).FirstOrDefault().Groups = dataBase.Groups.Where(id => id.Name == textBoxGroupname.Text).FirstOrDefault(); dataBase.SaveChanges(); } foreach (var item in teachers) { dataBase.Teachers.Where(teacher => teacher.TeacherId == item.TeacherId).FirstOrDefault().Groups.Add(dataBase.Groups.Where(id => id.Name == textBoxGroupname.Text).FirstOrDefault()); dataBase.SaveChanges(); } textBoxGroupname.Text = textBox1.Text = string.Empty; listBox1.Items.Clear(); listBox2.Items.Clear(); UpdateData(); MessageBox.Show("Group added", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Enter all fields", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Метод для добавлення студента /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { if (textBox1.Text != string.Empty && textBox2.Text != string.Empty && textBox3.Text != string.Empty && textBox4.Text != string.Empty && textBox5.Text != string.Empty && comboBox1.SelectedIndex != -1) { dataBase.Students.Add(new ProgramLogicDll.Student { FirstName = textBox1.Text, LastName = textBox2.Text, Age = int.Parse(textBox3.Text), PhoneNumber = textBox4.Text, Email = textBox5.Text, Profession = comboBox1.SelectedItem.ToString(), DateOfReceipt = dateTimePicker1.Value, ExpirationDate = dateTimePicker2.Value, Groups = null }); dataBase.SaveChanges(); textBox1.Text = textBox2.Text = textBox3.Text = textBox4.Text = textBox5.Text = string.Empty; MessageBox.Show("Student add", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Enter all fields", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Метод для видалення компютера з аудиторії /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button2_Click(object sender, EventArgs e) { if (listBox2.SelectedIndex != -1) { listBox1.Items.Add(listBox2.SelectedItem); int Id = int.Parse(listBox2.SelectedItem.ToString()); computers.Remove(dataBase.Computers.Where(id => id.ComputerId == Id).FirstOrDefault()); dataBase.Computers.Where(id => id.ComputerId == Id).FirstOrDefault().Audiences = null; dataBase.SaveChanges(); listBox2.Items.RemoveAt(listBox2.SelectedIndex); } else { MessageBox.Show("Choise computer", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Метод для добавлення аудиторії /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button3_Click(object sender, EventArgs e) { if (textBox1.Text != null && textBox2.Text != null) { if (Convert.ToInt32(textBox2.Text) > listBox2.Items.Count) { int audienceNumber = int.Parse(textBox1.Text); if (dataBase.Audiences.Where(number => number.AudienceNumber == audienceNumber).FirstOrDefault() == null) { dataBase.Audiences.Add(new ProgramLogicDll.Audience { AudienceNumber = int.Parse(textBox1.Text), NumberOfSeats = int.Parse(textBox2.Text), Computers = computers, Groups = Groups }); dataBase.SaveChanges(); foreach (var item in computers) { dataBase.Computers.Where(id => id.ComputerId == item.ComputerId).FirstOrDefault().Audiences = dataBase.Audiences.Where(number => number.AudienceNumber == audienceNumber).FirstOrDefault(); dataBase.SaveChanges(); } foreach (var item in Groups) { dataBase.Groups.Where(id => id.GroupId == item.GroupId).FirstOrDefault().Audiences = dataBase.Audiences.Where(number => number.AudienceNumber == audienceNumber).FirstOrDefault(); dataBase.SaveChanges(); } textBox1.Text = textBox2.Text = string.Empty; UpdateData(); MessageBox.Show("Audience added", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("This audience already exists", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("There are more computers than seats", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Enter all fields", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Метод для зберігання відредактованого компютера /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button3_Click(object sender, EventArgs e) { if (textBox1.Text != string.Empty && textBox2.Text != string.Empty && textBox3.Text != string.Empty && comboBox1.SelectedIndex != -1) { int Id = int.Parse(comboBox1.SelectedItem.ToString()); var computer = dataBase.Computers.Where(computerId => computerId.ComputerId == Id).FirstOrDefault(); computer.GraphicsCard = textBox1.Text; computer.Processor = textBox2.Text; computer.RAM = int.Parse(textBox3.Text); computer.Softwares = softwares; dataBase.SaveChanges(); textBox1.Text = textBox2.Text = textBox3.Text = string.Empty; listBox1.Items.Clear(); listBox2.Items.Clear(); UpdateComputers(); softwares.Clear(); MessageBox.Show("Computer edited", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Choise computer or add all fields", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Метод для збереження відредактованого ПЗ /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { if (comboBox1.SelectedIndex != -1 && textBox1.Text != string.Empty) { if (dataBase.Softwares.Where(software => software.Name == textBox1.Text).FirstOrDefault() == null) { dataBase.Softwares.Where(software => software.Name == comboBox1.SelectedItem.ToString()).FirstOrDefault().Name = textBox1.Text; dataBase.SaveChanges(); textBox1.Text = string.Empty; UpdateSoftwares(); MessageBox.Show("Software edited", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("This software already exists", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Choise software", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Збереження відредактованого предмету /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { if (textBox1.Text != string.Empty && comboBox1.SelectedIndex != -1) { if (dataBase.Subjects.Where(subject => subject.Name == textBox1.Text).FirstOrDefault() == null) { dataBase.Subjects.Where(subject => subject.Name == comboBox1.SelectedItem.ToString()).FirstOrDefault().Name = textBox1.Text; dataBase.SaveChanges(); textBox1.Text = string.Empty; UpdateSubjects(); MessageBox.Show("Subject edited", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("This subject already exists", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Enter or choise subject", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Метод для зберігання відредактованого студента /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { if (textBox1.Text != string.Empty && textBox2.Text != string.Empty && textBox3.Text != string.Empty && textBox4.Text != string.Empty && textBox5.Text != string.Empty && comboBox2.SelectedIndex != -1 && comboBox1.SelectedIndex != -1) { int studentId = students[comboBox1.SelectedIndex].StudentId; var student = dataBase.Students.Where(Id => Id.StudentId == studentId).FirstOrDefault(); student.FirstName = textBox1.Text; student.LastName = textBox2.Text; student.Age = int.Parse(textBox3.Text); student.PhoneNumber = textBox4.Text; student.Email = textBox5.Text; student.Profession = comboBox2.SelectedItem.ToString(); student.DateOfReceipt = dateTimePicker1.Value; student.ExpirationDate = dateTimePicker2.Value; textBox1.Text = textBox2.Text = textBox3.Text = textBox4.Text = textBox5.Text = comboBox2.Text = string.Empty; dataBase.SaveChanges(); UpdateStudets(); MessageBox.Show("Student edited", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Enter all fields or choise student", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Метод для добавлення ПЗ /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { if (textBox1.Text != string.Empty) { if (dataBase.Softwares.Where(soft => soft.Name == textBox1.Text).FirstOrDefault() == null) { dataBase.Softwares.Add(new ProgramLogicDll.Software { Name = textBox1.Text }); dataBase.SaveChanges(); textBox1.Text = string.Empty; MessageBox.Show("Software added", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("This software already exists", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Enter software", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Метод для добавлення семестру /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { if (textBox1.Text != string.Empty) { int number = int.Parse(textBox1.Text); if (dataBase.Semesters.Where(sem => sem.SemesterNumber == number).FirstOrDefault() == null) { dataBase.Semesters.Add(new ProgramLogicDll.Semester { SemesterNumber = int.Parse(textBox1.Text) }); dataBase.SaveChanges(); textBox1.Text = string.Empty; MessageBox.Show("Semester added", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("This semester already exists", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Enter semester", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Добавлення вчителя /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button3_Click(object sender, EventArgs e) { if (textBox1.Text != string.Empty && textBox2.Text != string.Empty && textBox3.Text != string.Empty && textBox4.Text != string.Empty && textBox5.Text != string.Empty && textBox6.Text != string.Empty) { dataBase.Teachers.Add(new ProgramLogicDll.Teacher { FirstName = textBox1.Text, LastName = textBox2.Text, Age = int.Parse(textBox3.Text), PhoneNumber = textBox4.Text, Email = textBox5.Text, Salary = double.Parse(textBox6.Text), Subjects = subjects }); dataBase.SaveChanges(); textBox1.Text = textBox2.Text = textBox3.Text = textBox4.Text = textBox5.Text = textBox6.Text = string.Empty; listBox2.Items.Clear(); UpdateSubjects(); MessageBox.Show("Teacher added", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Enter all fields", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } }