public GridViewPagingSortingViewModel()
{
CustomersDataSet = new GridViewDataSet <CustomerData>()
{
PageSize = 10
};
}
public GridViewSizableViewModel()
{
CustomersDataSet = new GridViewDataSet <CustomerData>()
{
PageSize = 10
};
}
public void FillAttendees(GridViewDataSet<AttendeeListItemDto> dataSet)
{
using (UnitOfWorkProvider.Create())
{
FillDataSet<AttendeeListItemDto>(dataSet, AttendeesQueryFunc());
}
}
public async Task RemoveCategory(GridViewDataSet <CategoryDTO> Categories)
{
AdminRepository AdminRep = new AdminRepository();
Categories.Items.Remove(this);
await AdminRep.RemoveCategoryAsync(Id);
}
public override Task Init()
{
// NOTE: You can also create the DataSet with factory.
// Just call static Create with delegate and pagesize.
Customers = GridViewDataSet.Create(gridViewDataSetLoadDelegate: GetData, pageSize: 4);
return(base.Init());
}
public NamePickerViewModel()
{
Members = new GridViewDataSet <MeetupMember>()
{
PageSize = 5
};
}
public override Task Init()
{
Customers = new GridViewDataSet <Customer> {
OnLoadingData = GetData
};
Customers.SetSortExpression(nameof(Customer.Id));
UserSettings = new GridViewUserSettings {
EnableUserSettings = true,
ColumnsSettings = new List <GridViewColumnSetting> {
new GridViewColumnSetting {
ColumnName = "CustomerId",
DisplayOrder = 0,
ColumnWidth = 50
},
new GridViewColumnSetting {
ColumnName = "CustomerName",
DisplayOrder = 1,
ColumnWidth = 400
},
new GridViewColumnSetting {
ColumnName = "CustomerBirthdate",
DisplayOrder = 2
},
new GridViewColumnSetting {
ColumnName = "CustomerOrders",
DisplayOrder = 3
}
}
};
return(base.Init());
}
public void FillAttendees(GridViewDataSet <AttendeeListItemDto> dataSet)
{
using (UnitOfWorkProvider.Create())
{
FillDataSet <AttendeeListItemDto>(dataSet, AttendeesQueryFunc());
}
}
/// <summary>
/// Loads all groups in the specified dataset.
/// </summary>
public void LoadGroups(GridViewDataSet <GroupData> dataSet)
{
var groups = db.Groups
.Select(ToGroupData);
dataSet.LoadFromQueryable(groups);
}
public override Task Init()
{
Customers = new GridViewDataSet <CustomerData>()
{
OnLoadingData = GetData
};
}
public GridViewStaticCommandViewModel()
{
CustomersDataSet = new GridViewDataSet <CustomerData>()
{
PageSize = 10
};
}
public override Task PreRender()
{
if (!Context.IsPostBack)
{
Children = new List<BindingContextChildViewModel>()
{
new BindingContextChildViewModel()
{
Children = new List<BindingContextChildViewModel>()
{
new BindingContextChildViewModel()
{
Children = new List<BindingContextChildViewModel>()
{
new BindingContextChildViewModel()
{
Children = new List<BindingContextChildViewModel>()
}
}
}
}
}
};
ChildrenDataSet = new GridViewDataSet<string>
{
Items = new List<string>() { "test" },
TotalItemsCount = 1
};
}
return base.PreRender();
}
/// <summary>
/// Gets the user profile.
/// </summary>
public void LoadUserInfos(GridViewDataSet <UserInfoData> dataSet)
{
var users = db.Users
.Select(ToUserInfoData);
dataSet.LoadFromQueryable(users);
}
public void LoadForumThreads(GridViewDataSet <ForumThreadDTO> dataSet)
{
var query = dc.ForumThreads
.OrderByDescending(t => t.CreatedDate)
.Select(t => new ForumThreadDTO()
{
Id = t.Id,
Title = t.Title,
FirstPostMessage = t.ForumPosts
.OrderBy(p => p.Id)
.FirstOrDefault().Message,
CreatedDate = t.CreatedDate,
PostsCount = t.ForumPosts.Count,
LastPostUserName = t.ForumPosts
.OrderByDescending(p => p.Id)
.Select(p => p.AppUser.UserName)
.FirstOrDefault(),
LastPostDate = t.ForumPosts
.OrderByDescending(p => p.Id)
.FirstOrDefault()
.CreatedDate,
});
dataSet.LoadFromQueryable(query);
}
public ColumnVisibleViewModel()
{
CustomersDataSet = new GridViewDataSet <CustomerData>()
{
PageSize = 10
};
}
public GridViewDataSetViewModel()
{
GridData = new GridViewDataSet <GridViewData>()
{
PageSize = 20
};
}
public override Task Init()
{
Customers = new GridViewDataSet <Customer>()
{
OnLoadingData = GetData
};
return(base.Init());
}
public void LoadList(GridViewDataSet <TListDTO> resultDataSet, TQueryFilter filter)
{
using (UnitOfWorkProvider.Create())
{
var query = CreateQuery(filter);
FillDataSet(resultDataSet, query);
}
}
public void FillDataSet <T>(GridViewDataSet <T> dataset, IQueryable <T> query, Guid investigationId)
{
using (var uow = this.UnitOfWorkProvider.Create(investigationId))
{
dataset.PagingOptions.TotalItemsCount = query.Count();
dataset.Items = query.Skip(dataset.PagingOptions.PageIndex * dataset.PagingOptions.PageSize).Take(dataset.PagingOptions.PageSize).ToList();
}
}
public async Task RemoveVideo(GridViewDataSet <VideoListAdminDTO> Videos)
{
AdminRepository AdminRep = new AdminRepository();
var deletedVideo = Videos.Items.Where(x => x.Id == Id).First();
Videos.Items.Remove(deletedVideo);
await AdminRep.RemoveVideoAsync(this.Id);
}
public void FillArchiveEvents(GridViewDataSet <PublicArchiveEventDTO> archiveEvents)
{
using (var uow = this.UnitOfWorkProvider.Create())
{
var q = this.ArchiveQueryFactory();
archiveEvents.LoadFromQuery(q);
}
}
public ViewModel()
{
// creates new GridViewDataSet and sets PageSize
Customers = new GridViewDataSet <Customer>()
{
PageSize = 4
};
}
public void FillAttachmentsOfEmail(GridViewDataSet <EmailAttachmentDTO> dataSet, Guid emailId)
{
var q = "SELECT * FROM MIMEparts WHERE MIMEpart_Id = '" + emailId + "'";
var attachments = this.unitOfWorkProvider.TryGetContext().Set <MIMEpart>().SqlQuery(q).ToList();
dataSet.PagingOptions.TotalItemsCount = attachments.Count();
dataSet.Items = attachments.Skip(dataSet.PagingOptions.PageIndex * dataSet.PagingOptions.PageSize)
.Take(dataSet.PagingOptions.PageSize).ToList().AsQueryable().ProjectTo <EmailAttachmentDTO>().ToList();
}
public void InitModal()
{
IsModalVisible = true;
Users = new GridViewDataSet <User>
{
PagingOptions = { PageSize = DefaultPageSize }
};
Users.RequestRefresh();
}
public void FillCallStreamOfCall(GridViewDataSet <ExportCallStreamDTO> dataSet, IEnumerable <string> rtpAddress)
{
// Base Query
var query = this.unitOfWorkProvider.TryGetContext().Set <SnooperExportedObjectBase>().Where(e => rtpAddress.Contains(e.SourceEndpointString) && rtpAddress.Contains(e.DestinationEndpointString)).ToList().OfType <ICallStream>().ToList().AsQueryable();
dataSet.PagingOptions.TotalItemsCount = query.Count();
dataSet.Items = query.Skip(dataSet.PagingOptions.PageIndex * dataSet.PagingOptions.PageSize)
.Take(dataSet.PagingOptions.PageSize).ToList().AsQueryable().ProjectTo <ExportCallStreamDTO>().ToList();
}
/// <summary>
/// Loads all groups in the specified dataset.
/// </summary>
public static void LoadGroups(GridViewDataSet <GroupData> dataSet)
{
using (var db = new AppContext())
{
var groups = db.Groups
.Select(ToGroupData);
dataSet.LoadFromQueryable(groups);
}
}
public override Task Init()
{
Customers = new GridViewDataSet <Customer> {
OnLoadingData = GetData
};
Customers.SetSortExpression(nameof(Customer.Id));
return(base.Init());
}
public GridViewInlineEditingPrimaryKeyGuidViewModel()
{
CustomersDataSet = new GridViewDataSet <CustomerDataGuid>()
{
PageSize = 10
};
CustomersDataSet.PrimaryKeyPropertyName = "CustomerId";
CustomersDataSet.EditRowId = EditRowId;
}
/// <summary>
/// Loads all payments in the specified group.
/// </summary>
public void LoadPayments(int groupId, GridViewDataSet <PaymentData> dataSet)
{
var payments = db.Payments
.Where(p => p.GroupId == groupId && !p.IsDeleted)
.Select(ToPaymentData);
// This handles sorting and paging for you. Just give the IQueryable<T> into the dataSet's LoadFromQueryable method
dataSet.LoadFromQueryable(payments);
}
public static void LoadProduct(GridViewDataSet <Product> dataset)
{
using (var db = new Database())
{
var query = from p in db.Products
select p;
dataset.LoadFromQueryable(query);
}
}
public static void LoadUser(GridViewDataSet <User> dataset)
{
using (var db = new Database())
{
var query = from p in db.Users
select p;
dataset.LoadFromQueryable(query);
}
}
public AdminViewModel(IOptionsSnapshot <AppSettings> appSettings) : base(appSettings)
{
Data = new GridViewDataSet <T>
{
RowEditOptions = { PrimaryKeyPropertyName = nameof(IIdentifiable.Id) },
PagingOptions = { PageSize = _appSettings.PageSize },
SortingOptions = { SortExpression = nameof(IAdminLookup.Name),
SortDescending = true }
};
}
public GridViewInlineEditingViewModel()
{
CustomersDataSet = new GridViewDataSet<CustomerData>() { PageSize = 10 };
CustomersDataSet.PrimaryKeyPropertyName = "CustomerId";
CustomersDataSet.EditRowId = EditRowId;
}
public GridViewDataSetViewModel()
{
GridData = new GridViewDataSet<GridViewData>() { PageSize = 20 };
}
public GridViewRowDecoratorsViewModel()
{
CustomersDataSet = new GridViewDataSet<CustomerData>() { PageSize = 10 };
CustomersDataSet2 = new GridViewDataSet<CustomerData>() { PageSize = 10, EditRowId = 2, PrimaryKeyPropertyName = "CustomerId" };
}
public Sample16ViewModel()
{
CustomersDataSet = new GridViewDataSet<CustomerData>() { PageSize = 10 };
}
public GridViewStaticCommandViewModel()
{
CustomersDataSet = new GridViewDataSet<CustomerData>() { PageSize = 10 };
}
public GridViewSizableViewModel()
{
CustomersDataSet = new GridViewDataSet<CustomerData>() { PageSize = 10 };
}
