private void comboSemester_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
comboDisc.IsEnabled = true;
using (StudentsDataContext db = new StudentsDataContext())
{
var queryDisc = from plan in db.AcademicPlan
join card in db.PersonalStudentCard on plan.ID equals card.ID_AcademicPlan
join stud in db.Student on card.Login_Student equals stud.Login
join disc in db.Discipline on plan.ID_Discipline equals disc.ID
where
stud.ID_Group == (comboGroup.SelectedItem as Groups).KOD &&
plan.Semester == (comboSemester.SelectedItem as AcademicPlan).Semester &&
card.Login_Teacher == teach.Login
group disc by new { disc.Name, disc.ID } into d
select new { d.Key.ID, d.Key.Name };
List <Discipline> listSemester = new List <Discipline> {
};
foreach (var item in queryDisc)
{
listSemester.Add(new Discipline()
{
Name = DeleteSpace(item.Name), ID = item.ID
});
}
comboDisc.ItemsSource = listSemester;
//from plan in db.AcademicPlan
// join disc in db.Discipline on plan.ID_Discipline equals disc.ID
// join card in db.PersonalStudentCard on plan.ID equals card.ID_AcademicPlan
// where card.Login_Teacher == teach.Login && disc.Name == (comboGroup.SelectedItem as Groups).KOD
}
}
public AssessWindow(Teacher teach)
{
this.teach = teach;
InitializeComponent();
using (StudentsDataContext db = new StudentsDataContext())
{
//var query = from plan in db.AcademicPlan
// join disc in db.Discipline on plan.ID_Discipline equals disc.ID
// join card in db.PersonalStudentCard on plan.ID equals card.ID_AcademicPlan
// where card.Login_Teacher == teach.Login
// select new RatingAcademPlan { = disc.Name, type = plan.TypeCertification, }
var queryGroup = from stud in db.Student
join card in db.PersonalStudentCard on stud.Login equals card.Login_Student
where card.Login_Teacher == teach.Login
group stud by new { stud.ID_Group } into groups
select new { groups.Key };
List <Groups> listGroup = new List <Groups> {
};
foreach (var item in queryGroup)
{
listGroup.Add(new Groups()
{
KOD = item.Key.ID_Group
});
}
comboGroup.ItemsSource = listGroup;
}
}
private void comboGroup_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
comboSemester.IsEnabled = true;
using (StudentsDataContext db = new StudentsDataContext())
{
var querySemester = from plan in db.AcademicPlan
join card in db.PersonalStudentCard on plan.ID equals card.ID_AcademicPlan
join stud in db.Student on card.Login_Student equals stud.Login
where stud.ID_Group == (comboGroup.SelectedItem as Groups).KOD && card.Login_Teacher == teach.Login
group plan by new { plan.Semester } into sem
select new { sem.Key };
List <AcademicPlan> listSemester = new List <AcademicPlan> {
};
foreach (var item in querySemester)
{
listSemester.Add(new AcademicPlan()
{
Semester = item.Key.Semester
});
}
comboSemester.ItemsSource = listSemester;
//from plan in db.AcademicPlan
// join disc in db.Discipline on plan.ID_Discipline equals disc.ID
// join card in db.PersonalStudentCard on plan.ID equals card.ID_AcademicPlan
// where card.Login_Teacher == teach.Login && disc.Name == (comboGroup.SelectedItem as Groups).KOD
}
}
private void ListYears_MouseDown(object sender, MouseButtonEventArgs e)
{
ratingList.Visibility = Visibility.Visible;
using (StudentsDataContext db = new StudentsDataContext())
{
ObservableCollection <PersonalCard> items = new ObservableCollection <PersonalCard> {
};
int sem = Convert.ToInt32(listYears.SelectedItem.ToString().Substring(0, 1));
var result = from all in db.func(student.Login, sem)
select all;
foreach (var item in result)
{
items.Add(new PersonalCard(DeleteSpace(item.Дисциплина), DeleteSpace(item.Вид_аттестации), item.Часы, item.Оценка));
}
ratingList.ItemsSource = items;
//from plan in db.AcademicPlan
// join card in db.PersonalStudentCard on plan.ID equals card.ID_AcademicPlan
// join disc in db.Discipline on plan.ID_Discipline equals disc.ID
// where card.Login_Student == student.Login && plan.Semester == sem
// select new { disc.Name, card.Rating, plan.TypeCertification, plan.Hours };
//Binding bind = new Binding();
//dataGrid.SetBinding(ItemsControl.ItemsSourceProperty, bind);
}
}
public PersonalCardWindow(Student student)
{
this.student = student;
InitializeComponent();
FIO.Content = DeleteSpace(student.Lastname) + " " + DeleteSpace(student.Firstname) + " " + DeleteSpace(student.Middlename);
KOD.Content = student.ID_Group;
using (StudentsDataContext db = new StudentsDataContext())
{
var years = from card in db.PersonalStudentCard
where card.Login_Student == student.Login
join plan in db.AcademicPlan on card.ID_AcademicPlan equals plan.ID
group plan by new { plan.Semester, plan.Year } into asd
select new { temp = asd.Key };
foreach (var item in years)
{
listYears.Items.Add(item.temp.Semester + " семестр (" + item.temp.Year + ")");
}
//join plan in db.AcademicPlan on year.ID_AcademicPlan equals plan.ID
//join disc in db.Discipline on plan.ID_Discipline equals disc.ID
//select new
//{
// discipline = disc.Name,
// semester = plan.Semester,
// hours = plan.Semester,
// type = plan.Semester,
// rating = year.Rating,
//};
}
}
public static List<int> GetGroups()
{
StudentsDataContext dc = new StudentsDataContext();
var res = (from Student in dc.GetTable<Student>()
select Student.Group).Distinct().ToList<int>();
return res;
}
private void ComboDisc_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
using (StudentsDataContext db = new StudentsDataContext())
{
var result = from stud in db.Student
join card in db.PersonalStudentCard on stud.Login equals card.Login_Student into studCard
from studCardJoined in studCard.DefaultIfEmpty()
join plan in db.AcademicPlan on studCardJoined.ID_AcademicPlan equals plan.ID into planStudCard
from planStudCardJoined in planStudCard.DefaultIfEmpty()
where stud.ID_Group == (comboGroup.SelectedItem as Groups).KOD &&
planStudCardJoined.Semester == (comboSemester.SelectedItem as AcademicPlan).Semester &&
planStudCardJoined.ID_Discipline == (comboDisc.SelectedItem as Discipline).ID
select new
{
Login = stud.Login,
Lastname = stud.Lastname,
Middlename = stud.Middlename,
Firstname = stud.Firstname,
Rating = studCardJoined == null ? 0: studCardJoined.Rating
};
//from plan in db.AcademicPlan
// join card in db.PersonalStudentCard on plan.ID equals card.ID_AcademicPlan
// join stud in db.Student on card.Login_Student equals stud.Login
// join disc in db.Discipline on plan.ID_Discipline equals disc.ID
// where plan.Semester == (comboSemester.SelectedItem as AcademicPlan).Semester
// && stud.ID_Group == (comboGroup.SelectedItem as Groups).KOD
// && disc.Name == (comboDisc.SelectedItem as Discipline).Name
// select new { stud.Lastname, stud.Middlename, stud.Firstname, card.Rating, stud.Login, plan.ID };
// select Student.Lastname, PersonalStudentCard.Rating from Student
//left outer join PersonalStudentCard on (PersonalStudentCard.Login_Student = Student.Login)
//left outer join AcademicPlan on(PersonalStudentCard.ID_AcademicPlan = AcademicPlan.ID)
//where Student.ID_Group = 'ТМ-1-16'
List <RatingAcademPlan> listStudent = new List <RatingAcademPlan>()
{
};
foreach (var item in result)
{
listStudent.Add(new RatingAcademPlan()
{
Rating = item.Rating,
Student = DeleteSpace(item.Lastname) + " " + item.Firstname[0] + ". " + item.Middlename[0] + ".",
ID_Stud = item.Login
});
}
RatingList.ItemsSource = listStudent;
}
}
public static bool _IfFacNumberExist(string facNumber)
{
StudentsDataContext dc = new StudentsDataContext();
var queryResult = (from students in dc.GetTable<Student>()
where (students.FacNumber == facNumber)
select students).ToArray<Student>();
if (queryResult.Count<Student>() > 0)
{
return true;
}
else
{
return false;
}
}
public static bool InsertStudent(Student s)
{
StudentsDataContext dc = new StudentsDataContext();
try
{
dc.AddNewStudent(s.FirstName, s.SecondName, s.LastName, s.Faculty, s.Specialty, s.OKS, s.StudentStatus,
s.FacNumber, s.Course, s.Potok, s.Group);
dc.SubmitChanges();
}
catch (Exception)
{
return false;
}
return true;
}
public static Student GetStudentByNumber(string fakNumber)
{
StudentsDataContext dc = new StudentsDataContext();
var queryResult = (from students in dc.GetTable<Student>()
where (students.FacNumber == fakNumber)
select students).ToArray<Student>();
if (queryResult.Count<Student>() > 0)
{
return queryResult[0];
}
else
{
return null;
}
}
private void EnterButton_Click(object sender, RoutedEventArgs e)
{
string login = loginBox.Text;
string password = passwordBox.Password;
using (StudentsDataContext db = new StudentsDataContext())
{
//try
//{
var result = db.GetTable <Users>().Where(x => x.Login == login && x.Password == password).SingleOrDefault();
switch (result.Role)
{
case "Студент ":
var student = db.GetTable <Student>().Where(x => x.Login == login).SingleOrDefault();
PersonalCardWindow window1 = new PersonalCardWindow(student);
window1.Show();
Close();
break;
case "Преподаватель ":
var prepod = db.GetTable <Teacher>().Where(x => x.Login == login).SingleOrDefault();
AssessWindow window2 = new AssessWindow(prepod);
window2.Show();
Close();
break;
case "Администрация ":
break;
}
//}
//catch
//{
// MessageBox.Show("Ошибка авторизации");
//}
}
}
public StudentsController(StudentsDataContext context)
{
_db = context;
}
