protected void btnDelete_Click(object sender, EventArgs e) { Int32 empId = Convert.ToInt32(btnSave.CommandArgument); if (empId != 0) { LearnEFEntities db = new LearnEFEntities(); Employee objEmp = new Employee() { EmpId = empId }; db.Employees.Attach(objEmp); db.Employees.DeleteObject(objEmp); db.SaveChanges(); //reset the form and grid ClearEmpForm(); PopulateEmpList(); } }
protected void btnSave_Click(object sender, EventArgs e) { Int32 empId = Convert.ToInt32(btnSave.CommandArgument); if (empId == 0) { //INSERT LearnEFEntities db = new LearnEFEntities(); Employee objEmp = new Employee(); objEmp.HREmpId = txtHREmpId.Text; objEmp.FirstName = txtFirstName.Text; objEmp.LastName = txtLastName.Text; objEmp.Address = txtAddress.Text; objEmp.City = txtCity.Text; db.Employees.AddObject(objEmp); db.SaveChanges(); } else { //UPDATE LearnEFEntities db = new LearnEFEntities(); var empQuery = from emp in db.Employees where emp.EmpId == empId select emp; Employee objEmp = empQuery.Single(); objEmp.HREmpId = txtHREmpId.Text; objEmp.FirstName = txtFirstName.Text; objEmp.LastName = txtLastName.Text; objEmp.Address = txtAddress.Text; objEmp.City = txtCity.Text; db.SaveChanges(); } ClearEmpForm(); PopulateEmpList(); }
/// <summary> /// 用于向 Employees EntitySet 添加新对象的方法,已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。 /// </summary> public void AddToEmployees(Employee employee) { base.AddObject("Employees", employee); }
/// <summary> /// 创建新的 Employee 对象。 /// </summary> /// <param name="empId">EmpId 属性的初始值。</param> public static Employee CreateEmployee(global::System.Int32 empId) { Employee employee = new Employee(); employee.EmpId = empId; return employee; }