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