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