public static EmployeeDirectoryModel ToEmployeeDirectoryModel(this EmployeeDirectory employee, DataSourceRequest request)
{
var filters = request.Filters;
if (!filters.Any())
{
return(employee.ToEmployeeDirectoryModel());
}
var predicate = ExpressionBuilder.Expression <EmployeeDirectory>(filters, false).Compile();
return(new EmployeeDirectoryModel
{
EmployeeId = employee.EmployeeID,
ReportsTo = employee.ReportsTo,
FirstName = employee.FirstName,
LastName = employee.LastName,
Address = employee.Address,
City = employee.City,
Country = employee.Country,
BirthDate = employee.BirthDate,
HireDate = employee.HireDate,
Phone = employee.Phone,
Position = employee.Position,
Extension = employee.Extension,
hasChildren = employee.EmployeeDirectory1.Any(predicate)
});
}
private void Delete(EmployeeDirectory employee)
{
var children = db.EmployeeDirectories.Where(e => e.ReportsTo == employee.EmployeeID);
foreach (var subordinate in children)
{
Delete(subordinate);
}
db.EmployeeDirectories.Remove(employee);
}
private void DeleteEntityChildren(EmployeeDirectory employee)
{
using (var db = GetContext())
{
var children = db.EmployeeDirectories.Where(e => e.ReportsTo == employee.EmployeeID);
foreach (var subordinate in children)
{
DeleteEntityChildren(subordinate);
}
db.EmployeeDirectories.Remove(employee);
}
}
async Task LoadDirectory()
{
SQLiteAsyncManager database = new SQLiteAsyncManager();
Employees = new ObservableCollection <Employee>
(await database.GetAllItems <Employee>());
if (!Employees.Any())
{
Directory = new EmployeeDirectory();
await Directory.GenerateRandomDirectory();
Employees = Directory.Employees;
}
}
void LoadDirectory()
{
if (!IsBusy)
{
IsBusy = true;
Employees =
new ObservableCollection <Employee>(databaseManager.GetAllItems <Employee>());
if (!Employees.Any())
{
EmployeeDirectory directory = new EmployeeDirectory();
Employees = directory.Employees;
}
IsBusy = false;
}
}
public static EmployeeDirectoryRemoteModel ToEmployeeDirectoryRemoteModel(this EmployeeDirectory employee)
{
return(new EmployeeDirectoryRemoteModel
{
EmployeeId = employee.EmployeeID,
ReportsTo = employee.ReportsTo,
FirstName = employee.FirstName,
LastName = employee.LastName,
Address = employee.Address,
City = employee.City,
Country = employee.Country,
BirthDate = employee.BirthDate,
HireDate = employee.HireDate,
Phone = employee.Phone,
Position = employee.Position,
Extension = employee.Extension
});
}
public static EmployeeDirectoryModel ToEmployeeDirectoryModel(this EmployeeDirectory employee)
{
return(new EmployeeDirectoryModel
{
EmployeeId = employee.EmployeeID,
ReportsTo = employee.ReportsTo,
FirstName = employee.FirstName,
LastName = employee.LastName,
Address = employee.Address,
City = employee.City,
Country = employee.Country,
BirthDate = employee.BirthDate,
HireDate = employee.HireDate,
Phone = employee.Phone,
Position = employee.Position,
Extension = employee.Extension,
hasChildren = employee.InverseReportsToNavigation.Any()
});
}
async Task LoadDirectory()
{
if (!IsBusy)
{
IsBusy = true;
Employees =
new ObservableCollection <Employee>(await databaseManager.GetAllItemsAsync <Employee>());
if (!Employees.Any())
{
EmployeeDirectory directory = new EmployeeDirectory();
await directory.GenerateRandomDirectory();
Employees = directory.Employees;
}
IsBusy = false;
}
}
private void Delete(EmployeeDirectory employee)
{
var children = db.EmployeeDirectories.Where(e => e.ReportsTo == employee.EmployeeID);
foreach (var subordinate in children)
{
Delete(subordinate);
}
db.EmployeeDirectories.Remove(employee);
}
