protected void EmployeeGrid_RowUpdating(object sender, GridViewUpdateEventArgs e) { using (HREntities hr = new HREntities()) { GridViewRow row = EmployeeGrid.Rows[e.RowIndex]; TextBox textmployeeId = row.Cells[1].Controls[0] as TextBox; int employeeId = int.Parse(textmployeeId.Text); TextBox textFirstName = row.Cells[2].Controls[0] as TextBox; string firstName = textFirstName.Text; TextBox textLastName = row.Cells[3].Controls[0] as TextBox; string lastName = textLastName.Text; TextBox textEmail = row.Cells[4].Controls[0] as TextBox; string email = textEmail.Text; COPY_EMP employee = new COPY_EMP { EMPLOYEE_ID = employeeId, FIRST_NAME = firstName, LAST_NAME = lastName, EMAIL = email }; hr.Entry(employee).State = System.Data.Entity.EntityState.Modified; hr.SaveChanges(); } EmployeeGrid.EditIndex = -1; UpdateDataGrid(); }
protected void btnAdd_Click(object sender, EventArgs e) { if (IsValid) { using (HREntities hr = new HREntities()) { int employeeId = int.Parse(txtEmployeeId.Text); string firstName = txtFirstName.Text; string lastName = txtLastName.Text; string email = txtEmail.Text; COPY_EMP employee = new COPY_EMP { EMPLOYEE_ID = employeeId, FIRST_NAME = firstName, LAST_NAME = lastName, EMAIL = email }; hr.COPY_EMP.Add(employee); hr.SaveChanges(); } UpdateDataGrid(); } }
public ActionResult DeleteEmployee(int id) { using (HREntities hr = new HREntities()) { COPY_EMP employee = hr.COPY_EMP.Find(id); hr.COPY_EMP.Remove(employee); hr.SaveChanges(); return(Redirect("~/employees")); } }
protected void EmployeeGrid_RowDeleting(object sender, GridViewDeleteEventArgs e) { using (HREntities hr = new HREntities()) { GridViewRow row = EmployeeGrid.Rows[e.RowIndex]; int employeeId = int.Parse(row.Cells[1].Text); COPY_EMP emp = hr.COPY_EMP.Find(employeeId); hr.COPY_EMP.Remove(emp); hr.SaveChanges(); } UpdateDataGrid(); }
public ActionResult AddEmployee(Employee employee) { using (HREntities hr = new HREntities()) { COPY_EMP addedEmp = new COPY_EMP { EMPLOYEE_ID = employee.EmployeeId, FIRST_NAME = employee.FirstName, LAST_NAME = employee.LastName }; hr.COPY_EMP.Add(addedEmp); hr.SaveChanges(); return(Redirect("~/employees")); } }
public ActionResult UpdateEmployee(Employee edittedEmployee) { using (HREntities hr = new HREntities()) { COPY_EMP addedEmp = new COPY_EMP { EMPLOYEE_ID = edittedEmployee.EmployeeId, FIRST_NAME = edittedEmployee.FirstName, LAST_NAME = edittedEmployee.LastName }; hr.Entry(addedEmp).State = System.Data.Entity.EntityState.Modified; hr.SaveChanges(); return(Redirect("~/employees")); } }
public ActionResult GetEmployee(int id) { using (HREntities hr = new HREntities()) { // Cara Kedua COPY_EMP empModel = hr.COPY_EMP.Find(id); Employee employee = new Employee { EmployeeId = (int)empModel.EMPLOYEE_ID, FirstName = empModel.FIRST_NAME, LastName = empModel.LAST_NAME, }; return(View("COPY_EMP", employee)); } }
public ActionResult UpdateEmployee(int id, COPY_EMP employee) { using (HREntities hr = new HREntities()) { var currentEmployee = hr.COPY_EMP.Find(id); currentEmployee.FIRST_NAME = employee.FIRST_NAME; currentEmployee.LAST_NAME = employee.LAST_NAME; currentEmployee.EMAIL = employee.EMAIL; currentEmployee.HIRE_DATE = employee.HIRE_DATE; currentEmployee.PHONE_NUMBER = employee.PHONE_NUMBER; currentEmployee.SALARY = employee.SALARY; hr.SaveChanges(); return(Redirect("~/employees")); } }
public ActionResult PostEmployee(EmployeeDTO emp) { if (ModelState.IsValid) { using (HREntities hr = new HREntities()) { COPY_EMP newEmployee = new COPY_EMP() { EMPLOYEE_ID = emp.EmployeeId, FIRST_NAME = emp.FirstName, LAST_NAME = emp.LastName, EMAIL = emp.Email, PHONE_NUMBER = emp.PhoneNumber, HIRE_DATE = emp.HiredDate }; hr.COPY_EMP.Add(newEmployee); hr.SaveChanges(); return(Redirect("~/employees")); } } return(View("EmployeeForm")); }