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 Insert(object sender, EventArgs e)
{
var newRole = new Role { Role1 = txtRoleAdd.Text, Description = txtDescriptionAdd.Text, BaseRate = Double.Parse(txtBaseRateAdd.Text) };
var da = new RoleDataAccess();
da.AddRole(newRole);
da.SaveChanges();
txtRoleAdd.Text = String.Empty;
txtDescriptionAdd.Text = String.Empty;
txtBaseRateAdd.Text = String.Empty;
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();
}
protected void AddItem(object sender, ImageClickEventArgs e)
{
var imageButton = (ImageButton)sender;
if (imageButton == null) return;
var repeater = imageButton.Parent;
var ddl = (DropDownList)repeater.FindControl("ddlRoles");
if (ddl == null) return;
var selectedItem = ddl.SelectedItem;
if (selectedItem == null) return;
var employeeDataAccess = new EmployeeDataAccess();
var employees = employeeDataAccess.GetEmployees();
var employee = employees[employeeGridView.EditIndex];
var daRoles = new RoleDataAccess();
var role = daRoles.GetRole(selectedItem.Value);
var daEmployeeRoles = new EmployeeRoleDataAccess();
daEmployeeRoles.AddRole(employee.EmployeeId, role.RoleId);
daEmployeeRoles.SaveChanges();
this.BindGrid();
}
private static void PopulateRoles()
{
var db = new RoleDataAccess();
Roles = db.GetRoles().Select(r => r.Role1).ToList();
}
protected void RemoveItem(object sender, ImageClickEventArgs e)
{
var imageButton = (ImageButton)sender;
if (imageButton == null) return;
var panel = (Panel)imageButton.Parent;
if (panel == null) return;
var roleLabel = (Label)panel.FindControl("Label1");
if (roleLabel == null) return;
var employeeDataAccess = new EmployeeDataAccess();
var employees = employeeDataAccess.GetEmployees();
var employee = employees[employeeGridView.EditIndex];
var daRoles = new RoleDataAccess();
var role = daRoles.GetRole(roleLabel.Text);
var daEmployeeRoles = new EmployeeRoleDataAccess();
daEmployeeRoles.RemoveRole(employee, role);
daEmployeeRoles.SaveChanges();
Roles.Add(role.Role1);
this.BindGrid();
}
private void BindGrid()
{
var da = new RoleDataAccess();
roleGridView.DataSource = da.GetRoles();
roleGridView.DataBind();
}
