public async Task <InOutUserReportResult> Get(InOutUserReportRequest request)
        {
            var from          = DateTime.Parse(request.From, System.Globalization.CultureInfo.InstalledUICulture);
            var to            = DateTime.Parse(request.To, System.Globalization.CultureInfo.InstalledUICulture);
            var currentUserId = ApplicationUser.GetCurrent().UserId;

            var userIdParameter         = new SqlParameter("@UsuarioId", currentUserId);
            var scheduleTypeIdParameter = new SqlParameter("@TipoHorarioId", request.ScheduleTypeId);
            var fromParameter           = new SqlParameter("@Desde", from.ToString("s"));
            var toParameter             = new SqlParameter("@Hasta", to.ToString("s"));
            var locacionIdParameter     = new SqlParameter("@TimeSheetLocacionId", request.LocationId);

            var report = await _repo.ExecStoreProcedure <EF.Model.InOutUserReport>("REP_TimeSheet_Cons_sp @UsuarioId, @TipoHorarioId, @Desde, @Hasta, @TimeSheetLocacionId"
                                                                                   , userIdParameter, scheduleTypeIdParameter, fromParameter, toParameter, locacionIdParameter)
                         .ToListAsync();

            return(Parse(report));
        }
示例#2
0
        public async Task <IHttpActionResult> Get([FromUri] InOutUserReportRequest request)
        {
            var report = await _service.Get(request);

            return(Ok(report));
        }