private void ZaladujComboBox() { DeansOfficeDB db = new DeansOfficeDB(); SemesterComboBox.DataSource = db.Semestrs.ToList(); SemesterComboBox.DisplayMember = "NazwaSemestr"; }
public MainForm() { DeansOfficeDB db = new DeansOfficeDB(); InitializeComponent(); ZaladujDane(); ZaladujComboBox(); }
private void SemesterComboBox_SelectedIndexChanged(object sender, EventArgs e) { DeansOfficeDB db = new DeansOfficeDB(); var selectedSemestrID = ((Semestr)SemesterComboBox.SelectedValue).IdSemestr; var result = db.Students.ToList().Where((student) => student.IdSemestr == selectedSemestrID).ToList(); StudentsDataGridView.DataSource = result; }
private void RemoveStudentToolStripMenuItem_Click(object sender, EventArgs e) { DeansOfficeDB db = new DeansOfficeDB(); var studentID = (int)StudentsDataGridView.SelectedRows[0].Cells[0].Value; var student = db.Students.Where(s => s.IdStudent == studentID).First(); db.Students.Remove(student); db.SaveChanges(); ZaladujDane(); ZaladujComboBox(); }
private void OkButton_Click(object sender, EventArgs e) { var imie = FirstNameTextBox.Text; var nazwisko = LastNameTextBox.Text; var email = EmailTextBox.Text; var pesel = PeselTextBox.Text; var nrPaszportu = PassportNumberTextBox.Text; var obywatelstwo = CitizenshipTextBox.Text; var index = IndexNumberTextBox.Text; // DO ZMIANY var rokZapisania = _rokZapisaniaMock; var semestr = _semestrMock; var nrIndeksuMock = IndexNumberTextBox.Text; var db = new DeansOfficeDB(); var student = new Student() { Email = email, IdSemestr = _semestrMock, Imie = imie, Nazwisko = nazwisko, Pesel = pesel, NumerIndeksu = nrIndeksuMock, NumerPaszportu = nrPaszportu, Obywatelstwo = obywatelstwo, Semestr = db.Semestrs.ToList()[0], RokZapisania = rokZapisania, Telefon = TelephoneTextBox.Text }; if (this.student == null) { db.Students.Add(student); db.SaveChanges(); this.DialogResult = DialogResult.OK; } else { var studentToEdit = db.Students.Where(s => s.IdStudent == this.student.IdStudent).First(); studentToEdit.Email = email; studentToEdit.IdSemestr = _semestrMock; studentToEdit.Imie = imie; studentToEdit.Nazwisko = nazwisko; studentToEdit.Pesel = pesel; studentToEdit.NumerIndeksu = nrIndeksuMock; studentToEdit.NumerPaszportu = nrPaszportu; studentToEdit.Obywatelstwo = obywatelstwo; studentToEdit.Semestr = db.Semestrs.ToList()[0]; studentToEdit.RokZapisania = rokZapisania; studentToEdit.Telefon = TelephoneTextBox.Text; db.SaveChanges(); this.DialogResult = DialogResult.OK; } }
private void EditStudentToolStripMenuItem_Click(object sender, EventArgs e) { var studentID = (int)StudentsDataGridView.SelectedRows[0].Cells[0].Value; DeansOfficeDB db = new DeansOfficeDB(); //db.Students.ToList().Where(s=>s.IdStudent = student.Cells.) var form = new StudentDialog(); form.EditStudent(db.Students.ToList().Where(s => s.IdStudent == studentID).ToList()[0]); form.ShowDialog(); if (form.DialogResult == DialogResult.OK) { ZaladujDane(); ZaladujComboBox(); } }
private void ZaladujDane() { DeansOfficeDB db = new DeansOfficeDB(); StudentsDataGridView.DataSource = db.Students.ToList(); }