private Student_Table mtdGetFees() { Student_Table tuition_search = new Student_Table(); foreach (var users in studentlistfees) { if (user.UserID == users.UserID) { tuition_search = users; } } if (tuition_search.Fee_Status == 1) { tbxFees.Text = " Fees unpaid"; tbxFees.Background = Brushes.Red; } else if (tuition_search.Fee_Status == 2) { tbxFees.Text = "Fees Paid!"; tbxFees.Background = Brushes.LightGreen; } tbxCourseName.Text = tuition_search.Course_ID; return(null); // return tuition_search; }
private Student_Table mtdGetCourses() { Student_Table tuition_search = new Student_Table(); foreach (var users in studentlist) { if (user.UserID == users.UserID) { tuition_search = users; } } tbxCourseID.Text = tuition_search.Course_ID; Course_Table course_search = new Course_Table(); foreach (var users in studentlistcourses) { if (tuition_search.Course_ID == users.Course_ID) { course_search = users; } } tbxCourseName.Text = course_search.Course_Title; tbxClass1.Text = course_search.Class_Detail; tbxClass2.Text = course_search.Class_Detail2; tbxClass3.Text = course_search.Class_Detail3; return(null); // return tuition_search; }
private void btnsearch_Click(object sender, RoutedEventArgs e) { Student_Table userDetails = new Student_Table(); //new instance of student table for searching string searchUser = tbxSearch.Text.Trim(); //removing spaces with trim get user detials if (String.IsNullOrEmpty(tbxSearch.Text.Trim()) || (tbxSearch.Text == "Admin")) { MessageBox.Show("Error Invalid Search Term!", "Search Error", MessageBoxButton.OK, MessageBoxImage.Error); } else { dataGridsearch.DataContext = null; mtdSearchUser(searchUser);//check if details exist in DB using method } }
private Student_Table mtdGetDetails() { Student_Table Details = new Student_Table(); foreach (var users in studentlistDetails) { if (user.UserID == users.UserID) { Details = users; } } tbxStudentID.Text = Details.UserID; tbxForename.Text = Details.Forename; tbxAddress1.Text = Details.Address1; tbxAddress2.Text = Details.Address2; tbxSurname.Text = Details.Surname; tbxContact.Text = Details.Contact.ToString(); return(null); // return tuition_search; }