internal Expression FirstFamilyVisitAsOf() { var cdt = db.Setting("DbConvertedDate", "1/1/1900").ToDate(); if (!StartDate.HasValue) { return(AlwaysFalse()); } var enddt = EndDate?.AddHours(24) ?? DateTime.Today.AddHours(24); var q = from fm in db.ViewFamilyFirstTimes where fm.CreatedDate > cdt where fm.FirstDate >= StartDate where fm.FirstDate < enddt select fm.FamilyId; Expression <Func <Person, bool> > pred = p => q.Contains(p.FamilyId); Expression expr = Expression.Invoke(pred, parm); if (op == CompareType.NotEqual || op == CompareType.NotOneOf) { expr = Expression.Not(expr); } return(expr); }
private void GetChooseDateEvents() { OthersEvents = EndDateSpecified ? service.GetEvents(calendar, StartDate, EndDate.AddHours(23).AddMinutes(59).AddSeconds(59)) : service.GetEvents(calendar, StartDate, DateTime.Today.AddYears(2)); OthersEvents = EnableSearch ? service.SearchEvents(OthersEvents, TextToSearch) : OthersEvents; OthersEvents = service.FormatEventsDatesStringRepresentation(OthersEvents, repository.GetDateTimePreferences()); eventListType = EventsListType.ThisMonth; ShowResults(); HideChooseDateEventsControls(); }
public ActionResult DriverWiseBataReport(ReportViewModel model) { try { DateTime startDate; DateTime EndDate; DateTime.TryParse(model.ReportDto.StartDate.ToLongDateString(), out startDate); DateTime.TryParse(model.ReportDto.EndDate.ToLongDateString(), out EndDate); model.ReportDto.StartDate = startDate.AddHours(6); model.ReportDto.EndDate = EndDate.AddHours(6); IEnumerable <TripDto> trips = _tripService.RetrieveDriverWiseBataDetails(model.ReportDto).Where(a => a.IsReopened != true).ToList(); IEnumerable <BataReportModel> bata = trips.Where(a => a.CustomBata != null || a.TripBata != null).GroupBy(a => a.UpdatedDate.Date).Select(a => new BataReportModel { Date = a.Key, BataDetails = a.Select(x => new DailyDriverPerformanceDto { VoucherNumber = x.VoucherNumber, DispatchedHotel = x.DispatchedHotel, Createdby = x.Createdby, Updatedby = x.Updatedby, DriverName = x.DriverName, VehicleNumber = x.VehicleNumber, Packages = x.Packages, CreatedDate = x.CreatedDate, UpdatedDate = x.UpdatedDate, EmployeeNumber = x.EmployeeNumber, BataAmount = x.TripBata == null ? 0 : x.TripBata.FirstOrDefault().Amount, BataDescription = x.TripBata == null ? "" : x.TripBata.FirstOrDefault().Description, CustomBataAmount = x.CustomBata == null ? 0 : x.CustomBata.FirstOrDefault().CustomAmount, }).ToList() }).ToList(); ReportViewModel models = new ReportViewModel() { DriverReportList = Mapper.Map <List <DailyDriverPerformanceDto> >(trips).ToList(), BataList = bata, CurrentDate = CustomDataHelper.CurrentDateTimeSL.GetCurrentDate(), Driver = GetDriverNames(), Vehicle = GetVehicleNumbers(), Employee = GetEmployeeNumbers(), ReportDto = model.ReportDto, }; ViewBag.Content = true; TempData["DriverReportTemp"] = models; return(View(models)); } catch (Exception ex) { throw ex; } }
void UpdateEndTrip(bool setFirst = false) { EndtTrip.Clear(); EndtTrip.Add(new TripAdvisorViewModel(string.Empty, "Текущее")); EndtTrip.Add(new TripAdvisorViewModel(string.Empty, "23:59")); foreach (var el in PCHandler.Instance.ListTrip.Where(o => o.EndEng >= EndDate && o.EndEng <= EndDate.AddHours(23).AddMinutes(59))) { EndtTrip.Add(el); } if (setFirst) { SelectedEnd = EndtTrip[0]; } }
public DayOverviewViewModel(ITimeEntryService timeEntryService, IBusyService busyService) { _timeEntryService = timeEntryService; _busyService = busyService; _busyService.ShowBusy(_dayoverviewKey); TimeEntries = new List <DataOverviewItemViewModel>(); PreviousDateCommand = new DelegateCommand <object>(a => StartDate = StartDate.AddDays(-1)); NextDayCommand = new DelegateCommand <object>(a => StartDate = StartDate.AddDays(1)); TodayCommand = new DelegateCommand <object>(a => StartDate = GetNuetralKindDateTimeToday()); EditTaskCommand = new DelegateCommand <object>(EditTaskExecute); _saveCommandCompletedCommand = new DelegateCommand <object>(SaveTaskCompleted); TaskCommands.SaveTaskCompleted.RegisterCommand(_saveCommandCompletedCommand); OverviewCommands.GoToDaySubMenu.RegisterCommand(new DelegateCommand <object>(ChangeDate)); VisiblePeriodStart = StartDate.AddHours(6); VisiblePeriodEnd = EndDate.AddHours(-6); StartDate = GetNuetralKindDateTimeToday(); }
/// <summary> /// Initializes a new instance of the <see cref="CalendarViewFormat"/> class. /// </summary> /// <param name="viewType">Type of the view.</param> /// <param name="showday">The showday.</param> /// <param name="weekStartDay">The week start day.</param> public CalendarViewFormat(CalendarViewType viewType, DateTime showday, DayOfWeek weekStartDay) { int index, w; switch (viewType) { case CalendarViewType.day: //ÈÕ StartDate = showday.Date; EndDate = showday.Date.AddHours(23).AddMinutes(59).AddSeconds(59); break; case CalendarViewType.week: // ÖÜ index = weekStartDay.GetHashCode(); //0 w = index - showday.DayOfWeek.GetHashCode(); //0-1 if (w > 0) { w = w - 7; } StartDate = showday.AddDays(w).Date; EndDate = StartDate.AddDays(6).AddHours(23).AddMinutes(59).AddSeconds(59); break; case CalendarViewType.month: // ÔÂ DateTime firstdate = new DateTime(showday.Year, showday.Month, 1); index = weekStartDay.GetHashCode(); //0 w = index - firstdate.DayOfWeek.GetHashCode(); //0-1 if (w > 0) { w -= 7; } //w = 0; StartDate = firstdate.AddDays(w).Date; EndDate = StartDate.AddDays(34); if (EndDate.Year == showday.Year && EndDate.Month == showday.Month && EndDate.AddDays(1).Month == EndDate.Month) { EndDate = EndDate.AddDays(7); } EndDate.AddHours(23).AddMinutes(59).AddSeconds(59); break; } }
async Task ExecuteSaveCourseCommand() { if (checkValues(Course)) { await App.Database.SaveCourseAsync(Course); await App.Current.MainPage.Navigation.PopAsync(); SetNotify(Notifications, "CourseKeeper", $"{Name} is ending at {EndDate}", "Course", Course.ID, EndDate.AddHours(-36)); MessagingCenter.Send <EditCoursePageViewModel, Course>(this, "UpdateCourse", Course); } else { App.Current.MainPage.DisplayAlert("Alert", "Fields cannot be left blank, please supply all values", "OK"); return; } }