private void BtnDeleteRepo_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
try
{
if (!User.UserInAction("can delete"))
{
return;
}
if (MessageBox.Show("Do you want to Delete this?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
if (EmployeesGridView.GetFocusedRow() is Employees item)
{
UnitOfWork unitOfWork = new UnitOfWork();
unitOfWork.EmployeesRepo.Delete(m => m.Id == item.Id);
unitOfWork.Save();
Init();
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, exception.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void GetEmployees()
{
IEnumerable <Employee> employees = _context.Employees.ToList();
EmployeesGridView.DataSource = employees;
EmployeesGridView.DataBind();
}
/// <summary>
/// Handles the ItemDeleted event of the FormView
/// Use it to refresh the GridView to reflect the deletion of the Employee in hand.
/// And the deleted Employee was the last one in the grid,
/// select the previous employee, after refreshing the grid.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void EmployeeFormView_ItemDeleted(object sender, FormViewDeletedEventArgs e)
{
EmployeesGridView.DataBind();
if (EmployeesGridView.SelectedIndex >= EmployeesGridView.Rows.Count)
{
EmployeesGridView.SelectedIndex = EmployeesGridView.Rows.Count - 1;
}
}
private void EmployeesGridView_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (EmployeesGridView.GetRow(e.RowHandle) is Employees item)
{
if (item.isSelected)
{
employeeIds.Add(item.Id);
}
else
{
employeeIds.Remove(item.Id);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
var path = HttpContext.Current.Server.MapPath(DbPath);
using (var odb = OdbFactory.Open(path))
{
var employees = from employee in odb.AsQueryable <Employee>()
select new
{
ID = odb.GetObjectId(employee).ObjectId,
employee.Name,
employee.City,
employee.Age,
Employment_Date = employee.EmploymentDate.ToString("yyyy-MM-dd")
};
EmployeesGridView.DataSource = employees.ToList();
EmployeesGridView.DataBind();
}
}
/// <summary>
/// Handles the ItemDeleted event of the FormView
/// Use it to refresh the GridView to reflect the insertion of the new Employee.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void EmployeeFormView_ItemInserted(object sender, FormViewInsertedEventArgs e)
{
EmployeesGridView.DataBind();
}
