protected void btnGoCarrollId_Click(object sender, EventArgs e) { int stuID; int.TryParse(txtCarrollIdSelect.Text, out stuID); if (stuID != 0) { lblLastNameError.Visible = false; App_Data.Student student = StudentDAO.getStudentByID(stuID); if (student != null) { AssignInformationCarrollId(student); } else { lblLastNameError.Visible = true; lblLastNameError.Text = "No Students With This Carroll ID"; } } else { lblLastNameError.Visible = true; lblLastNameError.Text = "Please Enter a Valid Carroll ID"; } }
protected void grdLastNameStudents_SelectedIndexChanged(object sender, EventArgs e) { int stuID; int.TryParse(grdLastNameStudents.Rows[grdLastNameStudents.SelectedIndex].Cells[2].Text, out stuID); App_Data.Student student = StudentDAO.getStudentByID(stuID); if (student != null) { AssignInformationCarrollId(student); } }
/// It only returns first name, last name and carroll id public List <StudentOrganisationApp.App_Data.Student> getStudentByLastName(string lastname) { List <StudentOrganisationApp.App_Data.Student> students = new List <App_Data.Student>(); var stud = dataContext.sp_GetStudentByLastName(lastname); foreach (var s in stud) { StudentOrganisationApp.App_Data.Student student = new App_Data.Student(); student.FirstName = s.FirstName; student.LastName = s.LastName; student.Carroll_ID = s.Carroll_ID; students.Add(student); } return(students); }
public StudentOrganisationApp.App_Data.Student getStudentByID(int stuID) { StudentOrganisationApp.App_Data.Student student = null; try { var stud = dataContext.sp_GetStudentByCarrollID(stuID).First(); student = new App_Data.Student(); student.FirstName = stud.FirstName; student.LastName = stud.LastName; student.ClassOf = stud.ClassOf; student.Email = stud.Email; student.PreferredPhone = stud.PreferredPhone; student.Active = stud.Active; student.Gender = stud.Gender; student.Carroll_ID = stud.Carroll_ID; student.GPABoard = stud.GPABoard; student.GPAOrg = stud.GPAOrg; student.Major = stud.Major; student.Major2 = stud.Major2; student.CertifiedDriver = stud.CertifiedDriver; student.ApprovedDriver = stud.ApprovedDriver; student.GreekGPA = stud.GreekGPA; student.Ferpa = stud.Ferpa; student.Student_ID = stud.Student_ID; student.OnCampus = stud.OnCampus; student.Race = stud.Race; student.International = stud.International; } catch (Exception e) { } return(student); }
public void AssignInformationCarrollId(App_Data.Student studentForEdit) { try { pnlEditing.Visible = true; pnlOrgMember.Visible = true; pnlSearchStudent.Visible = false; txtLastNameSelect.Text = string.Empty; txtCarrollIdSelect.Text = string.Empty; lblNameStudent.Text = studentForEdit.FirstName + " " + studentForEdit.LastName; gridview_OrgMember.DataSource = StudentDAO.getHistoricalOrgsByID(Convert.ToInt32(studentForEdit.Carroll_ID)); gridview_OrgMember.DataBind(); txtStudentEmail.Text = studentForEdit.Email; txtPrefPhoneNo.Text = studentForEdit.PreferredPhone; txtStudentFirstName.Text = studentForEdit.FirstName; txtStudentLastName.Text = studentForEdit.LastName; txtCarrollID.Text = studentForEdit.Carroll_ID.ToString(); txtGradClass.Text = studentForEdit.ClassOf.ToString(); txtMajor.Text = studentForEdit.Major; txtMajor2.Text = studentForEdit.Major2; txtRace.Text = studentForEdit.Race; if (studentForEdit.OnCampus.ToString().Equals("Y")) { cbOnCampus.Checked = true; } else { cbOnCampus.Checked = false; } if (studentForEdit.International.ToString().Equals("Y")) { cbIntl.Checked = true; } else { cbIntl.Checked = false; } lblStuID.Text = studentForEdit.Student_ID.ToString(); if (studentForEdit.GreekGPA == true) { chkGreekGPA.Checked = true; } else { chkGreekGPA.Checked = false; } if (studentForEdit.Gender == true) { rblGender.SelectedIndex = 0; } else { rblGender.SelectedIndex = 1; } if (studentForEdit.GPABoard == true) { chklGrades.Items[0].Selected = true; } if (studentForEdit.GPAOrg == true) { chklGrades.Items[1].Selected = true; } if (studentForEdit.Active == true) { rblStatus.SelectedIndex = 0; } else { rblStatus.SelectedIndex = 1; } if (studentForEdit.CertifiedDriver == true) { chklDrvingPermission.Items[0].Selected = true; } if (studentForEdit.ApprovedDriver == true) { chklDrvingPermission.Items[1].Selected = true; } } catch (Exception) { lblMessage.Text = "Unable to retrieve the Student data!!"; pnlEditing.Visible = false; pnlSearchStudent.Visible = false; txtLastNameSelect.Text = string.Empty; txtCarrollIdSelect.Text = string.Empty; } }