public List <DailyVehicleBeatViewModel> GetAllVehicleBeatRecord(VehicleBeatFilterViewModel filters, string userName)
{
var user = _userService.GetUserByUsername(userName);
var splitedDate = filters.Date.Split('-');
var filterDate = new DateTime(int.Parse(splitedDate[0]), int.Parse(splitedDate[1]), int.Parse(splitedDate[2]), 0, 0, 0);
TimeZoneInfo cstZone = TimeZoneInfo.FindSystemTimeZoneById(user.TimeZone.TimeZoneId);
var startDate = new DateTime(int.Parse(splitedDate[0]), int.Parse(splitedDate[1]), int.Parse(splitedDate[2]), 0, 0, 0);
var endDate = new DateTime(int.Parse(splitedDate[0]), int.Parse(splitedDate[1]), int.Parse(splitedDate[2]), 23, 59, 59);
var query = _db.DailyVehicleBeats.Where(t => TimeZoneInfo.ConvertTimeFromUtc(t.Date, cstZone) >= startDate && TimeZoneInfo.ConvertTimeFromUtc(t.Date, cstZone) <= endDate && t.IsActive == true).OrderByDescending(t => t.Vehicle.RegistrationNo);
var data = new List <DailyVehicleBeatViewModel>();
var pageData = query.ToList();
pageData.ForEach(p =>
{
var vm = p.ToVm();
vm.Date = TimeZoneInfo.ConvertTimeFromUtc(vm.Date, cstZone);
vm.CreatedOn = TimeZoneInfo.ConvertTimeFromUtc(vm.CreatedOn, cstZone);
vm.UpdatedOn = TimeZoneInfo.ConvertTimeFromUtc(vm.UpdatedOn, cstZone);
data.Add(vm);
});
return(data);
}
public ActionResult Post(VehicleBeatFilterViewModel filters)
{
var userName = identityService.GetUserName();
var response = _vehicleBeatService.GetAllVehicleBeatRecord(filters, userName);
return(Ok(response));
}
