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"); }