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;
}
}
