.Net library for clever processing of requests from datatables.net jQuery plugin on the server side (ASP.NET, Nancy or any other web server). It dynamically builds an expression tree from the request and allows to filter and sort an IQueryable according to the request parameters.
A .NET library for generating Time-Sorted Unique Identifiers (TSID).
The basic idea: each time we add one or more promises to an instance of a promiseTracker, that instance's active() method will return true until all added promises are resolved. A common use case is showing some sort of loading spinner while some http requests are loading.
Search Workflows, Dialogs, Business Process Flows, Actions, and Business Rules using In Memory Data and an excell like grid with it's own search features. • Search processes for Entities that are updated, created, assigned, status changed by a process • Search processes for Properties that are updated or created by a process • Search processes for text contained in a step comment. • Search processes for text contained in a condition value. • Child Processes Search processes that call a specific child process Grid features • Grouping and Sub Grouping • Excel like Filtering • Multi Column Sorting • Double click to open the Process
A framework to handle all sorts of paths operations: File, Directory, Absolute, Drive Letter, UNC, Relative, prefixed with an Environment Variable, that contain a Variable. This framework is used in the product NDepend to handle all paths operations.
Easy filtering, sorting and paging for ASP.NET Core.
CollectionView provides Xamarin.Android support for data features like sorting, grouping and filtering with the RecyclerView control. It enables support for advanced features such as pull-to-refresh and incremental, on-demand loading.
Build dynamic LINQ filters from strings or structured objects, with sorting and pagination for .NET applications.
This is a fork of the dlinq-helpers project. Add server paging, filtering and sorting via Dynamic Linq to Asp.Net Core projects. Support Take, Skip, Sort, Filter, and Aggregate query parameters via QueryableExtensions class.
Easy filtering, sorting and paging for ASP.NET Core.
CollectionView provides Xamarin.iOS support for data features like sorting, grouping and filtering with the UITableView and UICollectionView controls. It enables support for advanced features such as pull-to-refresh and incremental, on-demand loading.
Library for controlling windows, monitors, input, etc... WinUtilities is a small wrapper project that wraps Windows API functions to make Windows automation easy. The wrapper contains some user32, gdi32 etc... API calls as well as structs and enums that were necessary while implementing the features of the project. This means it does not contain all of the functions of those APIs. The wrapper is mainly centered around the Window class, since in Windows automation there is very often a window that is the target of some sort of action. The project is only tested to work on Windows 10, but it should work on earlier versions as well. The project is also still under development so later versions can contain breaking changes.
The basic extension package contains the creation information, modification information, RowVersion and other basic properties of the entity, and realizes the paging sort Request and the agreed HTTP Request structure, the extension of the delayed query condition method, the extension of the list and the extension of the single object shaping.
Sieve is a simple, clean, and extensible framework for .NET Core that adds sorting, filtering, and pagination functionality out of the box. Most common use case would be for serving ASP.NET Core GET queries. Documentation available on GitHub: https://github.com/Biarity/Sieve/
System.Data.IDbConnection cnn ; var res0 = cnn.Find<GoodsInfo>().Take1().Ex(); var res5 = cnn.Find<GoodsInfo>().Take(100).Ex(); var res4 = cnn.Find<GoodsInfo>(o => o.GoodsId == 1).Ex(); var res3 = cnn.Find<GoodsInfo>().Sort(o => o.UpdateTime).Take1().Ex(); var res2 = cnn.Find<GoodsInfo>().Sort(o => o.UpdateTime).Take(10).Skip(10).Ex(); var res1 = cnn.Find<GoodsInfo>(o => o.GoodsId == 1).Sort(o => o.UpdateTime).Take(10).Skip(10).Ex(); var res6 = cnn.Find<GoodsInfo>(o => o.GoodsId == 1).Sort(o => o.UpdateTime, EOrderBy.Asc).Take(10).Skip(10).Ex();
Enhancements and utility classes for primitive types and some commonly used types in the mscorlib and System.Core libraries. Extension methods are available for string, DateTime, enum, StringBuilder, SecureString, RegEx, event handlers, random, array, Enumberable, IList, collections, stream and various derivatives. Utility classes include the SortUtility class for topological sorting, the Assert class for argument validation, and FastConvert class for performance optimized serialization between various primitive types and string. Also include various utility classes for DateTime, enum, HTTP, mathematics, random and string. A ConcurrentSortedList generic collection type is implemented in this library, which expands on the SortedList type to support multi-threading.
Easy filtering, sorting and paging for ASP.NET Core.
Self-containing DataTable classes for the datatables.net jQuery plugin that manage rendering, querying, filtering, sorting and other desireable tasks for the user.
AbsolutePosition, Access, AddRemove, Affinity, CaseType, CompanySuffix, Compass, Connectivity, ContractType, Country, DatabaseOperation, DataType, DateTimeType, Degree, Diagnostic, Direction, Emotion, Emotion2, Execution, Family, Female, Flux, Frequency, General, ListOrdinal, Location, Male, MarketType, MicrosoftOffice, Movement, OrderOfMagnitude, Orientation, PlaceAndMovement, Possession, PriceSide, PriceSource, ProcessState, Progress, Quality, Quantity, Quantity2, RadialDirection, Rainbow, Region, Resolution, Scale, Side, Sign, Size, Sort, Speed, Speed, Sport, Status, Switch, Tense, Threat, ThreeWayBetType, ThreeWayOutCome, TimeFraction, TimeInterval, TradeSide, TransactionSide, Urgency, Weather, YesNo enums. Names Attribute(and helper methods) to match strings to enums and CountryInfo attribute(and helper methods) to match strings to countries and provide country information.
Transforms the given SQL query according to the commands provided in this request. You can add constraints, hide some of the resultset columns, chang sorting or limit rows of resultset. All transformations are performed according to the SQL syntax and database schema provided through the registered account at https://webapi.activequerybuilder.com/ identified by the given unique identifier. All transformations can only lead to reorganization or limitation of the resultset data. This means that it's impossible to get transformed SQL that reveals any other data than the data retutned by original query.
Easy filtering, sorting and paging for ASP.NET Core.
PaginationSortingFiltering is a dynamic filtering, sorting, pagination of different types of data sources. Component suports sorting by one column, filtering and selecting multiple columns.
Spreadsheet .NET is a Microsoft Excel compatible library for .NET. It lets you create, read, modify and parse Excel workbooks programmatically — worksheets, cells and cell value types, formulas, defined names, rich text, merged cells and comments, number formats, fonts, borders, fill colors and alignment, conditional formatting, data validation, sorting, AutoFilter, grouping, tables and pivot tables, hyperlinks, images, text boxes and form controls, charts, freeze panes, print areas and page setup, and worksheet and workbook protection. It reads and writes Microsoft Excel .xlsx and .xls documents, imports and exports CSV, and exports to HTML and plain text. The library does not require Microsoft Excel to be installed or any other third party application to work.
Node based compilers of all sorts for Node Assets
Sorts Span<T> (and arrays) more quickly than System.Array.Sort
DataCollection provides .Net Android support for data features like sorting, grouping and filtering with the RecyclerView and ListView controls. It enables support for advanced features such as pull-to-refresh and incremental, on-demand loading.
DataCollection provides .Net iOS support for data features like sorting, grouping and filtering with the UITableView and UICollectionView controls. It enables support for advanced features such as pull-to-refresh and incremental, on-demand loading.
A data grid to display the data retrieved from webapi or a rest service. The grid will display data for any entity.You just need to call the GetValues method on html table as: $("tblEmployees").GetValues(({ URL: "/api/values1/",IdColumn: "RollNo"}); .URL is the URL of the REST service.IdColumn is the column that uniquely identifies an entity To use the grid and display the data on a page 1.include the follwing js and css in the web page script src="../Scripts/WebGrid.js" type="text/javascript" link href="../Content/GridStyle.css" rel="stylesheet" Grid control also uses jquery ,so also reference the jquery library on the page. 2.Declare html table on the page 3.Call the GetValues method on the declared table $("IdOfTable").GetValues({ URL: "/api/ControllerName/", IdColumn: "NameofPrimaryKeyColumn" 4.Add the following attribute to the Controller class WebGrid.PagingAttribute(EntityId = "AnyIdentifier", PageSize = SizeOfPage, EntityType = typeof(TypeOfEntity) 5.Derive the controller class from the CustomController class. You can also sort the displayed data by clicking the grid column headers
Data grid component for Blazor. Sorting, paging, editing, deleting. Filter. Row single and multiple selection. Cell show/edit templating. Row edit templating.
The SortedPRO SDK Service Availability data types for .NET Standard
The SortedPRO SDK Consignments data types for .NET Standard
Microsoft.AspNetCore.Mvc.NewtonsoftJson services.AddControllers().AddNewtonsoftJson(o => o.SerializerSettings.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore); Dotnet controller [FromQuery] ?sort=asc using var transaction = Context.Database.BeginTransaction(); bike.Id = id; var c = await Context.Bikes.FindAsync(id); Context.Bikes.Remove(c); Context.Bikes.Add(bike); await Context.SaveChangesAsync(); await transaction.CommitAsync(); var startedRental = await Context.Rentals.FirstAsync(); startedRental.End = System.DateTime.Now; startedRental.TotalCosts = CostCalculation.CalculateTotalCost(startedRental); startedRental.Customer = await Context.Customers.FindAsync(rental.CustomerID); startedRental.Bike = await Context.Bikes.FindAsync(rental.BikeID); Context.Rentals.Update(startedRental); await Context.SaveChangesAsync(); var result=await unpaid .Include(c => c.Customer) .Select(item => new { item.CustomerID, item.Customer.LastName, item.Customer.FirstName, item.Id, item.Begin, item.End }) .ToListAsync(); return (await dataContext.Deposits.Include("Membership.Member").ToArrayAsync()) .GroupBy(d => new { d.Membership.Begin.Year, d.Membership.Member }) .Select(i => new DepositStatistics { Year = i.Key.Year, Member = i.Key.Member, TotalAmount = i.Sum(d => d.Amount) }); using var transaction = Database.BeginTransaction(); await Database.ExecuteSqlRawAsync("DELETE FROM Taxis"); await Database.ExecuteSqlRawAsync("DELETE FROM Drivers"); await Database.ExecuteSqlRawAsync("DELETE FROM Rides"); await transaction.CommitAsync(); var result = await Rides.Where(e => e.Start.Year == year and e.Start.Month == month).ToListAsync(); var drivers=result.GroupBy(d => d.Driver); var ret=drivers.Select(b => new DriverStatistics { DriverName = b.Key.Name, TotalCharge = b.Sum(d => d.Charge) ?? 0 }); public async Task T> GetFromServiceAsync T>(string path) { var response = await client.GetStringAsync(BASE_URL + path); return JsonSerializer.Deserialize T>(response, new JsonSerializerOptions { PropertyNameCaseInsensitive = true }); } public async Task HttpResponseMessage> PostToServiceAsync T>(string path, T payload ) { var body = new StringContent(JsonSerializer.Serialize T>(payload), Encoding.UTF8, "application/json"); var response = await client.PostAsync(BASE_URL + path,body); return response; } WPF GUI BindableBase Customers customers = new Customers(Customer, client); customers.Show(); MainWindow.Close.Execute(); ComboBox ItemsSource="{Binding Taxis}" DisplayMemberPath="LicensePlate" SelectedItem="{Binding SelectedTaxi}" /> UpdateSourceTrigger=PropertyChanged DataGrid Name="TaskTable" ItemsSource="{Binding Tasks}" RowEditEnding="TaskTable_RowEditEnding" AutoGenerateColumns="False" > DataGrid.Columns> DataGridTextColumn Header="TaskId" Binding="{Binding TaskId, UpdateSourceTrigger=LostFocus}"/> public async void TaskTable_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e) { var task = e.Row.Item as Task; await GetTasks(); if (task != null and task.Name == String.Empty) { var result = await client.DeleteToServiceAsync("Tasks/" + task.TaskId); MessageBox.Show("DELETE" + result.StatusCode.ToString()); } else if (Tasks.Any(b => b.TaskId == task.TaskId)) { var result = await client.PutToServiceAsync("Tasks/" +task.TaskId, task); MessageBox.Show("EDIT" + result.StatusCode.ToString()); } else { var result = await client.PostToServiceAsync("Tasks" , task); MessageBox.Show("ADD" + result.StatusCode.ToString()); } await GetTasks(); }
A container that creates and then (optionally) stores variables to provide caching and centralized access. These sorts of containers are sometimes mis-described as IOC ("Inversion of Control") Containers. Since they do not provide any control over program flow, the accurate term is DI ("Dependency Injection") Container. The SmartDI Container is unique in that it: * Does not store instantiated objects unnecessarily. * Supports object life-cycle management. When an object dies, it is removed from the container. This requires you to raise a global message. * Supports simple register-and-resolve so types do not need to be registered in advance.
It enables you to make dynamic filtered, sorted and paged IQueryables easily with .Filter() Extension Method. check out "Project Site" on Github for more details.
SlapKit.Excel is a robust .NET library for creating and manipulating Excel 2007+ files (.xlsx, .xlsm). SlapKit.Excel is an upgrade to the mature and time-tested ClosedXML library adding the features ClosedXML misses the most. Most notably SlapKit.Excel adds full support for charts, sorting and filtering to ClosedXML. It also adds various styling features typical for commercial Excel libraries. SlapKit.Excel maintains full API compatibility with the ClosedXML library. Thus projects using ClosedXML can replace it with SLapKit.Excel without any code changes. Dive into the world of Excel operations without the intricacies of the OpenXML API. Experience an intuitive and user-centric interface designed to simplify reading, manipulating, and writing Excel data. Elevate your Excel game with SlapKit.Excel!