public void Get(int departmentId)
{
using (SchneiderSqlModel _database = new SchneiderSqlModel())
{
Entity = _database.Departments.Find(departmentId);
}
}
public void Get(int employeeId)
{
using (SchneiderSqlModel _database = new SchneiderSqlModel())
{
Entity = _database.Employees.Find(employeeId);
}
}
public void Get()
{
using (SchneiderSqlModel _database = new SchneiderSqlModel())
{
Departments = _database.Departments.OrderBy(d => d.Name).ToList();
}
}
public void Get()
{
using (SchneiderSqlModel _database = new SchneiderSqlModel())
{
Employees = _database.Employees.OrderBy(d => d.Name).ToList();
}
}
public void Delete(int departmentId)
{
using (SchneiderSqlModel _database = new SchneiderSqlModel())
{
var department = _database.Departments.Find(departmentId);
if (department != null)
{
_database.Departments.Remove(department);
}
_database.SaveChanges();
Get();
}
}
public void Delete(int employeeId)
{
using (SchneiderSqlModel _database = new SchneiderSqlModel())
{
var employee = _database.Employees.Find(employeeId);
if (employee != null)
{
_database.Employees.Remove(employee);
}
_database.SaveChanges();
Get();
}
}
private void SaveChangesToDataBase(SchneiderSqlModel _database)
{
//Check if it update of insert
if (PageMode == PageConstants.Edit)
{
_database.Entry(Entity).State = EntityState.Modified;
_database.SaveChanges();
}
else if (PageMode == PageConstants.Add)
{
_database.Departments.Add(Entity);
_database.SaveChanges();
}
}
public void Save()
{
Messages.Clear();
using (SchneiderSqlModel _database = new SchneiderSqlModel())
{
try
{
SaveChangesToDataBase(_database);
//Get All Changes
Get();
}
catch (DbEntityValidationException exception)
{
CatchErrorToDispaly(exception);
}
}
}
public void LoadSearchDepartments()
{
using (SchneiderSqlModel _database = new SchneiderSqlModel())
{
if (Departments.Count == 0)//load from DB
{
SearchDepartments.AddRange(_database.Departments);
}
else // load from deparmtments list
{
SearchDepartments.AddRange(Departments);
}
//Add Search All Categories for Search All
Department department = new Department();
department.Id = 0;
department.Name = "-- Search All Departments --";
//Insert Department At th e top
SearchDepartments.Insert(0, department);
}
}
