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