protected void Page_Load(object sender, EventArgs e) { if (IsPostBack == false) { // check the url for an id so we know we are adding or editing if (!string.IsNullOrEmpty(Request.QueryString["DepartmentID"])) { // get id from url Int32 DepartmentID = Convert.ToInt32(Request.QueryString["departmentID"]); // connect var conn = new contosoEntities1(); // lookup the selected department var objDep = (from d in conn.Departments where d.DepartmentID == DepartmentID select d).FirstOrDefault(); // populate the form txtDepartment.Text = objDep.Name; txtbudget.Text = objDep.Budget.ToString(); } } }
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 Page_Load(object sender, EventArgs e) { if (IsPostBack == false) { // check the url for an id so we know we are adding or editing if (!string.IsNullOrEmpty(Request.QueryString["StudentID"])) { // get id from url Int32 StudentID = Convert.ToInt32(Request.QueryString["StudentID"]); // connect var conn = new contosoEntities1(); // lookup the selected student var objStu = (from d in conn.Students where d.StudentID == StudentID select d).FirstOrDefault(); // populate the form txtLast.Text = objStu.LastName; txtFirst.Text = objStu.FirstName; txtDate.Text = objStu.EnrollmentDate.ToString(); } } }
protected void getStudents() { //connect to db var conn = new contosoEntities1(); //run the query using LINQ var Students = from d in conn.Students select d; //display query result in gridview grdStudents.DataSource = Students.ToList(); grdStudents.DataBind(); }
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(); }