protected async Task LoadData(LoadDataArgs args)
{
var queryResult = await PhotoService.GetAllPhotosAsync(Filter, args.OrderBy, args.Skip, args.Top);
Count = queryResult.Count;
Photos = queryResult.Photos;
}
public async Task <List <DTOSurveyItem> > GetSurveyResults(int surveyId, LoadDataArgs args)
{
HttpResponseMessage response = await _client.PostAsJsonAsync(API_PREFIX + "/results/" + surveyId, args);
response.EnsureSuccessStatusCode();
return(await response.Content.ReadFromJsonAsync <List <DTOSurveyItem> >());
}
protected override LoadResult OnLoadData(object sender, LoadDataArgs args)
{
_logger?.LogTrace(
"{NameOfMethod}({NameOfArgs}: [{Args}])", nameof(OnLoadData), nameof(args), args);
return(base.OnLoadData(sender: sender, args: args));
}
protected override string GetODataFilter(LoadDataArgs args)
{
var filters = new List <FilterDescriptor>();
if (!string.IsNullOrEmpty(FamilyNameTextBox.Value))
{
filters.Add(new FilterDescriptor
{
FilterOperator = FilterOperator.Contains,
FilterValue = FamilyNameTextBox.Value,
LogicalFilterOperator = LogicalFilterOperator.And,
Property = "FamilyName"
});
}
if (!string.IsNullOrEmpty(GivenNamesTextBox.Value))
{
filters.Add(new FilterDescriptor
{
FilterOperator = FilterOperator.Contains,
FilterValue = GivenNamesTextBox.Value,
LogicalFilterOperator = LogicalFilterOperator.And,
Property = "GivenNames"
});
}
if (filters.IsNullOrEmpty())
{
return(args.Filter);
}
return(filters.ToODataFilterString(DataGrid));
}
private byte[] GenerateThemeContent(LoadDataArgs args)
{
var accentColor = _uiSettings.GetColorValue(UIColorType.Accent);
var backgroundColor = _uiSettings.GetColorValue(UIColorType.Background);
var foregroundColor = _uiSettings.GetColorValue(UIColorType.Foreground);
var accentLight2Color = _uiSettings.GetColorValue(UIColorType.AccentLight2);
SciterColor sciterAccentColor =
SciterColor.Create(accentColor.R, accentColor.G, accentColor.B, accentColor.A);
SciterColor sciterBackgroundColor = SciterColor.Create(backgroundColor.R, backgroundColor.G,
backgroundColor.B, backgroundColor.A);
SciterColor sciterForeground = SciterColor.Create(foregroundColor.R, foregroundColor.G,
foregroundColor.B, foregroundColor.A);
SciterColor sciterAccentLight2 = SciterColor.Create(accentLight2Color.R, accentLight2Color.G,
accentLight2Color.B, accentLight2Color.A);
var themeCss =
@$ " html:theme(system) {{
var(accent-color): {sciterAccentColor.ToShortHtmlColor()};
var(main-bg-color): {sciterBackgroundColor.ToShortHtmlColor()};
var(main-color): {sciterForeground.ToShortHtmlColor()};
var(card-bg-color): morph(color(main-color), opacity: 7.5%);
var(card-bd-color): morph(color(main-color), opacity: 50%);
var(card-bd-width): 2dip;
var(header-bg-color): color(accent-color);
var(toolbar-bg-color): morph(color(main-color), opacity: 10%);
var(menu-main-color): #D0D2D6;
var(menu-color): morph(rgb(255,255,255), opacity: 85%);
var(menu-bg-color): morph(#262930, darken: 4%);
var(menu-h-color): morph(color(menu-color), lighten: 10%);
var(menu-h-bg-color): morph(color(accent-color), opacity: 75%);
}}
card:theme(system) {{
border: transparent;
box-shadow: none;
}}
card:hover:theme(system) {{
box-shadow: none;
}}
cardheader:theme(system) > div:nth-child(2) {{
color: {sciterAccentLight2.ToShortHtmlColor()};
opacity: 1;
}}
";
return(System.Text.Encoding.UTF8.GetBytes(themeCss));
}
}
}
protected async void Grid0LoadData(LoadDataArgs args)
{
var northwindGetProductsResult = await Northwind.GetProducts(null, args.Top, args.Skip, $"{args.OrderBy}", args.Top != null && args.Skip != null, $"Supplier,Category", null, null);
getProductsResult = northwindGetProductsResult.Data;
getProductsCount = northwindGetProductsResult.Count;
}
private void OnLoadData(LoadDataArgs args)
{
Dispatcher.Dispatch(new GetFilteredUsersAction(args.Filter));
customCustomersData = UserState.Value.ClientUsers.Where(c => c.FullName.Contains(args.Filter, StringComparison.OrdinalIgnoreCase));
InvokeAsync(StateHasChanged);
}
protected async void Grid0LoadData(LoadDataArgs args)
{
var northwindGetOrdersResult = await Northwind.GetOrders(null, args.Top, args.Skip, $"{args.OrderBy}", args.Top != null && args.Skip != null, $"Customer,Employee,Shipper", null, null);
getOrdersResult = northwindGetOrdersResult.Data;
getOrdersCount = northwindGetOrdersResult.Count;
}
protected async void Grid0LoadData(LoadDataArgs args)
{
var northwindGetTerritoriesResult = await Northwind.GetTerritories(null, args.Top, args.Skip, $"{args.OrderBy}", args.Top != null && args.Skip != null, $"Region", null, null);
getTerritoriesResult = northwindGetTerritoriesResult.Data;
getTerritoriesCount = northwindGetTerritoriesResult.Count;
}
async Task LoadData(LoadDataArgs args)
{
xTable = await(TableDataServicex.GetAllTables());
count = xTable.Count();
await InvokeAsync(StateHasChanged);
}
protected async void Grid0LoadData(LoadDataArgs args)
{
var northwindGetOrderDetailsResult = await Northwind.GetOrderDetails(null, args.Top, args.Skip, $"{args.OrderBy}", args.Top != null && args.Skip != null, $"Order,Product", null, null);
getOrderDetailsResult = northwindGetOrderDetailsResult.Data;
getOrderDetailsCount = northwindGetOrderDetailsResult.Count;
}
protected async void Grid0LoadData(LoadDataArgs args)
{
var northwindGetCustomerCustomerDemosResult = await Northwind.GetCustomerCustomerDemos(null, args.Top, args.Skip, $"{args.OrderBy}", args.Top != null && args.Skip != null, $"Customer,CustomerDemographic", null, null);
getCustomerCustomerDemosResult = northwindGetCustomerCustomerDemosResult.Data;
getCustomerCustomerDemosCount = northwindGetCustomerCustomerDemosResult.Count;
}
public List <Models.SurveyItem> Post(int SelectedSurveyId, [FromBody] LoadDataArgs args)
{
List <Models.SurveyItem> Response = new List <Models.SurveyItem>();
Response = _SurveyRepository.SurveyResultsData(SelectedSurveyId, args);
return(Response);
}
private async void LoadAutoCompleteData(LoadDataArgs args)
{
var response = await ItemsService.GetItemsNames(args.Filter);
if (!response.IsSuccess)
{
this.Error.Show(response.ErrorMessage);
}
this.DisplayItemsNames = response.Data;
await InvokeAsync(StateHasChanged);
}
protected override LoadResult OnLoadData(object sender, LoadDataArgs args)
{
//watcher://theme/windows.css
if (!args.Uri.ToString().Equals("watcher://theme/windows.css"))
{
return(base.OnLoadData(sender, args));
}
var cssBytes = GenerateThemeContent(args);
Sciter.SciterApi.SciterDataReady(Window.Handle, args.Uri.ToString(), cssBytes, (uint)cssBytes.Length);
return(LoadResult.Ok);
}
public void LoadData(LoadDataArgs args)
{
var query = styleOptions.AsQueryable();
if (!string.IsNullOrEmpty(args.Filter))
{
query = query.Where(c => c.name.ToLower().Contains(args.Filter.ToLower()));
}
styleOptionsList = query.ToList();
StateHasChanged();
}
protected override LoadResult OnLoadData(object sender, LoadDataArgs args)
{
// load resource from SciterArchive
_archive?.GetItem(args.Uri, (result) =>
{
if (result.IsSuccessful)
{
_api.SciterDataReady(_window.Handle, result.Path, result.Data, (uint)result.Size);
}
});
return(base.OnLoadData(sender: sender, args: args));
}
public void LoadData(LoadDataArgs args)
{
var query = AllAdjuncts.AsQueryable();
if (!string.IsNullOrEmpty(args.Filter))
{
query = query.Where(c => c.name.ToLower().Contains(args.Filter.ToLower()));
}
AdjunctList = query.ToList();
InvokeAsync(StateHasChanged);
}
protected async System.Threading.Tasks.Task Grid0LoadData(LoadDataArgs args)
{
try
{
var crmGetTasksResult = await Crm.GetTasks(filter : $"{args.Filter}", orderby : $"{args.OrderBy}", expand : $"Opportunity,TaskType,TaskStatus", top : args.Top, skip : args.Skip, count : args.Top != null && args.Skip != null);
getTasksResult = crmGetTasksResult.Value.AsODataEnumerable();
getTasksCount = crmGetTasksResult.Count;
}
catch (Exception crmGetTasksException)
{
NotificationService.Notify(NotificationSeverity.Error, $"Error", $"Unable to load Tasks");
}
}
protected async System.Threading.Tasks.Task Grid0LoadData(LoadDataArgs args)
{
try
{
var crmGetContactsResult = await Crm.GetContacts(filter : $@"contains(Email,""{contactFilter}"") or contains(Company,""{contactFilter}"") or contains(FirstName,""{contactFilter}"") or contains(LastName,""{contactFilter}"")", orderby : $@"{args.OrderBy}", top : args.Top, skip : args.Skip, count : args.Top != null && args.Skip != null);
getContactsResult = crmGetContactsResult.Value.AsODataEnumerable();
getContactsCount = crmGetContactsResult.Count;
}
catch (Exception crmGetContactsException)
{
NotificationService.Notify(NotificationSeverity.Error, $"Error", $"Unable to load Contacts");
}
}
protected async System.Threading.Tasks.Task Grid0LoadData(LoadDataArgs args)
{
try
{
var sampleGetOrdersResult = await Sample.GetOrders(filter : $"{args.Filter}", top : args.Top, skip : args.Skip, orderby : $"{args.OrderBy}", count : args.Top != null && args.Skip != null);
getOrdersResult = sampleGetOrdersResult.Value.AsODataEnumerable();
getOrdersCount = sampleGetOrdersResult.Count;
}
catch (Exception sampleGetOrdersException)
{
NotificationService.Notify(NotificationSeverity.Error, $"Error", $"Unable to load Orders");
}
}
protected async System.Threading.Tasks.Task Grid0LoadData(LoadDataArgs args)
{
try
{
var blackmailazureGetDataResult = await Blackmailazure.GetData(filter : $@"(contains(Blackmailer,""{search}"") or contains(Blackmailee,""{search}"") or contains(img,""{search}"")) and {(string.IsNullOrEmpty(args.Filter)? "true" : args.Filter)}", orderby : $"{args.OrderBy}", top : args.Top, skip : args.Skip, count : args.Top != null && args.Skip != null);
getDataResult = blackmailazureGetDataResult.Value.AsODataEnumerable();
getDataCount = blackmailazureGetDataResult.Count;
}
catch (System.Exception blackmailazureGetDataException)
{
NotificationService.Notify(NotificationSeverity.Error, $"Error", $"Unable to load Data");
}
}
protected async System.Threading.Tasks.Task Grid0LoadData(LoadDataArgs args)
{
try
{
var conDataGetStudentsResult = await ConData.GetStudents(filter : $@"(contains(SchoolAdmissionNumber,""{search}"") or contains(Surname,""{search}"") or contains(FirstName,""{search}"") or contains(OtherNames,""{search}"") or contains(Username,""{search}"") or contains(Password,""{search}"") or contains(ConfirmPassword,""{search}"") or contains(FatherSurname,""{search}"") or contains(FatherFirstName,""{search}"") or contains(FatherOtherNames,""{search}"") or contains(FatherEmail,""{search}"") or contains(FatherTelephone,""{search}"") or contains(FatherProfession,""{search}"") or contains(FatherOffice,""{search}"") or contains(FatherResidentialAddress,""{search}"") or contains(MotherSurname,""{search}"") or contains(MotherFirstName,""{search}"") or contains(MotherOtherNames,""{search}"") or contains(MotherEmail,""{search}"") or contains(MotherTelephone,""{search}"") or contains(MotherProfession,""{search}"") or contains(MotherOffice,""{search}"") or contains(MotherResidentialAddress,""{search}"") or contains(GuardianSurname,""{search}"") or contains(GuardianFirstName,""{search}"") or contains(GuardianOtherNames,""{search}"") or contains(GuardianEmail,""{search}"") or contains(GuardianTelephone,""{search}"") or contains(GuardianProfession,""{search}"") or contains(GuardianOffice,""{search}"") or contains(GuardianResidentialAddress,""{search}"")) and {(string.IsNullOrEmpty(args.Filter)? "true" : args.Filter)}", orderby : $"{args.OrderBy}", expand : $"Gender,Country,Country1,Country2,Country3", top : args.Top, skip : args.Skip, count : args.Top != null && args.Skip != null);
getStudentsResult = conDataGetStudentsResult.Value.AsODataEnumerable();
getStudentsCount = conDataGetStudentsResult.Count;
}
catch (System.Exception conDataGetStudentsException)
{
NotificationService.Notify(NotificationSeverity.Error, $"Error", $"Unable to load Students");
}
}
protected async System.Threading.Tasks.Task Grid0LoadData(LoadDataArgs args)
{
try
{
var conDataGetCountriesResult = await ConData.GetCountries(filter : $@"(contains(CountryName,""{search}"")) and {(string.IsNullOrEmpty(args.Filter)? "true" : args.Filter)}", orderby : $"{args.OrderBy}", top : args.Top, skip : args.Skip, count : args.Top != null && args.Skip != null);
getCountriesResult = conDataGetCountriesResult.Value.AsODataEnumerable();
getCountriesCount = conDataGetCountriesResult.Count;
}
catch (System.Exception conDataGetCountriesException)
{
NotificationService.Notify(NotificationSeverity.Error, $"Error", $"Unable to load Countries");
}
}
protected async System.Threading.Tasks.Task Grid0LoadData(LoadDataArgs args)
{
var sampleGetOrdersResult = await Sample.GetOrders(new Query()
{
Filter = $@"{args.Filter}", OrderBy = $"{args.OrderBy}", Top = PageSize, Skip = Start
});
getOrdersResult = sampleGetOrdersResult;
var sampleGetOrdersResult0 = await Sample.GetOrders(new Query()
{
Filter = $@"{args.Filter}"
});
Count = sampleGetOrdersResult0.Count();
}
protected override LoadResult OnLoadData(object sender, LoadDataArgs args)
{
//_logger?.LogDebug(args.Uri.ToString());
// load resource from SciterArchive
_archive?.GetItem(args.Uri, (res) =>
{
if (res.IsSuccessful)
{
_api.SciterDataReady(Window.Handle, res.Path, res.Data, (uint)res.Size);
}
});
// call base to ensure LibConsole is loaded
return(base.OnLoadData(sender: sender, args: args));
}
async Task OnLoadData(LoadDataArgs args)
{
if (!LoadData.HasDelegate)
{
var query = Query;
if (query == null)
{
return;
}
if (!string.IsNullOrEmpty(searchText))
{
string filterCaseSensitivityOperator = FilterCaseSensitivity == FilterCaseSensitivity.CaseInsensitive ? ".ToLower()" : "";
if (AllowFilteringByAllStringColumns)
{
query = query.Where(string.Join(" || ", grid.ColumnsCollection.Where(c => c.Filterable && IsColumnFilterPropertyTypeString(c))
.Select(c => GetPropertyFilterExpression(c.GetFilterProperty(), filterCaseSensitivityOperator))),
FilterCaseSensitivity == FilterCaseSensitivity.CaseInsensitive ? searchText.ToLower() : searchText);
}
else
{
query = query.Where($"{GetPropertyFilterExpression(TextProperty, filterCaseSensitivityOperator)}",
FilterCaseSensitivity == FilterCaseSensitivity.CaseInsensitive ? searchText.ToLower() : searchText);
}
}
if (!string.IsNullOrEmpty(args.OrderBy))
{
query = query.OrderBy(args.OrderBy);
}
_internalView = query;
count = query.Count();
pagedData = QueryableExtension.ToList(query.Skip(args.Skip.HasValue ? args.Skip.Value : 0).Take(args.Top.HasValue ? args.Top.Value : PageSize)).Cast <object>();
}
else
{
await LoadData.InvokeAsync(new Radzen.LoadDataArgs()
{
Skip = args.Skip, Top = args.Top, OrderBy = args.OrderBy, Filter = searchText
});
}
}
private async Task LoadData(LoadDataArgs args)
{
var response = await this.ItemsService.GetItemsOverviewPageModel(args.Top, args.Skip, args.OrderBy, this.SearchWord, this.SearchDate);
if (!response.IsSuccess)
{
this.Error.Show(response.ErrorMessage);
}
if (response.Data != null)
{
this.DisplayItems = response.Data.OverviewItems.Select(x => Mapper.Map <ItemOverviewDto, ItemOverviewViewModel>(x));
this.Count = response.Data.TotalItemsCount;
}
await InvokeAsync(StateHasChanged);
}
protected async System.Threading.Tasks.Task Grid0LoadData(LoadDataArgs args)
{
try
{
var sdeGetExtractsResult = await Sde.GetExtracts(filter : $@"(contains(Name,""{search}"") or contains(Description,""{search}"") or contains(ExternalCode,""{search}"")) and {(string.IsNullOrEmpty(args.Filter)? "true" : args.Filter)}", orderby : $"{args.OrderBy}", top : args.Top, skip : args.Skip, count : args.Top != null && args.Skip != null);
getExtractsResult = sdeGetExtractsResult.Value.AsODataEnumerable();
getExtractsCount = sdeGetExtractsResult.Count;
}
catch (System.Exception sdeGetExtractsException)
{
NotificationService.Notify(new NotificationMessage()
{
Severity = NotificationSeverity.Error, Summary = $"Error", Detail = $"Unable to load Extracts"
});
}
}
public void DataList_Raises_LoadDataEventOnNextPageClick()
{
using var ctx = new TestContext();
var component = ctx.RenderComponent <RadzenDataList <int> >(parameterBuilder => parameterBuilder.Add <IEnumerable <int> >(p => p.Data, Enumerable.Range(0, 100)));
var raised = false;
LoadDataArgs newArgs = null;
component.SetParametersAndRender(parameters => {
parameters.Add <bool>(p => p.AllowPaging, true);
parameters.Add <LoadDataArgs>(p => p.LoadData, args => { raised = true; newArgs = args; });
});
component.Find(".rz-paginator-next").Click();
Assert.True(raised);
Assert.True(newArgs.Skip == 10);
Assert.True(newArgs.Top == 10);
}
