public AdminDashboardHelper GetVendorDashBoardDetail(int AdminId) { Administrators _admin = null; _admin = context.Administrator.Where(m => m.Administrators_Id == AdminId).FirstOrDefault();; AdminDashboardHelper hlprAdminDashboard = new AdminDashboardHelper(); List <Product> _products = context.Product.Where(m => m.Store_Id == _admin.Store_Id).ToList(); hlprAdminDashboard.TotalAdministrator = context.Administrator.ToList().Where(m => m.Store_Id == _admin.Store_Id).Count(); hlprAdminDashboard.TotalInvitation = context.Invitation.ToList().Where(m => m.Store_Id == _admin.Store_Id).Count(); hlprAdminDashboard.TotalPendingInvitation = context.Invitation.ToList().Where(m => m.Invitation_Status == eStatus.InActive.ToString() && m.Store_Id == _admin.Store_Id).Count(); hlprAdminDashboard.TotalCategory = context.Category.ToList().Count(); hlprAdminDashboard.TotalSubCategory = context.SubCategory.ToList().Count(); hlprAdminDashboard.TotalProducts = _products.Count(); hlprAdminDashboard.TotalOrders = _products.Count(); hlprAdminDashboard.TotalProductsPendingForReview = _products.Where(m => m.Product_Status == eProductStatus.ReviewPending.ToString()).Count(); hlprAdminDashboard.TotalProductsPendingForApprove = _products.Where(m => m.Product_Status == eProductStatus.ApprovePending.ToString()).Count(); hlprAdminDashboard.TotalProductsPendingForPublish = _products.Where(m => m.Product_Status == eProductStatus.PublishPending.ToString()).Count(); hlprAdminDashboard.TotalProductsPublished = _products.Where(m => m.Product_Status == eProductStatus.Published.ToString()).Count(); hlprAdminDashboard.TotalProductsRejected = _products.Where(m => m.Product_Status == eProductStatus.Rejected.ToString()).Count(); hlprAdminDashboard.TotalItemsInCart = bCarts.List().ToList().Where(m => m.Store_Id == _admin.Store_Id).Count(); hlprAdminDashboard.prdQtyFlagActive = (_products.Where(m => m.Product_Qty_Alert >= m.Product_Qty && m.Store_Id == _admin.Store_Id).ToList().Count > 0) ? 1 : 0; return(hlprAdminDashboard); }
public AdminDashboardHelper GetDashBoardDetail(int adminId) { AdminDashboardHelper hlprAdminDashboard = new AdminDashboardHelper(); List <Product> _products = context.Product.Include("SubCategory").Include("ProductBanner").Include("Admin").Include("Store").ToList(); if (_products.Count > 0) { foreach (var item in _products) { item.SubCategory.Category = context.Category.Where(m => m.Category_Id == item.SubCategory.Category_Id).FirstOrDefault(); } } hlprAdminDashboard.TotalStores = context.Store.ToList().Count(); hlprAdminDashboard.TotalAdministrator = context.Administrator.ToList().Count(); hlprAdminDashboard.TotalInvitation = context.Invitation.ToList().Count(); hlprAdminDashboard.TotalPendingInvitation = context.Invitation.ToList().Where(m => m.Invitation_Status == eStatus.InActive.ToString()).Count(); hlprAdminDashboard.TotalCategory = context.Category.ToList().Count(); hlprAdminDashboard.TotalSubCategory = context.SubCategory.ToList().Count(); hlprAdminDashboard.TotalProducts = _products.Count(); hlprAdminDashboard.TotalOrders = _products.Count(); hlprAdminDashboard.TotalProductsPendingForReview = _products.Where(m => m.Product_Status == eProductStatus.ReviewPending.ToString()).Count(); hlprAdminDashboard.TotalProductsPendingForApprove = _products.Where(m => m.Product_Status == eProductStatus.ApprovePending.ToString()).Count(); hlprAdminDashboard.TotalProductsPendingForPublish = _products.Where(m => m.Product_Status == eProductStatus.PublishPending.ToString()).Count(); hlprAdminDashboard.TotalProductsPublished = _products.Where(m => m.Product_Status == eProductStatus.Published.ToString()).Count(); hlprAdminDashboard.TotalProductsRejected = _products.Where(m => m.Product_Status == eProductStatus.Rejected.ToString()).Count(); hlprAdminDashboard.TotalItemsInCart = bCarts.List().ToList().Count(); hlprAdminDashboard.TotalCustomer = context.Customer.ToList().Count(); hlprAdminDashboard.Administrators = context.Administrator.ToList().Where(m => m.Administrators_Id == adminId).FirstOrDefault(); hlprAdminDashboard.Invitations = context.Invitation.ToList(); hlprAdminDashboard.ProdPendForReview = _products.Where(m => m.Product_Status == eProductStatus.ReviewPending.ToString()).ToList(); hlprAdminDashboard.ProdPendForApprove = _products.Where(m => m.Product_Status == eProductStatus.ReviewCompleted.ToString()).ToList(); hlprAdminDashboard.ProdPendForPublish = _products.Where(m => m.Product_Status == eProductStatus.Approved.ToString()).ToList(); hlprAdminDashboard.CustomerRequest = context.CustomerRequest.Take(20).ToList(); hlprAdminDashboard.prdQtyFlagActive = (_products.Where(m => m.Product_Qty_Alert >= m.Product_Qty).ToList().Count > 0) ? 1 : 0; return(hlprAdminDashboard); }