protected void btnAdd_Click(object sender, EventArgs e) { try { using (DefaultConnectionEF conn = new DefaultConnectionEF()) { //Get the values Int32 StudentID = Convert.ToInt32(Request.QueryString["StudentID"]); Int32 CourseID = Convert.ToInt32(ddlCourse.SelectedValue); //Instantiate the enrollment object Enrollment objE = new Enrollment(); //Populate, save, and refresh objE.StudentID = StudentID; objE.CourseID = CourseID; conn.Enrollments.Add(objE); conn.SaveChanges(); GetStudent(); } } catch (System.IO.IOException e5) { Server.Transfer("/error.aspx", true); } }
protected void grdStudents_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { //connect using (DefaultConnectionEF conn = new DefaultConnectionEF()) { //get the Department Id Int32 StudentID = Convert.ToInt32(grdStudents.DataKeys[e.RowIndex].Values["StudentID"]); var s = (from stud in conn.Students where stud.StudentID == StudentID select stud).FirstOrDefault(); //process the delete conn.Students.Remove(s); conn.SaveChanges(); //update the grid GetStudents(); } } catch (System.IO.IOException e2) { Server.Transfer("/error.aspx", true); } }
protected void btnSave_Click(object sender, EventArgs e) { try { //connect using (DefaultConnectionEF conn = new DefaultConnectionEF()) { //instantiate a new deparment object in memory Student s = new Student(); //decide if updating and then re-query the updated Students if (Request.QueryString.Count > 0) { Int32 StudentID = Convert.ToInt32(Request.QueryString["StudentID"]); s = (from stud in conn.Students where stud.StudentID == StudentID select stud).FirstOrDefault(); } //fill in the values s.FirstMidName = txtFirstMidName.Text; s.LastName = txtLastName.Text; s.EnrollmentDate = Convert.ToDateTime(txtEnrollmentDate.Text); //Only add a new record if it's not updating an existing one if (Request.QueryString.Count == 0) { conn.Students.Add(s); } conn.SaveChanges(); //redirect to the Students page Response.Redirect("students.aspx"); } } catch (System.IO.IOException e2) { Server.Transfer("/error.aspx", true); } }
protected void btnSave_Click(object sender, EventArgs e) { try { //connect using (DefaultConnectionEF conn = new DefaultConnectionEF()) { //instantiate a new deparment object in memory Department d = new Department(); //decide if updating and then re-query the updated departments if (Request.QueryString.Count > 0) { Int32 DepartmentID = Convert.ToInt32(Request.QueryString["DepartmentID"]); d = (from dep in conn.Departments where dep.DepartmentID == DepartmentID select dep).FirstOrDefault(); } //fill in the values d.Name = txtName.Text; d.Budget = Convert.ToDecimal(txtBudget.Text); //Only add a new record if it's not updating an existing one if (Request.QueryString.Count == 0) { conn.Departments.Add(d); } conn.SaveChanges(); //redirect to the departments page Response.Redirect("departments.aspx"); } } catch (System.IO.IOException e2) { Server.Transfer("/error.aspx", true); } }
protected void btnSave_Click(object sender, EventArgs e) { try { //connect using (DefaultConnectionEF conn = new DefaultConnectionEF()) { Courses objC = new Courses(); if (!String.IsNullOrEmpty(Request.QueryString["CourseID"])) { Int32 CourseID = Convert.ToInt32(Request.QueryString["CourseID"]); objC = (from c in conn.Courses where c.CourseID == CourseID select c).FirstOrDefault(); } //Populate the course from the input form objC.Title = txtTitle.Text; objC.Credits = Convert.ToInt32(txtCredits.Text); objC.DepartmentID = Convert.ToInt32(ddlDepartments.SelectedValue); if (String.IsNullOrEmpty(Request.QueryString["CourseID"])) { //add conn.Courses.Add(objC); } conn.SaveChanges(); Response.Redirect("courses.aspx"); } } catch (System.IO.IOException e3) { Server.Transfer("/error.aspx", true); } }
protected void grdCourses_RowDeleting(object sender, GridViewDeleteEventArgs e) { //Get the desired enrollment ID Int32 EnrollmentID = Convert.ToInt32(grdCourses.DataKeys[e.RowIndex].Values["EnrollmentID"]); try { using (DefaultConnectionEF conn = new DefaultConnectionEF()) { Enrollment objE = (from en in conn.Enrollments where en.EnrollmentID == EnrollmentID select en).FirstOrDefault(); conn.Enrollments.Remove(objE); conn.SaveChanges(); GetStudent(); } } catch (System.IO.IOException e3) { Server.Transfer("/error.aspx", true); } }