internal void SetStudent(Model.studenci student)
{
_student = student;
Index.Text = student.nr_album;
Name.Text = student.imie_student;
SecondName.Text = student.drugie_imie_student;
LastName.Text = student.nazwisko_student;
BirthDate.Text = student.data_urodzenia_student.ToString();
BirthPlace.Text = student.miejsce_urodzenia_student;
PESEL.Text = student.pesel_student;
EMAIL.Text = student.email_student;
Phone.Text = student.telefon_student;
using (var entity = new Model.TestEntities())
{
var group = entity.grupy_dziekanskie.Where(x => x.id_grupy == _student.id_grupy).FirstOrDefault();
for (int i = 0; i < GroupCombo.Items.Count; i++)
{
if ((GroupCombo.Items[i] as Model.grupy_dziekanskie).id_grupy == group.id_grupy)
{
GroupCombo.SelectedIndex = i;
}
}
}
}
public void UpdateView()
{
StudentsView.Items.Clear();
using (var entity = new Model.TestEntities())
{
//var students = entity.studenci.Where(x => x.projekty.Where(y => y.id_proj == _project.id_proj).FirstOrDefault().id_proj == _project.id_proj);
//var students = entity.projekty.Where(e => e.id_proj == _project.id_proj).Select(e => e.studenci.All(x=>x.id_student));
try
{
var ids = entity.Database.SqlQuery <StudentsSchema>($"SELECT * FROM dbo.studenci_projekty WHERE id_proj='{_project.id_proj}'").ToList();
//var students = entity.projectsbyclass(_project.id_proj.ToString());
foreach (var item in ids)
{
var student = entity.studenci.Where(x => x.id_student == item.id_student).FirstOrDefault();
Model.oceny_projektow note = null;
note = entity.oceny_projektow.Where(x => x.id_student == item.id_student && x.id_proj == item.id_proj).FirstOrDefault();
StudentsView.Items.Add(new Model.NotesViewModel.ProjectsNotes
{
id_student = item.id_student,
id_proj = item.id_proj,
StudentName = student.imie_student,
StudentLastName = student.nazwisko_student,
Note = note != null ? note.wartosc_oceny_proj : ""
});
}
}
catch (Exception)
{
}
}
}
private void UpdateView()
{
using (var entity = new Model.TestEntities())
{
var stud_class = entity.zajecia.Where(x => x.studenci.Contains(entity.studenci.Where(u => u.id_student == _student.id_student).FirstOrDefault()));
ClassesView.Items.Clear();
try
{
foreach (var item in stud_class)
{
ClassesView.Items.Add(new Model.ClassViewModel
{
IdClass = item.id_zajec,
SubjectName = entity.przedmioty.Where(x => x.id_przed == item.id_przed).FirstOrDefault().nazwa_przed,
TeacherName = entity.prowadzacy.Where(a => a.id_prow == item.id_prow).FirstOrDefault().imie_prowadzacy + " " + entity.prowadzacy.Where(a => a.id_prow == item.id_prow).FirstOrDefault().nazwisko_prowadzacy,
TypeName = entity.typy_zajec.Where(x => x.id_typ == item.id_typ).FirstOrDefault().nazwa_typ
});
}
}
catch (System.Exception)
{
}
}
}
private void UpdateClick(object sender, RoutedEventArgs e)
{
using (var entity = new Model.TestEntities())
{
var note = Project.Text;
var query =
"BEGIN "
+ "IF NOT EXISTS(SELECT * FROM oceny_projektow "
+ $"WHERE id_student = {_projStud.id_student} "
+ $"AND id_proj = {_projStud.id_proj} "
+ $"AND id_prow = {_teacher.id_prow}) "
+ "BEGIN "
+ $"INSERT INTO dbo.oceny_projektow (id_prow, id_student, id_proj, wartosc_oceny_proj) VALUES({_teacher.id_prow},{_projStud.id_student},{_projStud.id_proj},'{note}')"
+ " END"
+ " ELSE"
+ " BEGIN"
+ $" UPDATE oceny_projektow SET wartosc_oceny_proj = {note} WHERE id_student = {_projStud.id_student} AND id_proj = {_projStud.id_proj} AND id_prow = {_teacher.id_prow}"
+ " END"
+ " END";
entity.Database.ExecuteSqlCommand(query);
_projectPage.UpdateView();
}
}
private void TaskView_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
var currentStage = ((Model.StageViewModel)StagesView.SelectedItem);
using (var entity = new Model.TestEntities())
{
Stage.Text = entity.oceny_etapow.Where(x => x.id_etap == currentStage.Id && x.id_student == _student.id_student).FirstOrDefault().wartosc;
}
}
private void DeleteBut_Click(object sender, RoutedEventArgs e)
{
using (var entity = new Model.TestEntities())
{
entity.zajecia.Where(x => x.id_zajec == _classe.id_zajec).FirstOrDefault().studenci.Remove(entity.studenci.Where(y => y.id_student == _student.id_student).FirstOrDefault());
entity.SaveChanges();
_page.UpdateView();
}
}
public ClassTypeComboViewModel()
{
using (var entity = new Model.TestEntities())
{
ClassType = new List <Model.typy_zajec>();
foreach (var item in entity.typy_zajec)
{
ClassType.Add(item);
}
}
}
public SubjectComboViewModel()
{
using (var entity = new Model.TestEntities())
{
Subject = new List <Model.przedmioty>();
foreach (var item in entity.przedmioty)
{
Subject.Add(item);
}
}
}
public void SetData(Model.studenci student)
{
Index.Text = student.nr_album;
Name.Text = student.imie_student;
LastName.Text = student.nazwisko_student;
using (var entity = new Model.TestEntities())
{
var group = entity.grupy_dziekanskie.Where(x => x.id_grupy == student.id_grupy).FirstOrDefault();
Group.Text = group.nazwa_grupy;
}
}
private void TaskView_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
var id = ((Model.ClassViewModel)ClassesView.SelectedItem).IdClass;
using (var entity = new Model.TestEntities())
{
var classe = entity.zajecia.Where(x => x.id_zajec == id).FirstOrDefault();
_projectPage = new StudentClassProjectsPage(classe, _student);
_window.ContentFrame.Content = _projectPage;
}
}
public GroupComboViewModel()
{
using (var entity = new Model.TestEntities())
{
Group = new List <Model.grupy_dziekanskie>();
foreach (var item in entity.grupy_dziekanskie)
{
Group.Add(item);
}
}
}
public TeacherComboViewModel()
{
using (var entity = new Model.TestEntities())
{
Teacher = new List <Model.prowadzacy>();
foreach (var item in entity.prowadzacy)
{
Teacher.Add(item);
}
}
}
private void DeleteBut_Click(object sender, RoutedEventArgs e)
{
using (var entity = new Model.TestEntities())
{
var a = entity.grupy_dziekanskie.Where <Model.grupy_dziekanskie>(x => x.id_grupy == _group.id_grupy).FirstOrDefault();
entity.grupy_dziekanskie.Remove(a);
entity.SaveChanges();
_page.UpdateGroupsView();
}
}
private void ApplyBut(object sender, RoutedEventArgs e)
{
using (var entity = new Model.TestEntities())
{
var project = (Model.projekty)ProjectsView.SelectedItem;
//entity.projekty.Where(x => x.id_proj == project.id_proj).FirstOrDefault().studenci.Add(entity.studenci.Where(a => a.id_student == _student.id_student).FirstOrDefault());
entity.Database.ExecuteSqlCommand($"INSERT INTO dbo.zgloszenia (id_student, id_proj, data_zgloszenia) VALUES({_student.id_student},{project.id_proj}, '{DateTime.Now.ToString()}')");
entity.SaveChanges();
}
}
private void SubjectView_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
var item = ((Model.SubjectViewModel)SubjectView.SelectedItem);
using (var entity = new Model.TestEntities())
{
var subject = entity.przedmioty.Where(x => x.id_przed == item.IdSubject).FirstOrDefault();
_subjectPage = new SubjectPage(subject, _teacher);
SupSubjectBlade.Children.Clear();
_window.ContentFrame.Content = _subjectPage;
}
}
private void TaskView_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
using (var entity = new Model.TestEntities())
{
var id = ((Model.ProjectViewModel)ProjectsView.SelectedItem).Id;
var project = entity.projekty.Where(x => x.id_proj == id).FirstOrDefault();
_projectPage = new ProjectPage(project);
_projectPage.SetData(_teacher, project);
_projectPage.ProjectNameLbl.Content = project.nazwa_proj;
_window.ContentFrame.Content = _projectPage;
}
}
private void AddGroupClick(object sender, RoutedEventArgs e)
{
using (var entity = new Model.TestEntities())
{
var gr = ((Model.grupy_dziekanskie)GroupCombo.SelectedItem).id_grupy;
entity.zajecia.Where(x => x.id_zajec == _class.id_zajec).FirstOrDefault().grupy_dziekanskie.Add(entity.grupy_dziekanskie.Where(x => x.id_grupy == gr).FirstOrDefault());
entity.SaveChanges();
UpdateGroupView();
}
}
private void DeleteBut_Click(object sender, RoutedEventArgs e)
{
using (var entity = new Model.TestEntities())
{
var a = entity.zajecia.Where <Model.zajecia>(x => x.id_zajec == _class.id_zajec).FirstOrDefault();
entity.zajecia.Remove(a);
_page.SupClassBlade.Children.Clear();
entity.SaveChanges();
_page.UpdateClassView();
}
}
private void TaskView_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
var id = ((Model.ClassViewModel)(ClassesView.SelectedItem)).IdClass;
Model.zajecia classe;
using (var entity = new Model.TestEntities())
{
classe = entity.zajecia.Where(x => x.id_zajec == id).FirstOrDefault();
}
_teacherStudentsClassPage = new TeacherStudentsClassPage(classe);
_window.ContentFrame.Content = _teacherStudentsClassPage;
}
private void SubjectView_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
var project = ((Model.ProjectViewModel)SubjectView.SelectedItem);
using (var entitiy = new Model.TestEntities())
{
var proj = entitiy.projekty.Where(x => x.id_proj == project.Id).FirstOrDefault();
_projectBlade = new Blades.StudentProjectBlade(proj, _student);
SupNewProjBlade.Children.Clear();
_projectBlade.SetData();
SupNewProjBlade.Children.Add(_projectBlade);
}
}
public void UpdateGroupsView()
{
GroupsView.SelectedItem = null;
using (Model.TestEntities entity = new Model.TestEntities())
{
GroupsView.Items.Clear();
foreach (var item in entity.grupy_dziekanskie)
{
GroupsView.Items.Add(new Model.grupy_dziekanskie {
id_grupy = item.id_grupy, nazwa_grupy = item.nazwa_grupy
});
}
}
}
public void UpdateStudentsView()
{
StudentsView.SelectedItem = null;
using (Model.TestEntities entity = new Model.TestEntities())
{
StudentsView.Items.Clear();
foreach (var item in entity.studenci)
{
StudentsView.Items.Add(new Model.studenci {
nr_album = item.nr_album, imie_student = item.imie_student, nazwisko_student = item.nazwisko_student, pesel_student = item.pesel_student
});
}
}
}
private void AddBut_Click(object sender, RoutedEventArgs e)
{
using (Model.TestEntities ent = new Model.TestEntities())
{
Model.grupy_dziekanskie gr = new Model.grupy_dziekanskie
{
nazwa_grupy = Group.Text
};
ent.grupy_dziekanskie.Add(gr);
ent.SaveChanges();
_page.UpdateGroupsView();
}
}
private void UpdateBut_Click(object sender, RoutedEventArgs e)
{
using (Model.TestEntities ent = new Model.TestEntities())
{
Model.studenci st = new Model.studenci {
imie_student = Name.Text, drugie_imie_student = LastName.Text, nazwisko_student = LastName.Text,
nr_album = Index.Text, miejsce_urodzenia_student = BirthPlace.Text, data_urodzenia_student = Convert.ToDateTime(BirthDate.Text), pesel_student = PESEL.Text,
telefon_student = Phone.Text, email_student = EMAIL.Text, id_grupy = ((Model.grupy_dziekanskie)(GroupCombo.SelectedItem)).id_grupy
};
ent.studenci.Add(st);
ent.SaveChanges();
_page.UpdateStudentsView();
}
}
internal void UpdateSubjectsView()
{
SubjectView.SelectedItem = null;
using (Model.TestEntities entity = new Model.TestEntities())
{
SubjectView.Items.Clear();
foreach (var item in entity.przedmioty)
{
var teacher = entity.prowadzacy.Where(x => x.id_prow == item.id_prow).FirstOrDefault();
SubjectView.Items.Add(new Model.SubjectViewModel {
IdSubject = item.id_przed, SubjectName = item.nazwa_przed, TeacherName = teacher.imie_prowadzacy, TeacherLastName = teacher.nazwisko_prowadzacy
});
}
}
}
private void UpdateBut_Click(object sender, RoutedEventArgs e)
{
var student = ((Model.studentsbygroup_Result)StudentsView.SelectedItem);
using (var entity = new Model.TestEntities())
{
var id = entity.studenci.Where(x => x.nr_album == student.nr_album).FirstOrDefault().id_student;
entity.zajecia.Where(x => x.id_zajec == _classe.id_zajec).FirstOrDefault().studenci.Add(entity.studenci.Where(y => y.id_student == id).FirstOrDefault());
entity.SaveChanges();
supervisorStudentsListPage.UpdateView();
}
}
private void TaskView_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
using (var entity = new Model.TestEntities())
{
var item = (Model.ClassViewModel)ClassesView.SelectedItem;
var classe = entity.zajecia.Where(s => s.id_zajec == item.IdClass).FirstOrDefault();
_classBlade.SetClass(classe);
}
SupClassBlade.Children.Clear();
SupClassBlade.Children.Add(_classBlade);
}
public ClassComboViewModel(Model.prowadzacy teacher)
{
using (var entity = new Model.TestEntities())
{
Class = new List <AdditionalInfoClasses>();
foreach (var item in entity.zajecia)
{
if (item.id_prow == teacher.id_prow)
{
Class.Add(new AdditionalInfoClasses {
Id = item.id_zajec, Subject = item.przedmioty.nazwa_przed, TypeClass = item.typy_zajec.nazwa_typ
});
}
}
}
}
private void UpdateView()
{
using (var entity = new Model.TestEntities())
{
var students = entity.studenci.Where(x => x.zajecia.Contains(entity.zajecia.Where(y => y.id_zajec == _classe.id_zajec).FirstOrDefault()));
StudentsView.Items.Clear();
try
{
foreach (var item in students)
{
StudentsView.Items.Add(item);
}
}
catch (Exception) { }
}
}
private void AddBut_Click(object sender, RoutedEventArgs e)
{
var app = ((Model.ApplicationViewModel)ApplicationsView.SelectedItem);
using (var entity = new Model.TestEntities())
{
entity.projekty.Where(x => x.id_proj == app.projId).FirstOrDefault().studenci.Add(entity.studenci.Where(a => a.id_student == app.studId).FirstOrDefault());
entity.SaveChanges();
entity.Database.ExecuteSqlCommand($"DELETE FROM dbo.zgloszenia WHERE id_proj ={app.projId} and id_student = {app.studId}");
UpdateView();
_projectPage.UpdateView();
}
}
