public string GetTempStatusExpDate(DateTime startDate) { DateTime tempStatusExpDate = _repository.ExecuteScalar <DateTime>( $"Exec dbo.usp_AdmGetTempStatusExpDate '{startDate.ToStoredProcDateString()}', 29"); return(tempStatusExpDate.ToUsDateString()); }
private async Task <List <FroCustomizationViewModel> > GetCustomizationList() { // get the current year to see if we want to show these var currentYear = _repository.ExecuteScalar <int>("EXEC usp_PosGetCurrentArchiveYear"); var froCustomizations = await _repository .GetListAsync <FroCustomization>(x => (x.AppYear >= currentYear || !x.AppYear.HasValue) && x.Type == (int)FroCustomizationType.Checkbox); var froCustomizationsSorted = froCustomizations.OrderBy(x => x.Page).ThenBy(x => x.SortOrder); return(_autoMapper.Map <List <FroCustomizationViewModel> >(froCustomizationsSorted)); }