protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e) { int roleId = Convert.ToInt32(roleGridView.DataKeys[e.RowIndex].Values[0]); var da = new RoleDataAccess(); var role = da.GetRoles().First(role1 => role1.RoleId == roleId); da.RemoveRole(role); da.SaveChanges(); this.BindGrid(); }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { int roleId = Convert.ToInt32(roleGridView.DataKeys[e.RowIndex].Values[0]); GridViewRow row = roleGridView.Rows[e.RowIndex]; string role = (row.FindControl("txtRole") as TextBox).Text; string description = (row.FindControl("txtDescription") as TextBox).Text; double baseRate = Double.Parse((row.FindControl("txtBaseRate") as TextBox).Text); var da = new RoleDataAccess(); var employee = da.GetRoles().First(role1 => role1.RoleId == roleId); employee.Role1 = role; employee.Description = description; employee.BaseRate = baseRate; da.SaveChanges(); roleGridView.EditIndex = -1; this.BindGrid(); }
private static void PopulateRoles() { var db = new RoleDataAccess(); Roles = db.GetRoles().Select(r => r.Role1).ToList(); }
private void BindGrid() { var da = new RoleDataAccess(); roleGridView.DataSource = da.GetRoles(); roleGridView.DataBind(); }