// GET: Administrator // admin için index sayfası public ActionResult Index() { //customers var customers = _context.Customers.Include(c => c.MembershipTypes).OrderByDescending(c => c.Id).ToList(); //movies var movies = _context.Movies.Include(m => m.MovieGenres).OrderByDescending(m => m.DateAdded).ToList(); //users var users = _context.Users.OrderByDescending(u => u.Id).ToList(); //movies rented var moviesRented = _context.Movies.Sum(m => m.NoInStock - m.NumberAvailable); //user rentals int userRentals = _context.UserRentals.ToList().Count(); //view model var viewModel = new DashboardDataViewModel { Customers = customers, Movies = movies, Users = users, TotalRentals = userRentals }; return(View("Dashboard", viewModel)); }
public async Task <DashboardViewModel> CustomerDashboard() { try { DashboardViewModel data = new DashboardViewModel(); DashboardDataViewModel ddata = new DashboardDataViewModel(); var listOfJobs = await dbContext.tblVacancies.ToListAsync(); ddata.JobActiveList = listOfJobs.Select(x => new { Active = x.IsActive == true ? "Yes" : "No", ID = x.ID }).ToList().GroupBy(x => x.Active).Select(x => new DashboardChartDataViewModel { Name = x.Key, Count = x.Count() }).ToList(); ddata.JobStatusList = listOfJobs.GroupBy(x => x.tblJobVacanciesStatu.Name).Select(x => new DashboardChartDataViewModel { Name = x.Key, Count = x.Count() }).ToList(); ddata.CustomerJobsList = listOfJobs.GroupBy(x => x.tblCustomer.Name).Select(x => new DashboardChartDataViewModel { Name = x.Key, Count = x.Count() }).ToList(); ddata.JobsMonthList = listOfJobs.GroupBy(x => x.CreatedTimestamp.ToString("MMM")).Select(x => new DashboardChartDataViewModel { Name = x.Key, Count = x.Count() }).ToList(); ddata.CustomerMonthlyJobsList = (from list in listOfJobs group list by new { Month = list.CreatedTimestamp.ToString("MMM"), Name = list.tblCustomer.Name } into grp select new DashboardStackedChartDataViewModel { Month = grp.Key.Month, Name = grp.Key.Name, Count = grp.Count() }).ToList(); var SupplierJobs = await dbContext.tblVacancySuppliers.ToListAsync(); ddata.SupplierJobsList = SupplierJobs.GroupBy(x => x.tblSupplier.Name).Select(x => new DashboardChartDataViewModel { Name = x.Key, Count = x.Count() }).ToList(); ddata.SupplierMonthlyJobsList = (from list in SupplierJobs group list by new { Name = list.tblSupplier.Name, Month = list.CreatedTimestamp.ToString("MMM") } into grp select new DashboardStackedChartDataViewModel { Name = grp.Key.Name, Month = grp.Key.Month, Count = grp.Count() }).ToList(); var candidateSubmission = await dbContext.tblCandidateSubmissions.ToListAsync(); ddata.SubmissionMonthlyList = candidateSubmission.GroupBy(x => x.CreatedTimestamp.ToString("MMM")).Select(x => new DashboardChartDataViewModel { Name = x.Key, Count = x.Count() }).ToList(); data.ChartData = ddata; return(data); } catch (Exception ex) { throw ex; } }
public async Task <ActionResult> GetDashboardData() { var statistics = await _statisticsService.GetStatisticsAsync(); var result = new DashboardDataViewModel { Statistics = Mapper.Map <AllergoStatisticsViewModel>(statistics) }; return(Json(result)); }
// kiralanack filmler gözüküyor. public ActionResult RentalsManager() { //customer rentals var rentals = _context.NewRentals.Include(r => r.Customer).Include(r => r.Movie).ToList(); //user rentals kiracılar var userRentals = _context.UserRentals.Include(nr => nr.Movie).Include(nr => nr.Users).ToList(); var viewModel = new DashboardDataViewModel { UserRentals = userRentals, Rentals = rentals }; return(View("Rentals", viewModel)); }
public async Task <IActionResult> Index() { User user = await userManager.GetUserAsync(HttpContext.User); IEnumerable <Transaction> TransactionIncomes = transactionRepository.GetIncomes(user).Result; IEnumerable <Transaction> TransactionExpenses = transactionRepository.GetExpenses(user).Result; decimal incomesSume = TransactionIncomes.ToList().Sum(x => x.Amount); decimal expensesSume = TransactionExpenses.ToList().Sum(x => x.Amount); List <NotificationViewModel> notifications = new List <NotificationViewModel>(); notificationRepository.Notifications(user) .Result.ToList().ForEach(x => notifications .Add(new NotificationViewModel { Describe = x.Describe, ID = x.ID, Image = x.Image, Title = x.Title } )); DashboardDataViewModel dashboardDataViewModel = new DashboardDataViewModel { UserName = user.UserName, Avatar = user.AvatarLink, Email = user.Email, Notyfication = notifications, Finance = new Finance { Balance = incomesSume - expensesSume, Spendings = expensesSume, Incomes = incomesSume, Charts = new Charts { Incomes = GetChartsData(TransactionIncomes), Expenses = GetChartsData(TransactionExpenses) } } }; return(Json(dashboardDataViewModel)); }
public async Task <List <DashboardDataViewModel> > GetSummary(string id, int status) { var results = new List <DashboardDataViewModel>(); var region = await dbContext.Set <Region>().FirstAsync(r => r.Id == id); var children = await dbContext.Set <Region>() .Where(r => r.FkParentId == id) .OrderBy(x => x.Name) .ToListAsync(); if (children.Count == 0) { children.Add(region); } var toraObjects = from objects in dbContext.Set <ToraObject>() join desa in dbContext.Set <Region>() on objects.FkRegionId equals desa.Id join kec in dbContext.Set <Region>() on desa.FkParentId equals kec.Id join kab in dbContext.Set <Region>() on kec.FkParentId equals kab.Id where objects.FkRegionId.StartsWith(id) group objects by region.Type == RegionType.Kabupaten ? kec.Id : desa.Id into r select new { Data = r }; foreach (var toraObject in toraObjects) { var toraObjectIds = toraObject.Data.Where(x => (int)x.Status == status).Select(t => t.Id); var totalToraSubjects = await dbContext.Set <ToraSubject>() .Where(ts => toraObjectIds.Contains(ts.FkToraObjectId)) .CountAsync(); var dashboardData = new DashboardDataViewModel { Region = children.First(c => c.Id == toraObject.Data.Key), TotalSize = toraObject.Data.Where(x => (int)x.Status == status).Sum(t => t.Size), TotalToraObjects = toraObject.Data.Where(x => (int)x.Status == status).Count(), TotalToraSubjects = totalToraSubjects, TotalProposedObjects = toraObject.Data.Where(x => (int)x.Status == 0).Count(), TotalVerifiedObjects = toraObject.Data.Where(x => (int)x.Status == 1).Count(), TotalActualizedObjects = toraObject.Data.Where(x => (int)x.Status == 2).Count(), TotalTransmigrasi = toraObject.Data.Where(x => (int)x.Status == status).Where(x => x.FkSchemeId == 1).Count(), TotalProna = toraObject.Data.Where(x => (int)x.Status == status).Where(x => x.FkSchemeId == 2).Count(), TotalKonflik = toraObject.Data.Where(x => (int)x.Status == status).Where(x => x.FkSchemeId == 3).Count(), TotalTerlantar = toraObject.Data.Where(x => (int)x.Status == status).Where(x => x.FkSchemeId == 4).Count(), TotalPelepasan = toraObject.Data.Where(x => (int)x.Status == status).Where(x => x.FkSchemeId == 5).Count(), TotalAdat = toraObject.Data.Where(x => (int)x.Status == status).Where(x => x.FkSchemeId == 6).Count(), TotalDesa = toraObject.Data.Where(x => (int)x.Status == status).Where(x => x.FkSchemeId == 7).Count(), TotalTanamanRakyat = toraObject.Data.Where(x => (int)x.Status == status).Where(x => x.FkSchemeId == 8).Count(), TotalKemasyarakatan = toraObject.Data.Where(x => (int)x.Status == status).Where(x => x.FkSchemeId == 9).Count(), TotalKemitraan = toraObject.Data.Where(x => (int)x.Status == status).Where(x => x.FkSchemeId == 10).Count() }; results.Add(dashboardData); } var finalResult = children .Select(c => results.FirstOrDefault(g => g.Region.Id == c.Id) ?? new DashboardDataViewModel { Region = c }) .ToList(); return(finalResult); }