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();
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
AdmissionStudentIntImplementation a = new AdmissionStudentIntImplementation();
a.setVivaResult(achievedMark.Text, Login.getID(), id.Text);
Admission admission = new Admission();
admission.Show();
this.Close();
}
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";
}
}
}
