Exemple #1
0
 public Task <GetEmployeeDetailViewModel> Handle(GetEmployeeDetailQuery request, CancellationToken cancellationToken) =>
 queryFacade.QuerySingleAsync <GetEmployeeDetailViewModel>(@"SELECT TOP 1 Address1, Address2, City, CurrencyCode, DateExited, DateHired, DateOfBirth, EmployeeLevel, FirstName, Gender, Id, LastName, MiddleName, PaidTimeOffPolicyId, PtoHoursRemaining, Salary, State, Zip FROM Employees WHERE Id = @Id", request);
Exemple #2
0
 public Task <GetPaidTimeOffPolicyDetailViewModel> Handle(GetPaidTimeOffPolicyDetailQuery request, CancellationToken cancellationToken) =>
 queryFacade.QuerySingleAsync <GetPaidTimeOffPolicyDetailViewModel>("SELECT TOP 1 AllowsUnlimitedPto, EmployeeLevel, Id, IsDefaultForEmployeeLevel, MaxPtoHours, Name, PtoAccrualRate FROM PaidTimeOffPolicies WITH(NOLOCK) WHERE Id = @Id", request);