public MainWindow() { InitializeComponent(); Home.Content = new Main(); List <MenuBox> menus = new List <MenuBox>() { new MenuBox() { Name = "Students", IconPath = "Images/student.png" }, new MenuBox() { Name = "Trainers", IconPath = "Images/trainer.png" }, new MenuBox() { Name = "Courses", IconPath = "Images/course.png" } }; MenuItemBox.ItemsSource = menus; var context = new TrainingDBContext(); }
private void Assignment_CourseToTrainer(object sender, RoutedEventArgs e) { // Assigning Course to Trainer var db = new TrainingDBContext(); string assignedName = AssignTrainerCombo.SelectedValue.ToString(); string assignedCourse = AssignCourseCombo.SelectedValue.ToString(); int trainerId = 0; var queryTrainer = from trainer in db.Trainers where trainer.FirstName == assignedName select new { TrainerID = trainer.TrainerId }; foreach (var query in queryTrainer) { trainerId = query.TrainerID; } // // UPDATION var queryCourses = from cour in db.Courses where cour.Title == assignedCourse select cour; foreach (var course in queryCourses) { course.TrainerId = trainerId; } db.SaveChanges(); MessageBox.Show("Assigned! Please Refresh"); }
private void AddBtnCourse(object sender, RoutedEventArgs e) { var context = new TrainingDBContext(); if (CodeTextBox.Text == "" || TitleTextBox.Text == "" || DescriptionTextBox.Text == "") { MessageBox.Show("All fields are required"); } else { var courseObj = new Course() { Code = int.Parse(CodeTextBox.Text), Title = TitleTextBox.Text, Description = DescriptionTextBox.Text }; context.Courses.Add(courseObj); context.SaveChanges(); MessageBox.Show("Added: Refresh to see changes"); CodeTextBox.Text = ""; TitleTextBox.Text = ""; DescriptionTextBox.Text = ""; } }
private void UpdateOnClick(object sender, RoutedEventArgs e) { var db = new TrainingDBContext(); var selectedData = (CoursesRecord)ListCourses.SelectedValue; if (selectedData != null) { var courseTitle = selectedData.Title; var courseId = (from cour in db.Courses where cour.Title == courseTitle select cour.Code).ToList(); int courseID = courseId[0]; var queryCourses = from cour in db.Courses where cour.Code == courseID select cour; foreach (var cour in queryCourses) { cour.Title = UpTitle.Text; cour.Description = UpDescription.Text; } db.SaveChanges(); MessageBox.Show("Updated! Refresh to see changes"); } UpTitle.Text = ""; UpCode.Text = ""; UpDescription.Text = ""; }
private void Refresh(object sender, RoutedEventArgs e) { List <String> nameOfTrainers = new List <String>(); List <String> courseList = new List <String>(); var context = new TrainingDBContext(); // Retriving data from database var listOfTrainers = (from trainer in context.Trainers select new TrainerRecord() { FirstName = trainer.FirstName, LastName = trainer.LastName, Designation = trainer.Designation, Department = trainer.Department, Email = trainer.Email, Salary = trainer.Salary, Address = trainer.Address, DateOfBirth = trainer.DateOfBirth, PhotoSrc = trainer.PhotoSrc }).ToList(); // Binding data foreach (var trainer in listOfTrainers) { nameOfTrainers.Add(trainer.FirstName); } ListTrainers.ItemsSource = listOfTrainers; // AssignTrainerCombo.ItemsSource = nameOfTrainers; DeleteTrainerCombo.ItemsSource = nameOfTrainers; // AssignCourseCombo.ItemsSource = courseList; }
public Students() { InitializeComponent(); List <String> nameOfStudents = new List <String>(); List <String> courseList = new List <String>(); var context = new TrainingDBContext(); // Retriving data from database var listOfStudents = (from student in context.Students select new StudentRecords() { FirstName = student.FirstName, LastName = student.LastName, RegNo = student.RegNo, PhoneNo = student.PhoneNo, Email = student.Email, Address = student.Address, DateOfBirth = student.DateOfBirth, PhotoSrc = student.PhotoSrc }).ToList(); // Binding data foreach (var student in listOfStudents) { nameOfStudents.Add(student.FirstName); } var coursesList = (from course in context.Courses select new { CourseTitle = course.Title }).ToList(); foreach (var courses in coursesList) { courseList.Add(courses.CourseTitle); } ListStudents.ItemsSource = listOfStudents; AssignStdCombo.ItemsSource = nameOfStudents; DeleteStdCombo.ItemsSource = nameOfStudents; AssignCourseCombo.ItemsSource = courseList; }
private void OnUnassignedSelectionChange(object sender, SelectionChangedEventArgs e) { // Updating Data Grid var context = new TrainingDBContext(); var selectedCourse = UnassignedCourse.SelectedValue.ToString(); var selectedQuery = context.Courses.Where(cour => cour.Title == selectedCourse).Select(cour => new { cour.Code, cour.Title, cour.Description, cour.TrainerId }).ToList(); DataGridMain.ItemsSource = selectedQuery; }
private void DeleteBtnCLick(object sender, RoutedEventArgs e) { var db = new TrainingDBContext(); var CourseIdDel = 0; // Getting the studentId of selected object var confirmation = MessageBox.Show("Do You Really want to delete? ", "Deletion Confirmation", MessageBoxButton.YesNo); if (confirmation == MessageBoxResult.Yes) { if (DeleteCourseCombo.SelectedItem != null) { var titleFromCombo = DeleteCourseCombo.SelectedValue.ToString(); var getCourseId = from cour in db.Courses where cour.Title == titleFromCombo select new { cour.Code }; foreach (var crId in getCourseId) { CourseIdDel = crId.Code; } var queryStudentCourses = from stdCour in db.StudentCourses where stdCour.CourseId == CourseIdDel select stdCour; foreach (var del in queryStudentCourses) { db.StudentCourses.Remove(del); } db.SaveChanges(); var queryCourses = from course in db.Courses where course.Title == titleFromCombo select course; foreach (var del in queryCourses) { db.Courses.Remove(del); } db.SaveChanges(); MessageBox.Show("Deleted! Refresh list"); DeleteCourseCombo.Text = "Select Record to delete"; } } }
private void DeleteBtn_OnClick(object sender, RoutedEventArgs e) { var db = new TrainingDBContext(); var studentIdDel = 0; // Getting the studentId of selected object var confirmation = MessageBox.Show("Do You Really want to delete? ", "Deletion Confirmation", MessageBoxButton.YesNo); if (confirmation == MessageBoxResult.Yes) { if (DeleteStdCombo.SelectedItem != null) { var firstNameFromCombo = DeleteStdCombo.SelectedValue.ToString(); var getStudentId = from std in db.Students where std.FirstName == firstNameFromCombo select new { std.StudentId }; foreach (var stdId in getStudentId) { studentIdDel = stdId.StudentId; } var queryStudentCourses = from stdCour in db.StudentCourses where stdCour.StudentId == studentIdDel select stdCour; foreach (var del in queryStudentCourses) { db.StudentCourses.Remove(del); } db.SaveChanges(); var queryStudents = from std in db.Students where std.StudentId == studentIdDel select std; foreach (var del in queryStudents) { db.Students.Remove(del); } db.SaveChanges(); MessageBox.Show("Deleted! Refresh list"); DeleteStdCombo.Text = "Select Record to delete"; } } }
public Main() { InitializeComponent(); var context = new TrainingDBContext(); // Reports about no of things in Database var students = context.Students.Select(std => std); noOfStudents = students.Count(); var trainers = context.Trainers.Select(tra => tra); noOfTrainers = trainers.Count(); var courses = context.Courses.Select(cours => cours); noOfCourses = courses.Count(); // UNASSIGNED COURSES var unassignedCourses = context.Courses.Where(cour => cour.TrainerId == null).Select(cour => new { CourseName = cour.Title }); // Unassigned Courses in combobox foreach (var unassignedCourse in unassignedCourses) { unassigned.Add(unassignedCourse.CourseName); } UnassignedCourse.ItemsSource = unassigned; this.DataContext = this; List <String> studentNames = new List <string>(); // STUDENTS TAKING NO COURSES var result = (from student in context.Students where ! (from studentcourse in context.StudentCourses select new { studentcourse.StudentId }).Contains(new { StudentId = student.StudentId }) select new { student.FirstName }); foreach (var query in result) { studentNames.Add(query.FirstName); } StudentCombo.ItemsSource = studentNames; }
public Courses() { InitializeComponent(); List <String> nameOfCourses = new List <String>(); List <String> assignCourses = new List <String>(); List <String> trainerNames = new List <String>(); var context = new TrainingDBContext(); // Retriving data from database var listOfCourses = (from course in context.Courses select new CoursesRecord() { Code = course.Code, Title = course.Title, Description = course.Description, TrainerName = course.Trainer.FirstName }).ToList(); var trainerList = (from tran in context.Trainers select new { tran.FirstName }); foreach (var trainer in trainerList) { trainerNames.Add(trainer.FirstName); } var assignedCourses = (from cour in context.Courses where cour.TrainerId == null select new { cour.Title }); foreach (var assignedCourse in assignedCourses) { assignCourses.Add(assignedCourse.Title); } // Binding data foreach (var course in listOfCourses) { nameOfCourses.Add(course.Title); } ListCourses.ItemsSource = listOfCourses; DeleteCourseCombo.ItemsSource = nameOfCourses; AssignCourseCombo.ItemsSource = assignCourses; AssignTrainerCombo.ItemsSource = trainerNames; }
private void Update_OnClick(object sender, RoutedEventArgs e) { var db = new TrainingDBContext(); var selectedData = (TrainerRecord)ListTrainers.SelectedValue; if (selectedData != null) { var trainerName = selectedData.FirstName; var tranId = (from trainer in db.Trainers where trainer.FirstName == trainerName select trainer.TrainerId).ToList(); int trainerID = tranId[0]; var queryTrainers = from trainer in db.Trainers where trainer.TrainerId == trainerID select trainer; foreach (var tran in queryTrainers) { tran.FirstName = UpFirstName.Text; tran.LastName = UpLastName.Text; tran.Designation = UpDesignation.Text; tran.Email = UpEmail.Text; tran.Address = UpAddress.Text; tran.Department = UpDepartment.Text; tran.Salary = UpSalary.Text; tran.DateOfBirth = UpDateOfBirth.Text; tran.PhotoSrc = PhotoUpdate.Source.ToString(); } MessageBox.Show(queryTrainers.ToString()); db.SaveChanges(); MessageBox.Show("Updated! Refresh to see changes"); } UpFirstName.Text = ""; UpLastName.Text = ""; UpAddress.Text = ""; UpDateOfBirth.Text = ""; UpEmail.Text = ""; UpDepartment.Text = ""; UpDesignation.Text = ""; UpSalary.Text = ""; PhotoUpdate.Source = null; }
private void Update_OnClick(object sender, RoutedEventArgs e) { var db = new TrainingDBContext(); var selectedData = (StudentRecords)ListStudents.SelectedValue; if (selectedData != null) { var stdName = selectedData.FirstName; var stdId = (from std in db.Students where std.FirstName == stdName select std.StudentId).ToList(); int studentId = stdId[0]; var queryStudents = from std in db.Students where std.StudentId == studentId select std; foreach (var stds in queryStudents) { stds.FirstName = UpFirstName.Text; stds.LastName = UpLastName.Text; stds.RegNo = UpRegNo.Text; stds.Email = UpEmail.Text; stds.Address = UpAddress.Text; stds.PhoneNo = UpPhoneNo.Text; stds.DateOfBirth = UpDateOfBirth.Text; stds.PhotoSrc = PhotoUpdate.Source.ToString(); } MessageBox.Show(queryStudents.ToString()); db.SaveChanges(); MessageBox.Show("Updated! Refresh to see changes"); } UpFirstName.Text = ""; UpLastName.Text = ""; UpAddress.Text = ""; UpDateOfBirth.Text = ""; UpEmail.Text = ""; UpPhoneNo.Text = ""; UpRegNo.Text = ""; PhotoUpdate.Source = null; }
public Trainers() { InitializeComponent(); List <String> nameOfTrainers = new List <String>(); List <String> courseList = new List <String>(); var context = new TrainingDBContext(); // Retriving data from database var listOfTrainers = (from trainer in context.Trainers select new TrainerRecord() { FirstName = trainer.FirstName, LastName = trainer.LastName, Designation = trainer.Designation, Department = trainer.Department, Salary = trainer.Salary, Email = trainer.Email, Address = trainer.Address, DateOfBirth = trainer.DateOfBirth, PhotoSrc = trainer.PhotoSrc }).ToList(); // Binding data foreach (var student in listOfTrainers) { nameOfTrainers.Add(student.FirstName); } var coursesList = (from course in context.Courses where course.TrainerId == null select new { CourseTitle = course.Title }).ToList(); foreach (var courses in coursesList) { courseList.Add(courses.CourseTitle); } ListTrainers.ItemsSource = listOfTrainers; // AssignTrainerCombo.ItemsSource = nameOfTrainers; DeleteTrainerCombo.ItemsSource = nameOfTrainers; // AssignCourseCombo.ItemsSource = courseList; }
private void StudentCombo_OnSelectionChanged(object sender, SelectionChangedEventArgs e) { var db = new TrainingDBContext(); var selectedStudent = StudentCombo.SelectedValue.ToString(); var selectedQuery = (from std in db.Students where std.FirstName == selectedStudent select new StudentRecords() { FirstName = std.FirstName, LastName = std.LastName, RegNo = std.RegNo, PhoneNo = std.PhoneNo, Email = std.Email, Address = std.Address, DateOfBirth = std.DateOfBirth, PhotoSrc = std.PhotoSrc }).ToList(); DataGridMain.ItemsSource = selectedQuery; }
private void Assignment_CourseToStd(object sender, RoutedEventArgs e) { // Assigning Course to student var context = new TrainingDBContext(); string assignedName = AssignStdCombo.SelectedValue.ToString(); string assignCourseTitle = AssignCourseCombo.SelectedValue.ToString(); int studentId = 0; int courseCode = 0; var queryStd = from std in context.Students where std.FirstName == assignedName select new { StudentID = std.StudentId }; var queryCourse = from cour in context.Courses where cour.Title == assignCourseTitle select new { CourseCode = cour.Code }; foreach (var query in queryStd) { studentId = query.StudentID; } foreach (var query in queryCourse) { courseCode = query.CourseCode; } StudentCourse iStudentCourses = new StudentCourse { StudentId = studentId, CourseId = courseCode }; context.StudentCourses.Add(iStudentCourses); context.SaveChanges(); MessageBox.Show("Assigned"); AssignStdCombo.Text = ""; AssignCourseCombo.Text = ""; }
private void BtnAdd_OnClick(object sender, RoutedEventArgs e) { var context = new TrainingDBContext(); if (FirstNameTextBox.Text == "" || LastNameTextBox.Text == "" || AddressTextBox.Text == "" || DateOfBirthPicker.Text == "" || EmailTextBox.Text == "" || DesignationTextBox.Text == "" || DepartmentTextBox.Text == "" || DepartmentTextBox.Text == "" || Photo.Source == null) { MessageBox.Show("All fields are required"); } else { var trainerObj = new Trainer() { FirstName = FirstNameTextBox.Text, LastName = LastNameTextBox.Text, Address = AddressTextBox.Text, DateOfBirth = DateOfBirthPicker.Text, Email = EmailTextBox.Text, Designation = DesignationTextBox.Text, Department = DepartmentTextBox.Text, Salary = SalaryTextBox.Text, PhotoSrc = Photo.Source.ToString() }; context.Trainers.Add(trainerObj); context.SaveChanges(); MessageBox.Show("Added: Refresh to see changes"); FirstNameTextBox.Text = ""; LastNameTextBox.Text = ""; AddressTextBox.Text = ""; DateOfBirthPicker.Text = ""; EmailTextBox.Text = ""; DesignationTextBox.Text = ""; DepartmentTextBox.Text = ""; SalaryTextBox.Text = ""; Photo.Source = null; } }
private void BtnAdd_OnClick(object sender, RoutedEventArgs e) { var context = new TrainingDBContext(); if (FirstNameTextBox.Text == "" || LastNameTextBox.Text == "" || AddressTextBox.Text == "" || DateOfBirthPicker.Text == "" || EmailTextBox.Text == "" || PhoneNumberTextBox.Text == "" || RegTextBox.Text == "" || Photo.Source == null) { MessageBox.Show("All fields are required"); } else { var studentObj = new Student() { FirstName = FirstNameTextBox.Text, LastName = LastNameTextBox.Text, Address = AddressTextBox.Text, DateOfBirth = DateOfBirthPicker.Text, Email = EmailTextBox.Text, PhoneNo = PhoneNumberTextBox.Text, RegNo = RegTextBox.Text, PhotoSrc = Photo.Source.ToString() }; context.Students.Add(studentObj); context.SaveChanges(); MessageBox.Show("Added: Refresh to see changes"); FirstNameTextBox.Text = ""; LastNameTextBox.Text = ""; AddressTextBox.Text = ""; DateOfBirthPicker.Text = ""; EmailTextBox.Text = ""; PhoneNumberTextBox.Text = ""; RegTextBox.Text = ""; Photo.Source = null; } }