// This method will return an instance of GeneralReportModel Class public GeneralReportModel GeneralReport() { var allUsers = db.Users.Where(x => x.RoleId == 2).ToList(); var allVacancies = db.JobOpenings.Where(x => x.Vacancy != 0 && x.IsExpired == false && x.LastApplyDate >= DateTime.Now).ToList(); var userApplication = db.JobApplications.Where(x => x.Status == 1).ToList(); GeneralReportModel model = new GeneralReportModel { TotalEmployee = allUsers.Count(), TotalVacancy = allVacancies.Count(), TotalApplied = userApplication.Count() }; return(model); }
public GeneralReportModel GetGeneralReport(string fromDate, string toDate) { DateTime dateFrom = string.IsNullOrEmpty(fromDate) ? DateTime.Now : DateTime.Parse(fromDate); DateTime dateto = string.IsNullOrEmpty(toDate) ? DateTime.Now : DateTime.Parse(toDate); dateto = dateto.AddDays(1); GeneralReportModel model = new GeneralReportModel(); model.SchoolCount = Context.schools.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto && x.Status == "Approved") ).ToList().Count(); model.StudentCount = Context.participant_profile.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto) ).ToList().Count(); model.VolunteerCount = Context.volunteer_profile.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto) ).ToList().Count(); model.SessionCount = Context.sessions.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto) ).ToList().Count(); model.PartnerCount = Context.funder_profile.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto) ).ToList().Count(); model.CoordinatorCount = Context.coordinator_profile.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto) ).ToList().Count(); var resultCPpre = Context.evaluation_cp_pre.Where(x => (x.CreateAt >= dateFrom) && (x.CreateAt < dateto) ).ToList().Count(); var resultMurshadeepre = Context.evaluation_murshadee_before.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto) ).ToList().Count(); var resultPFpre = Context.evaluation_pf_pre.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto) ).ToList().Count(); var resultSafeerpre = Context.evaluation_safeer_pre.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto) ).ToList().Count(); var resultSYCpre1 = Context.evaluation_syc_pre_part1.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto) ).ToList().Count(); var resultPFpre2 = Context.evaluation_syc_pre_part2.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto) ).ToList().Count(); model.EvaluationPreCount = resultCPpre + resultMurshadeepre + resultPFpre + resultSafeerpre + resultSYCpre1 + resultPFpre2; var resultCPpost = Context.evaluation_cp_post.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto) ).ToList().Count(); var resultMurshadeepost = Context.evaluation_murshadee_after.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto) ).ToList().Count(); var resultPFpost = Context.evaluation_pf_post.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto) ).ToList().Count(); var resultSafeerpost = Context.evaluation_safeer_post.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto) ).ToList().Count(); var resultSYCpost1 = Context.evaluation_syc_post_part1.Where(x => (x.CreatedAT >= dateFrom) && (x.CreatedAT < dateto) ).ToList().Count(); var resultPFpost2 = Context.evaluation_syc_post_part2.Where(x => (x.CreatedAt >= dateFrom) && (x.CreatedAt < dateto) ).ToList().Count(); model.EvaluationPostCount = resultCPpost + resultMurshadeepost + resultPFpost + resultSafeerpost + resultSYCpost1 + resultPFpost2; model.CitiesCount = Context.lk_city.Count(); return(model); }
public ActionResult GeneralReport() { var Values = new GeneralReportModel(); return(View(Values)); }