public IActionResult GetTimeTrackerDataWithFilter([FromBody] TimeclockFilter model) { try { model.DistrictId = base.CurrentUser.DistrictId; model.OrganizationId = base.CurrentUser.OrganizationId; model.UserId = base.CurrentUser.Id; var reportDetails = _service.GetTimeTrackerDataWithFilter(model); return(Ok(reportDetails)); } catch (Exception ex) { } finally { } return(null); }
public async Task <IEnumerable <TimeClock> > GetTimeTrackerSummary(TimeclockFilter model) { using (var connection = base.GetConnection) { try { var sql = "[Subzz_Users].[Users].[GetTimeTrackerData]"; var queryParams = new DynamicParameters(); queryParams.Add("@StartDate", model.StartDate); queryParams.Add("@EndDate", model.EndDate); queryParams.Add("@IsDaysSelected", model.IsDaysSelected); queryParams.Add("@UserId", model.UserId); return(await connection.QueryAsync <TimeClock>(sql, queryParams, commandType : System.Data.CommandType.StoredProcedure)); } catch (Exception ex) { } finally { } } return(null); }
public List <TimeClock> GetTimeTrackerDataWithFilter(TimeclockFilter filter) { using (var connection = base.GetConnection) { try { var sql = "[Subzz_Users].[Users].[GetTimeTrackerData]"; var param = new DynamicParameters(); param.Add("@FromDate", filter.FromDate); param.Add("@ToDate", filter.ToDate); param.Add("@LocationId", filter.OrganizationId); param.Add("@DistrictId", filter.DistrictId); param.Add("@UserId", filter.UserId); return(connection.Query <TimeClock>(sql, param, commandType: System.Data.CommandType.StoredProcedure).ToList()); } catch (Exception ex) { } finally { } return(null); } }
public async Task <IEnumerable <SubzzV2.Core.Models.TimeClock> > GetTimeTrackerSummary([FromBody] TimeclockFilter model) { try { model.DistrictId = base.CurrentUser.DistrictId; model.OrganizationId = base.CurrentUser.OrganizationId; model.UserId = base.CurrentUser.Id; return(await _service.GetTimeTrackerSummary(model)); } catch (Exception ex) { } finally { } return(null); }
public async Task <IEnumerable <TimeClock> > GetTimeClockSummaryWithFilter(TimeclockFilter model) { return(await _repo.GetTimeClockSummaryWithFilter(model)); }
public List <TimeClock> GetTimeTrackerDataWithFilter(TimeclockFilter model) { return(_repo.GetTimeTrackerDataWithFilter(model)); }
public async Task <IEnumerable <TimeClock> > GetTimeTrackerSummary(TimeclockFilter model) { return(await _repo.GetTimeTrackerSummary(model)); }