private void button_Click_2(object sender, RoutedEventArgs e) { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); AdmissionStudentIntImplementation a = new AdmissionStudentIntImplementation(); DAL.Admission_Student st = a.getAdmissionStudent(id.Text); if (st == null) { MessageBox.Show("Student Not Found"); } else { Admission_Exam_Result stResult = db.Admission_Exam_Results.FirstOrDefault(ee => ee.Admission_Student_ID.Equals(st.Admission_Student_ID)); fullName.Text = st.Full_Name; admissionSession.Text = st.Admission_Session; group.Text = st.Group; Total_mark.Text = "100"; if (stResult == null) { achievedMark.Text = ""; } else { achievedMark.Text = stResult.Viva_Exam_Mark; } } }
private void Button_DONE(object sender, RoutedEventArgs e) { AdmissionStudentIntImplementation a = new AdmissionStudentIntImplementation(); DAL.Admission_Student std = new DAL.Admission_Student(); std.First_Name = fistName.Text; std.Last_Name = lastName.Text; std.Full_Name = fullName.Text; std.Fathers_Name = fathersName.Text; std.Mothers_Name = mothersName.Text; std.Gender = gender.Text; std.Blood_Group = bloodGroup.Text; std.DOB = DateTime.Parse(dobDatePicker.ToString()); std.Religion = religionList.Items.GetItemAt(0).ToString(); std.Admission_Session = admissionSession.Text; std.Group = group.Text; std.Mobile = guardianNumber.Text; std.Current_School = currentSchool.Text; std.Current_Grade = currentGrade.Text; std.Interested_Grade = registeredGrade.Text; std.Address = address.Text; std.Country = country.Text; a.addAdmissionStudent(std); Admission admission = new Admission(); admission.Show(); this.Close(); }
public ECRoom101() { InitializeComponent(); DataClassesLinqDataContext db = new DataClassesLinqDataContext(DataAccessClassLinq.connectionStringLinq); DAL.Admission_Student admissionstudent = new DAL.Admission_Student(); DAL.Teacher teach = new DAL.Teacher(); List <string> objList = new List <string>(); List <string> objList2 = new List <string>(); var a = from e in db.Admission_Students select e; var b = from e in db.Teachers select e; foreach (DAL.Admission_Student st in a) { objList.Add(st.Admission_Student_ID); } foreach (DAL.Teacher t in b) { objList2.Add(t.Full_Name); } _1.ItemsSource = objList; _2.ItemsSource = objList; _3.ItemsSource = objList; _4.ItemsSource = objList; _5.ItemsSource = objList; _6.ItemsSource = objList; _7.ItemsSource = objList; _8.ItemsSource = objList; _9.ItemsSource = objList; _10.ItemsSource = objList; _11.ItemsSource = objList; _12.ItemsSource = objList; _13.ItemsSource = objList; _14.ItemsSource = objList; _15.ItemsSource = objList; _16.ItemsSource = objList; _17.ItemsSource = objList; _18.ItemsSource = objList; _19.ItemsSource = objList; _20.ItemsSource = objList; _21.ItemsSource = objList; _22.ItemsSource = objList; _23.ItemsSource = objList; _24.ItemsSource = objList; Invi1.ItemsSource = objList2; Invi2.ItemsSource = objList2; // _1.Content = objList.First(); }
private async void button_Click_2(object sender, RoutedEventArgs e) { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); StudentIntImplementation a = new StudentIntImplementation(); AdmissionStudentIntImplementation b = new AdmissionStudentIntImplementation(); DAL.Student st = a.getStudent(id.Text); DAL.Admission_Student admissionSt = null; try { admissionSt = db.Admission_Students.FirstOrDefault(ee => ee.Admission_Student_ID.Equals(st.Admissin_Student_ID)); } catch { //do nothing } if (st == null) { await this.ShowMessageAsync("Error", "Student not found."); } else { DAL.Student_Regular_Fee stReg = db.Student_Regular_Fees.FirstOrDefault(ee => ee.Student_ID.Equals(st.Student_ID)); fullName.Text = admissionSt.Full_Name; grade.Text = admissionSt.Interested_Grade; group.Text = admissionSt.Group; /*if (stReg == null) * mo.Text = ""; * else * mark.Text = stResult.Viva_Exam_Mark;*/ } }
private async void search_Button_Click(object sender, RoutedEventArgs e) { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); AdmissionStudentIntImplementation a = new AdmissionStudentIntImplementation(); StudentIntImplementation b = new StudentIntImplementation(); DAL.Admission_Student admissionStudent = a.getAdmissionStudent(id.Text); var checkStudent = from f in db.Students where f.Admissin_Student_ID.Equals(admissionStudent.Admission_Student_ID) select f; bool checkStd = false; foreach (DAL.Student std in checkStudent) { checkStd = true; } if (admissionStudent == null) { fullName.Clear(); addmissionSession.Clear(); group.Clear(); interestedGrade.Clear(); gender.Clear(); group.Clear(); eligibleMarks.Content = "Written : Viva : "; teacherIDs.Content = "Written : Viva : "; written_mark.Clear(); vivaMark.Clear(); Total.Clear(); Eligibility.Content = "Unknown"; MessageBox.Show("Student Not Found"); } else if (checkStd.Equals(true)) { fullName.Clear(); addmissionSession.Clear(); group.Clear(); interestedGrade.Clear(); gender.Clear(); group.Clear(); eligibleMarks.Content = "Written : Viva : "; teacherIDs.Content = "Written : Viva : "; written_mark.Clear(); vivaMark.Clear(); Total.Clear(); Eligibility.Content = "Unknown"; await this.ShowMessageAsync("Error", "Student Already Registered"); } else { Admission_Exam_Result stResult = db.Admission_Exam_Results.FirstOrDefault(ee => ee.Admission_Student_ID.Equals(admissionStudent.Admission_Student_ID)); fullName.Text = admissionStudent.Full_Name; addmissionSession.Text = admissionStudent.Admission_Session; group.Text = admissionStudent.Group; interestedGrade.Text = admissionStudent.Interested_Grade; gender.Text = admissionStudent.Gender; group.Text = admissionStudent.Group; eligibleMarks.Content = "Written : " + stResult.Writtern_Exam_Mark + " Viva : " + stResult.Viva_Exam_Mark; teacherIDs.Content = "Written : " + stResult.Written_Examiner_ID + " Viva : " + stResult.Viva_Examiner_ID; written_mark.Text = stResult.Writtern_Exam_Mark; vivaMark.Text = stResult.Viva_Exam_Mark; double total = Double.Parse(stResult.Writtern_Exam_Mark) + Double.Parse(stResult.Viva_Exam_Mark); Total.Text = total.ToString(); BusinessRules r = new BusinessRules(); bool test = r.checkEligibility(stResult.Writtern_Exam_Mark, stResult.Viva_Exam_Mark); if (test == true) { Eligibility.Content = "Yes"; Add_Student.IsEnabled = true; } else { Eligibility.Content = "No"; } } }
private void searchButton_Click(object sender, RoutedEventArgs e) { DataClassesLinqDataContext db = new DataClassesLinqDataContext (DataAccessClassLinq.connectionStringLinq); AdmissionStudentIntImplementation a = new AdmissionStudentIntImplementation(); DAL.Admission_Student st = a.getAdmissionStudent(id.Text); if (st == null) { fullName.Clear(); addmissionSession.Clear(); group.Clear(); interestedGrade.Clear(); gender.Clear(); group.Clear(); eligibleMarks.Content = "Written : Viva : "; teacherIDs.Content = "Written : Viva : "; written_mark.Clear(); vivaMark.Clear(); Total.Clear(); Eligibility.Content = "Unknown"; MessageBox.Show("Student Not Found"); } else { Admission_Exam_Result stResult = db.Admission_Exam_Results.FirstOrDefault(ee => ee.Admission_Student_ID.Equals(st.Admission_Student_ID)); fullName.Text = st.Full_Name; addmissionSession.Text = st.Admission_Session; group.Text = st.Group; interestedGrade.Text = st.Interested_Grade; gender.Text = st.Gender; group.Text = st.Group; if (stResult != null) { eligibleMarks.Content = "Written : " + stResult.Writtern_Exam_Mark + " Viva : " + stResult.Viva_Exam_Mark; teacherIDs.Content = "Written : " + stResult.Written_Examiner_ID + " Viva : " + stResult.Viva_Examiner_ID; } else { eligibleMarks.Content = "Written : " + 0 + " Viva : " + 0; teacherIDs.Content = "Written : " + 0 + " Viva : " + 0; } written_mark.Text = stResult.Writtern_Exam_Mark; vivaMark.Text = stResult.Viva_Exam_Mark; double total = Double.Parse(stResult.Writtern_Exam_Mark) + Double.Parse(stResult.Viva_Exam_Mark); Total.Text = total.ToString(); BusinessRules r = new BusinessRules(); bool test = r.checkEligibility(stResult.Writtern_Exam_Mark, stResult.Viva_Exam_Mark); if (test == true) { Eligibility.Content = "Yes"; } else { Eligibility.Content = "No"; } } }