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);
}
/// <summary>
/// Gets the user profile.
/// </summary>
public void LoadUserInfos(GridViewDataSet <UserInfoData> dataSet)
{
var users = db.Users
.Select(ToUserInfoData);
dataSet.LoadFromQueryable(users);
}
/// <summary>
/// Loads all groups in the specified dataset.
/// </summary>
public void LoadGroups(GridViewDataSet <GroupData> dataSet)
{
var groups = db.Groups
.Select(ToGroupData);
dataSet.LoadFromQueryable(groups);
}
/// <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 static void LoadUser(GridViewDataSet <User> dataset)
{
using (var db = new Database())
{
var query = from p in db.Users
select p;
dataset.LoadFromQueryable(query);
}
}
public static void LoadProduct(GridViewDataSet <Product> dataset)
{
using (var db = new Database())
{
var query = from p in db.Products
select p;
dataset.LoadFromQueryable(query);
}
}
/// <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 LoadUser(GridViewDataSet <User> Users)
{
using (var db = new DatabaseBlog())
{
db.Configuration.LazyLoadingEnabled = false;
var query = from p in db.Users
select p;
Users.LoadFromQueryable(query);
}
}
/// <summary>
/// Gets the user profile.
/// </summary>
public static void LoadUserInfos(GridViewDataSet <UserInfoData> dataSet)
{
using (var db = new AppContext())
{
var users = db.Users
.Select(ToUserInfoData);
dataSet.LoadFromQueryable(users);
}
}
public static void LoadOrders(GridViewDataSet <Order> dataset)
{
using (var db = new Database())
{
db.Configuration.LazyLoadingEnabled = false;
var query = from p in db.Orders
select p;
dataset.LoadFromQueryable(query);
}
}
public void LoadMyTransactions(int userId, GridViewDataSet <MyTransactionData> dataSet)
{
var payments = db.Payments
.Where(p => !p.IsDeleted && p.Transactions.Any(t => t.UserId == userId))
.OrderByDescending(p => p.CreatedDate)
.Select(ToMyTransactionData(userId));
// This handles sorting and paging for you. Just give the IQueryable<T> into the dataSet's LoadFromQueryable method
dataSet.LoadFromQueryable(payments);
}
public void LoadAllPaymentLogs(GridViewDataSet <PaymentLogData> dataSet, List <LogType> allowedLogTypes)
{
var payments = db.PaymentLogs
.Where(p => allowedLogTypes.Contains(p.LogType))
.OrderByDescending(p => p.CreatedDate)
.Select(ToPaymentLogData());
// This handles sorting and paging for you. Just give the IQueryable<T> into the dataSet's LoadFromQueryable method
dataSet.LoadFromQueryable(payments);
}
public static void LoadPost(GridViewDataSet <Post> dataset)
{
using (var db = new DatabaseBlog())
{
db.Configuration.LazyLoadingEnabled = false;
var query = from p in db.Posts
select p;
dataset.LoadFromQueryable(query);
}
}
public static void LoadItemOrder(GridViewDataSet <OrderItem> dataset, int id)
{
using (var db = new Database())
{
var order = db.Orders.Find(id);
var query = from p in db.OrderItems
where p.OrderID == order.OrderID
select p;
dataset.LoadFromQueryable(query);
}
}
public static void LoadDataCart(GridViewDataSet <CartItem> dataset)
{
using (var db = new Database())
{
var user = db.Users.Find(Convert.ToInt32(UserService.GetCurrentUserId()));
var load = from p in db.CartItems
where p.CartID == user.CartID
select p;
dataset.LoadFromQueryable(load);
}
}
/// <summary>
/// Loads all payments in the specified group.
/// </summary>
public static void LoadPayments(int groupId, GridViewDataSet <PaymentData> dataSet)
{
using (var db = new AppContext())
{
var payments = db.Payments
.Where(pg => pg.GroupId == groupId)
.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 LoadOtherPost(int userid, GridViewDataSet <Post> dataset)
{
using (var db = new DatabaseBlog())
{
db.Configuration.LazyLoadingEnabled = false;
var query = from p in db.Posts
where p.UserID == userid
select p;
dataset.LoadFromQueryable(query);
}
}
public static void LoadImportantPost(GridViewDataSet <Post> dataset)
{
using (var db = new DatabaseBlog())
{
db.Configuration.LazyLoadingEnabled = false;
var query = from p in db.Posts
where p.Category == PostCategory.AdminPost
select p;
dataset.LoadFromQueryable(query);
}
}
public GridViewDataSet <Company <string> > GetWithPaging([FromUri, AsObject(typeof(IPagingOptions))] PagingOptions pagingOptions)
{
lock (Database.Instance)
{
var dataSet = new GridViewDataSet <Company <string> >()
{
PagingOptions = pagingOptions
};
dataSet.LoadFromQueryable(Database.Instance.Companies.AsQueryable());
return(dataSet);
}
}
public GridViewDataSet <Company <bool> > GetWithSorting([FromUri, AsObject(typeof(ISortingOptions))] SortingOptions sortingOptions)
{
lock (Database.Instance)
{
var dataSet = new GridViewDataSet <Company <bool> >()
{
SortingOptions = sortingOptions
};
dataSet.LoadFromQueryable(Database.Instance.Companies2.AsQueryable());
return(dataSet);
}
}
public static void LoadMyPaymentLog(int userId, GridViewDataSet <PaymentLogData> dataSet, List <LogType> allowedLogTypes)
{
using (var db = new AppContext())
{
var payments = db.PaymentLogs
.Where(p => p.UserId == userId && allowedLogTypes.Contains(p.LogType))
.OrderByDescending(p => p.CreatedDate)
.Select(ToPaymentLogData());
// This handles sorting and paging for you. Just give the IQueryable<T> into the dataSet's LoadFromQueryable method
dataSet.LoadFromQueryable(payments);
}
}
public GridViewDataSet <Company> GetWithSortingAndPaging([FromQuery, AsObject(typeof(ISortingOptions))] SortingOptions sortingOptions, [FromQuery, AsObject(typeof(IPagingOptions))] PagingOptions pagingOptions)
{
lock (Database.Instance)
{
var dataSet = new GridViewDataSet <Company>()
{
PagingOptions = pagingOptions,
SortingOptions = sortingOptions
};
dataSet.LoadFromQueryable(Database.Instance.Companies.AsQueryable());
return(dataSet);
}
}
public static void LoadMyPost(GridViewDataSet <Post> dataset)
{
var userid = Convert.ToInt32(UserService.GetCurrentUserId());
using (var db = new DatabaseBlog())
{
db.Configuration.LazyLoadingEnabled = false;
var query = from p in db.Posts
where p.UserID == userid
select p;
dataset.LoadFromQueryable(query);
}
}
public static void LoadMyOrders(GridViewDataSet <Order> dataset) // Load The Orders For The USER not for The ADMINPAGE.
{
using (var db = new Database())
{
db.Configuration.LazyLoadingEnabled = false;
var user = db.Users.Find(UserService.GetCurrentUserId());
int userid = Convert.ToInt32(UserService.GetCurrentUserId());
var query = from p in db.Orders
where p.UserID == userid
orderby p.OrderDate
select p;
dataset.LoadFromQueryable(query);
}
}
public void LoadForumPosts(int forumThreadId, GridViewDataSet <ForumPostDTO> dataSet)
{
var query = dc.ForumPosts
.Where(p => p.ForumThreadId == forumThreadId)
.OrderBy(p => p.CreatedDate)
.Select(p => new ForumPostDTO()
{
Id = p.Id,
CreatedDate = p.CreatedDate,
Message = p.Message,
AppUserId = p.AppUserId,
AppUserName = p.AppUser.UserName,
AppUserNumberOfPosts = p.AppUser.ForumPosts.Count
});
dataSet.LoadFromQueryable(query);
}
public static void LoadComments(int postid, GridViewDataSet <Comment> dataset)
{
using (var db = new DatabaseBlog())
{
var query = from p in db.Comments
where p.PostID == postid
select p;
foreach (var item in query)
{
if (item.UserID == UserService.GetCurrentUserId())
{
item.Delete = true;
}
else
{
item.Delete = false;
}
}
dataset.LoadFromQueryable(query);
}
}
public void LoadProducts(GridViewDataSet <ProductListDTO> dataSet)
{
// get products
IQueryable <Products> query = dbContext.Products;
// select columns displayed in grid
var result = query.Select(p => new ProductListDTO()
{
Id = p.Id,
Name = p.ProductName,
Category = p.Category.CategoryName,
Supplier = p.Supplier.CompanyName,
QuantityPerUnit = p.QuantityPerUnit,
UnitsInStock = p.UnitsInStock,
UnitsOnOrder = p.UnitsOnOrder,
UnitPrice = p.UnitPrice,
Discontinued = p.Discontinued,
ReorderLevel = p.ReorderLevel
});
// apply paging and sorting
dataSet.LoadFromQueryable(result);
}
public void LoadProducts(GridViewDataSet <ProductListDTO> dataSet, ProductFilterDTO filter)
{
// get products
IQueryable <Products> query = dbContext.Products;
// apply filters
if (!string.IsNullOrEmpty(filter.SearchText))
{
query = query.Where(p => p.ProductName.Contains(filter.SearchText));
}
if (!filter.AllowDiscontinued)
{
query = query.Where(p => !p.Discontinued);
}
if (filter.CategoryId != null)
{
query = query.Where(p => p.CategoryId == filter.CategoryId);
}
// select columns displayed in grid
var result = query.Select(p => new ProductListDTO()
{
Id = p.Id,
Name = p.ProductName,
Category = p.Category.CategoryName,
Supplier = p.Supplier.CompanyName,
QuantityPerUnit = p.QuantityPerUnit,
UnitsInStock = p.UnitsInStock,
UnitsOnOrder = p.UnitsOnOrder,
UnitPrice = p.UnitPrice,
Discontinued = p.Discontinued,
ReorderLevel = p.ReorderLevel
});
// apply paging and sorting
dataSet.LoadFromQueryable(result);
}
public void LoadTasksDataSet(GridViewDataSet <Task> projects)
{
projects.LoadFromQueryable(FakeDatabase.Tasks.AsQueryable());
}
public void LoadUsersDataSet(GridViewDataSet <User> projects)
{
projects.LoadFromQueryable(FakeDatabase.Users.AsQueryable());
}
