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