protected void Insert(object sender, EventArgs e) { var newEmployee = new Employee { FirstName = txtFirstNameAdd.Text, Surname = txtSurnameAdd.Text }; var da = new EmployeeDataAccess(); da.AddEmployee(newEmployee); da.SaveChanges(); var hubContext = GlobalHost.ConnectionManager.GetHubContext<StatusHub>(); hubContext.Clients.All.broadcastMessage("New employee added! (This is a push message from Signal-R, open other web clients and you will receive this message on both clients.)"); txtFirstNameAdd.Text = String.Empty; txtSurnameAdd.Text = String.Empty; this.BindGrid(); }
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e) { int employeeId = Convert.ToInt32(employeeGridView.DataKeys[e.RowIndex].Values[0]); var da = new EmployeeDataAccess(); var employee = da.GetEmployees().FirstOrDefault(emp => emp.EmployeeId == employeeId); da.RemoveEmployee(employee); da.SaveChanges(); this.BindGrid(); }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { int employeeId = Convert.ToInt32(employeeGridView.DataKeys[e.RowIndex].Values[0]); GridViewRow row = employeeGridView.Rows[e.RowIndex]; string firstname = (row.FindControl("txtFirstName") as TextBox).Text; string surname = (row.FindControl("txtSurname") as TextBox).Text; var da = new EmployeeDataAccess(); var employee = da.GetEmployees().First(emp => emp.EmployeeId == employeeId); employee.FirstName = firstname; employee.Surname = surname; da.SaveChanges(); employeeGridView.EditIndex = -1; this.BindGrid(); }