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