private void MetroWindow_Loaded(object sender, RoutedEventArgs e)
{
StudentsDBEntities SDE = new StudentsDBEntities();
var data = from d in SDE.StudentsTable select d;
ListaStudentowDg.ItemsSource = data.ToList();
ListaStudentowDg.Items.Refresh();
ListaStudentowDg.SelectedIndex = 0;
}
public void WyszykajTb_KeyUp(object sender, KeyEventArgs e)
{
StudentsDBEntities SDE = new StudentsDBEntities();
if (WyszykajTb.Text.Count() > 0 || OdDp.SelectedDate.HasValue || DoDp.SelectedDate.HasValue)
{
IQueryable <StudentsTable> data;
if (WyszykajTb.Text.Count() > 0)
{
if (DoDp.SelectedDate.HasValue && OdDp.SelectedDate.HasValue)
{
data = from d in SDE.StudentsTable where d.StudentName.Trim().Contains(WyszykajTb.Text.Trim()) || d.StudentSurname.Trim().Contains(WyszykajTb.Text.Trim()) || d.Id.ToString().Contains(WyszykajTb.Text.Trim()) && d.DateOfBirt >= OdDp.SelectedDate.Value && d.DateOfBirt <= DoDp.SelectedDate.Value select d;
}
else if (DoDp.SelectedDate.HasValue)
{
data = from d in SDE.StudentsTable where d.StudentName.Trim().Contains(WyszykajTb.Text.Trim()) || d.StudentSurname.Trim().Contains(WyszykajTb.Text.Trim()) || d.Id.ToString().Contains(WyszykajTb.Text.Trim()) && d.DateOfBirt <= DoDp.SelectedDate.Value select d;
}
else if (OdDp.SelectedDate.HasValue)
{
data = from d in SDE.StudentsTable where d.StudentName.Trim().Contains(WyszykajTb.Text.Trim()) || d.StudentSurname.Trim().Contains(WyszykajTb.Text.Trim()) || d.Id.ToString().Contains(WyszykajTb.Text.Trim()) && d.DateOfBirt >= OdDp.SelectedDate.Value select d;
}
else
{
data = from d in SDE.StudentsTable where d.StudentName.Trim().Contains(WyszykajTb.Text.Trim()) || d.StudentSurname.Trim().Contains(WyszykajTb.Text.Trim()) || d.Id.ToString().Contains(WyszykajTb.Text.Trim()) select d;
}
}
else
{
if (DoDp.SelectedDate.HasValue && OdDp.SelectedDate.HasValue)
{
data = from d in SDE.StudentsTable where d.DateOfBirt >= OdDp.SelectedDate.Value && d.DateOfBirt <= DoDp.SelectedDate.Value select d;
}
else if (DoDp.SelectedDate.HasValue)
{
data = from d in SDE.StudentsTable where d.DateOfBirt <= DoDp.SelectedDate.Value select d;
}
else if (OdDp.SelectedDate.HasValue)
{
data = from d in SDE.StudentsTable where d.DateOfBirt >= OdDp.SelectedDate.Value select d;
}
else
{
data = from d in SDE.StudentsTable select d;
}
}
ListaStudentowDg.ItemsSource = data.ToList();
ListaStudentowDg.Items.Refresh();
ListaStudentowDg.SelectedIndex = 0;
ListaStudentowDg_SelectionChanged(null, null);
}
else
{
MetroWindow_Loaded(null, null);
}
}
private void UsunBtn_Click(object sender, RoutedEventArgs e)
{
StudentsDBEntities SDE = new StudentsDBEntities();
var rowAssessment = (AssessmentsTable)OcenyDg.SelectedItem;
MessageBoxResult question = MessageBox.Show("Czy chcesz usunąć tę ocenę?", "Usuwanie oceny", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.No);
if (question == MessageBoxResult.Yes)
{
var UsunOceneStudenta = SDE.AssessmentsTable.Where(w => w.Id == rowAssessment.Id).FirstOrDefault();
SDE.AssessmentsTable.Remove(UsunOceneStudenta);
SDE.SaveChanges();
ListaStudentowDg_SelectionChanged(null, null);
}
}
public void ListaStudentowDg_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
var row = (StudentsTable)ListaStudentowDg.SelectedItem;
StudentsDBEntities SDE = new StudentsDBEntities();
var data = from d in SDE.AssessmentsTable select d;
if (row != null)
{
OcenyDg.ItemsSource = data.ToList().Where(IndeksID => IndeksID.IndeksID == row.Id);
}
else
{
OcenyDg.ItemsSource = new List <AssessmentsTable>();
}
}
private void UsunStudenta_Click(object sender, RoutedEventArgs e)
{
var rowStudent = (StudentsTable)ListaStudentowDg.SelectedItem;
StudentsDBEntities SDE = new StudentsDBEntities();
MessageBoxResult question = MessageBox.Show("Czy chcesz usunąć studenta: " + rowStudent.StudentName + " " + rowStudent.StudentSurname + "?", "Usuwanie studenta", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.No);
if (question == MessageBoxResult.Yes)
{
var UsunStudenta = SDE.StudentsTable.Where(w => w.Id == rowStudent.Id).FirstOrDefault();
SDE.StudentsTable.Remove(UsunStudenta);
SDE.AssessmentsTable.RemoveRange(SDE.AssessmentsTable.Where(w => w.IndeksID == rowStudent.Id));
SDE.SaveChanges();
WyszykajTb_KeyUp(null, null);
ListaStudentowDg_SelectionChanged(null, null);
}
}