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