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