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