private void SaveSite(OrionDbContext inMemDb, SiteDTO dto)
{
var site = TestAutoMapper.Instance.Map <Site>(dto);
inMemDb.Sites.Add(site);
inMemDb.SaveChanges();
dto.SiteID = site.SiteID;
}
public UnitOfWork(OrionDbContext dbContext)
{
_dbContext = dbContext;
TiposUsuarios = new TiposUsuarioRepository(_dbContext);
Usuarios = new UsuariosRepository(_dbContext);
Productos = new ProductosRepository(_dbContext);
Ventas = new VentasRepository(_dbContext);
}
private void SaveClient(OrionDbContext inMemDb, ClientDTO dto)
{
dto.ClientId = 0;
var client = TestAutoMapper.Instance.Map <Client>(dto);
inMemDb.Clients.Add(client);
inMemDb.SaveChanges();
dto.ClientId = client.ClientId;
}
public TiposUsuarioRepository(OrionDbContext dbContext)
{
_dbContext = dbContext;
}
public VentasRepository(OrionDbContext dbContext)
{
_dbContext = dbContext;
}
public ProductosRepository(OrionDbContext dbContext)
{
_dbContext = dbContext;
}
public static async Task <IActionResult> Run([HttpTrigger("GET", Route = "bars")] HttpRequest req, ILogger log, [Inject] OrionDbContext ctx)
{
var sortProperty = req.Query.GetValueOrDefault("sortProperty", nameof(Bar.Id));
var sortDirection = req.Query.GetValueOrDefault <SortDirection>("sortDirection");
var pageIndex = req.Query.GetValueOrDefault("pageIndex", 0);
var pageSize = req.Query.GetValueOrDefault("pageSize", 20);
// something like...
// TODO [Query] PageOptions options
return(new OkObjectResult(await ctx.Bar.SortBy(sortProperty, sortDirection).ToPageAsync(pageIndex, pageSize)));
}
public static async Task <IActionResult> Run([HttpTrigger("GET", Route = "foos/{id:int}")] HttpRequest req, ILogger log, int id, [Inject] OrionDbContext ctx)
=> new OkObjectResult(await ctx.Foo.FindAsync(id));
public UsuariosRepository(OrionDbContext dbContext)
{
_dbContext = dbContext;
}
public EmployeeController(OrionDbContext context)
{
_context = context;
}
private async Task <Dictionary <(int employeeId, int weekId), TimeSheetApproval> > SearchForSavedApprovals(OrionDbContext db, int startWeek, int endWeek, params TimeApprovalStatus[] withTimeApprovalStatus)
{
var statusAsString = withTimeApprovalStatus.Select(z => z.ToString()).ToArray();
var baseQuery = db.TimeSheetApprovals
.Include(z => z.Employee)
.Where(x => x.WeekId >= startWeek && x.WeekId <= endWeek && statusAsString.Contains(x.TimeApprovalStatus));
var approvals = await baseQuery.ToListAsync();
var approverIds = approvals.Select(x => x.ApproverEmployeeId).Where(x => x.HasValue).Distinct().ToArray();
return(approvals.ToDictionary(x => (x.EmployeeId, x.WeekId), x => x));
}
