public ReportOrderModel GetOrders(DateTimeOffset start, DateTimeOffset end, int?organisationId, IEnumerable <int> localAdminCustomerUnits = null) { var requestOrders = _dbContext.Requests.GetRequestsOrdersForReport(start.Date, end.Date, organisationId, localAdminCustomerUnits); var requisitions = _dbContext.Requisitions.GetRequisitionsForOrdersForReport(start.Date, end.Date, organisationId, localAdminCustomerUnits); var complaints = _dbContext.Complaints.GetComplaintsForOrdersForReport(start.Date, end.Date, organisationId, localAdminCustomerUnits); var interpreterLocations = _dbContext.OrderInterpreterLocation.GetInterpreterLocationsForOrdersForReport(start.Date, end.Date, organisationId, localAdminCustomerUnits); var orderRequirements = _dbContext.OrderRequirements.GetOrderRequirementsForOrdersForReport(start.Date, end.Date, organisationId, localAdminCustomerUnits); var orderRequirementAnswers = _dbContext.OrderRequirementRequestAnswer.GetRequirementAnswersForOrdersForReport(start.Date, end.Date, organisationId, localAdminCustomerUnits); var competenceRequirements = _dbContext.OrderCompetenceRequirements.GetOrderCompetencesForOrdersForReport(start.Date, end.Date, organisationId, localAdminCustomerUnits); return(ReportOrderModel.GetModelFromOrders(requestOrders, requisitions, complaints, interpreterLocations, orderRequirements, orderRequirementAnswers, competenceRequirements, null, false, false)); }
public ReportOrderModel GetRequestsForBroker(DateTimeOffset start, DateTimeOffset end, int brokerId) { var requestOrders = _dbContext.Requests.GetRequestOrdersForBrokerReport(start.Date, end.Date, brokerId); var orderIds = requestOrders.Select(r => r.OrderId).Distinct().ToList(); var requisitions = _dbContext.Requisitions.GetRequisitionsForBrokerReport(start.Date, end.Date, brokerId); var complaints = _dbContext.Complaints.GetComplaintsForBrokerReport(start.Date, end.Date, brokerId); var interpreterLocations = _dbContext.OrderInterpreterLocation.GetInterpreterLocationsByOrderIds(orderIds); var orderRequirements = _dbContext.OrderRequirements.GetOrderRequirementsByOrderIds(orderIds); var orderRequirementAnswers = _dbContext.OrderRequirementRequestAnswer.GetRequirementAnswersForBrokerReport(start.Date, end.Date, brokerId); var competenceRequirements = _dbContext.OrderCompetenceRequirements.GetOrderCompetencesByOrderIds(orderIds); return(ReportOrderModel.GetModelFromOrders(requestOrders, requisitions, complaints, interpreterLocations, orderRequirements, orderRequirementAnswers, competenceRequirements, null, true, false)); }
public ReportOrderModel GetDeliveredOrders(DateTimeOffset start, DateTimeOffset end, int?organisationId, IEnumerable <int> localAdminCustomerUnits = null) { var requestOrders = _dbContext.Requests.GetDeliveredRequestsWithOrders(start.Date, end.Date, _clock.SwedenNow.DateTime, organisationId, localAdminCustomerUnits); var requisitions = _dbContext.Requisitions.GetRequisitionsForDeliveredOrders(start.Date, end.Date, _clock.SwedenNow.DateTime, organisationId, localAdminCustomerUnits); var complaints = _dbContext.Complaints.GetComplaintsForDeliveredOrders(start.Date, end.Date, _clock.SwedenNow.DateTime, organisationId, localAdminCustomerUnits); var interpreterLocations = _dbContext.OrderInterpreterLocation.GetInterpreterLocationsForDeliveredOrders(start.Date, end.Date, _clock.SwedenNow.DateTime, organisationId, localAdminCustomerUnits); var orderRequirements = _dbContext.OrderRequirements.GetOrderRequirementsForDeliveredOrders(start.Date, end.Date, _clock.SwedenNow.DateTime, organisationId, localAdminCustomerUnits); var orderRequirementAnswers = _dbContext.OrderRequirementRequestAnswer.GetRequirementAnswersForDeliveredOrders(start.Date, end.Date, _clock.SwedenNow.DateTime, organisationId, localAdminCustomerUnits); var competenceRequirements = _dbContext.OrderCompetenceRequirements.GetOrderCompetencesForDeliveredOrders(start.Date, end.Date, _clock.SwedenNow.DateTime, organisationId, localAdminCustomerUnits); var requestPricerows = _dbContext.RequestPriceRows.GetRequestPriceRowsForDeliveredOrders(start.Date, end.Date, _clock.SwedenNow.DateTime, organisationId, localAdminCustomerUnits); return(ReportOrderModel.GetModelFromOrders(requestOrders, requisitions, complaints, interpreterLocations, orderRequirements, orderRequirementAnswers, competenceRequirements, requestPricerows, false, true)); }
public ReportOrderModel GetDeliveredRequestsForBroker(DateTimeOffset start, DateTimeOffset end, int brokerId) { var requestOrders = _dbContext.Requests.GetDeliveredRequestsWithOrders(start.Date, end.Date, _clock.SwedenNow.DateTime, null, null, brokerId); var orderIds = requestOrders.Select(r => r.OrderId).Distinct().ToList(); var requisitions = _dbContext.Requisitions.GetRequisitionsForDeliveredOrders(start.Date, end.Date, _clock.SwedenNow.DateTime, null, null, brokerId); var complaints = _dbContext.Complaints.GetComplaintsForDeliveredOrders(start.Date, end.Date, _clock.SwedenNow.DateTime, null, null, brokerId); var interpreterLocations = _dbContext.OrderInterpreterLocation.GetInterpreterLocationsByOrderIds(orderIds); var orderRequirements = _dbContext.OrderRequirements.GetOrderRequirementsByOrderIds(orderIds); var orderRequirementAnswers = _dbContext.OrderRequirementRequestAnswer.GetRequirementAnswersForDeliveredOrders(start.Date, end.Date, _clock.SwedenNow.DateTime, null, null, brokerId); var competenceRequirements = _dbContext.OrderCompetenceRequirements.GetOrderCompetencesByOrderIds(orderIds); var requestPricerows = _dbContext.RequestPriceRows.GetRequestPriceRowsForDeliveredOrders(start.Date, end.Date, _clock.SwedenNow.DateTime, null, null, brokerId); return(ReportOrderModel.GetModelFromOrders(requestOrders, requisitions, complaints, interpreterLocations, orderRequirements, orderRequirementAnswers, competenceRequirements, requestPricerows, true, true)); }