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