public static void LoadCategories()
{
var category = Connector.Override(Northwind.Connector).Using(_ => Database.View <Categories>().ToList());
category.Select(s => new CategoryEntity
{
CategoryName = s.CategoryName,
Description = s.Description,
Picture = new FileEmbedded {
FileName = s.CategoryName + ".jpg", BinaryFile = EmployeeLoader.RemoveOlePrefix(s.Picture.ToArray())
},
}.SetId(s.CategoryID))
.BulkInsert(disableIdentity: true);
}
public EmployeeTableForm()
{
filteredEmployees = new List <Employee>();
repository = new Repository();
ChangeNameFields();
InitializeComponent();
var selectedOffices = repository.GetAllEmployees().Select(e => e.Office).Distinct().ToList();
var allOffices = repository.GetAllEmployees().Select(e => e.Office).Distinct().ToList();
filterParameters = GridFilterParameters.GetBaseParameters(selectedOffices, allOffices);
gridLoader = new EmployeeLoader(dgvEmployees, filteredEmployees, repository, slbEmployeesCount);
dgvEmployees.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
public Task <Employee?> GetSupervisor(
IResolverContext ctx,
[DataLoader] EmployeeLoader loader)
{
if (SupervisorId == null)
{
return(Task <Employee?> .FromResult <Employee?>(null));
}
if (ctx.IsSingleField("id"))
{
return(Task.FromResult <Employee?>(new Employee {
Id = SupervisorId ?? 0
}));
}
return(loader.LoadOptionalAsync(SupervisorId ?? throw new InvalidOperationException("Internal bug")));
}
