protected void grdDepartments_RowDeleting(object sender, GridViewDeleteEventArgs e) { // function to delete th edepartment from the gridview // 1. determine which row in the grid the user clicked Int32 gridIndex = e.RowIndex; // 2. find the department id value in the selected row Int32 DepartmentID = Convert.ToInt32(grdDepartments.DataKeys[gridIndex].Value); // 3. connect to the db var conn = new contosoEntities1(); // 4. delete the department /* var objDep = (from d in conn.Departments * where d.DepartmentID == DepartmentID * select d).First();*/ Department d = new Department(); d.DepartmentID = DepartmentID; conn.Departments.Attach(d); conn.Departments.Remove(d); conn.SaveChanges(); // 5. refresh the gridview getDepartments(); }
protected void saveStudent_Click(object sender, EventArgs e) { //check if we have an id to decide if we're adding or editing Int32 StudentID = 0; if (!string.IsNullOrEmpty(Request.QueryString["StudentID"])) { StudentID = Convert.ToInt32(Request.QueryString["StudentID"]); } //connect to db var conn = new contosoEntities1(); //use the Student class to create the new student object Student d = new Student(); //fill the properties of the new student object d.LastName = txtLast.Text; d.FirstName = txtFirst.Text; d.EnrollmentDate = Convert.ToDateTime(txtDate.Text); //save the new object from database if (StudentID == 0) { conn.Students.Add(d); } else { d.StudentID = StudentID; conn.Students.Attach(d); conn.Entry(d).State = System.Data.Entity.EntityState.Modified; }; conn.SaveChanges(); //redirect to student page Response.Redirect("students.aspx"); }
protected void Button1_Click(object sender, EventArgs e) { //check if we have an id to decide if we're adding or editing Int32 DepartmentID = 0; if (!string.IsNullOrEmpty(Request.QueryString["DepartmentID"])) { DepartmentID = Convert.ToInt32(Request.QueryString["departmentID"]); } //connect to db var conn = new contosoEntities1(); //use teh depart ment class to create the new department object Department d = new Department(); //fill the properties of the new department object d.Name = txtDepartment.Text; d.Budget = Convert.ToDecimal(txtbudget.Text); //save the new object from database if (DepartmentID == 0) { conn.Departments.Add(d); } else { d.DepartmentID = DepartmentID; conn.Departments.Attach(d); conn.Entry(d).State = System.Data.Entity.EntityState.Modified; }; conn.SaveChanges(); //redirect to department page Response.Redirect("departments.aspx"); }
protected void grdStudents_RowDeleting(object sender, GridViewDeleteEventArgs e) { // function to delete the student from the gridview // 1. determine which row in the grid the user clicked Int32 gridIndex = e.RowIndex; // 2. find the student id value in the selected row Int32 StudentID = Convert.ToInt32(grdStudents.DataKeys[gridIndex].Value); // 3. connect to the db var conn = new contosoEntities1(); Student d = new Student(); d.StudentID = StudentID; conn.Students.Attach(d); conn.Students.Remove(d); conn.SaveChanges(); // 5. refresh the gridview getStudents(); }