public FileResult StudentWiseReport(int Id, string type) { var chart = new ReportDesign(); ReportDesign.ScoresDataTable card = chart.Scores; ReportDataSourceComponents[] source = new ReportDataSourceComponents[] { }; ReportDesign.SuccessRateDataTable successRate = chart.SuccessRate; using (DBEntities dbContext = new DBEntities()) { var log = dbContext.ReportCard.Where(s => s.UserId == Id).ToList(); foreach (ReportCard score in log) { card.AddScoresRow(dbContext.Courses.Where(c => c.CourseId == score.CourseId).Select(c => c.CourseName).FirstOrDefault(), dbContext.Papers.Where(c => c.PaperId == score.Paperid).Select(c => c.PaperName).FirstOrDefault(), dbContext.Levels.Where(c => c.Level == score.LevelId).Select(c => c.LevelName).FirstOrDefault(), score.TotalScore, score.UserId.ToString(), dbContext.Users.Where(c => c.Id == Id).Select(c => c.UserName).FirstOrDefault()); } var optionsLog = dbContext.Scores.Where(s => s.UserId == Id).Select(s => s.Score).ToList(); double successRateCount = 0; double FailRateCount = 0; for (int i = 0; i < optionsLog.Count; i++) { if (optionsLog[i] != 0) { successRateCount++; } else { FailRateCount++; } } successRate.AddSuccessRateRow(successRateCount / (successRateCount + FailRateCount), FailRateCount / (successRateCount + FailRateCount)); source = new[] { new ReportDataSourceComponents("StudentWiseReportScores", card), new ReportDataSourceComponents("StudentWiseReportSuccessRate", successRate) }; } string templateName = "StudentWiseReport.rdlc"; string path = GetTemplateFullPath(templateName); var reportOutput = PublishReportForTemplate(type, path, source); string tempReportName = Guid.NewGuid() + "." + type; WriteReportToFile(tempReportName, reportOutput); byte[] fileBytes = System.IO.File.ReadAllBytes(Path.Combine(GetHomeDirectory(), "TempCharts", tempReportName)); string fileName = "StudentWiseReport." + type; //Delete temp file if (System.IO.File.Exists(Path.Combine(GetHomeDirectory(), "TempCharts", tempReportName))) { System.IO.File.Delete(Path.Combine(GetHomeDirectory(), "TempCharts", tempReportName)); } return(File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, fileName)); }
public FileResult ReportGenerator(Guid Id) { Users usercookie = Session["usercookie"] as Users; int currentUserId = usercookie.Id; var chart = new ReportDesign(); ReportDesign.ScoresDataTable card = chart.Scores; ReportDataSourceComponents[] source = new ReportDataSourceComponents[] { }; using (DBEntities dbContext = new DBEntities()) { var log = dbContext.ReportCard.Where(s => s.TestId == Id).ToList(); foreach (ReportCard score in log) { card.AddScoresRow(dbContext.Courses.Where(c => c.CourseId == score.CourseId).Select(c => c.CourseName).FirstOrDefault(), dbContext.Papers.Where(c => c.PaperId == score.Paperid).Select(c => c.PaperName).FirstOrDefault(), dbContext.Levels.Where(c => c.Level == score.LevelId).Select(c => c.LevelName).FirstOrDefault(), score.TotalScore, score.UserId.ToString(), dbContext.Users.Where(c => c.Id == currentUserId).Select(c => c.UserName).FirstOrDefault()); } source = new[] { new ReportDataSourceComponents("ReportCard", card) }; } string templateName = "ReportCard.rdlc"; string path = GetTemplateFullPath(templateName); var reportOutput = PublishReportForTemplate("pdf", path, source); string tempReportName = Guid.NewGuid() + ".pdf"; WriteReportToFile(tempReportName, reportOutput); byte[] fileBytes = System.IO.File.ReadAllBytes(Path.Combine(GetHomeDirectory(), "TempCharts", tempReportName)); string fileName = "ReportCard.pdf"; //Delete temp file if (System.IO.File.Exists(Path.Combine(GetHomeDirectory(), "TempCharts", tempReportName))) { System.IO.File.Delete(Path.Combine(GetHomeDirectory(), "TempCharts", tempReportName)); } return(File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, fileName)); }
public FileResult AdminExamWiseReport(int CourseId, string type) { var chart = new ReportDesign(); ReportDesign.ScoresDataTable card = chart.Scores; ReportDataSourceComponents[] source = new ReportDataSourceComponents[] { }; using (DBEntities dbContext = new DBEntities()) { var log = dbContext.ReportCard.Where(s => s.CourseId == CourseId).OrderByDescending(s => s.TotalScore).ToList(); foreach (ReportCard score in log) { card.AddScoresRow(dbContext.Courses.Where(c => c.CourseId == score.CourseId).Select(c => c.CourseName).FirstOrDefault(), dbContext.Papers.Where(c => c.PaperId == score.Paperid).Select(c => c.PaperName).FirstOrDefault(), dbContext.Levels.Where(c => c.Level == score.LevelId).Select(c => c.LevelName).FirstOrDefault(), score.TotalScore, score.UserId.ToString(), dbContext.Users.Where(c => c.Id == score.UserId).Select(c => c.UserName).FirstOrDefault()); } source = new[] { new ReportDataSourceComponents("ExamWiseReport", card) }; } string templateName = "ExamWiseReport.rdlc"; string path = GetTemplateFullPath(templateName); var reportOutput = PublishReportForTemplate(type, path, source); string tempReportName = Guid.NewGuid() + "." + type; WriteReportToFile(tempReportName, reportOutput); byte[] fileBytes = System.IO.File.ReadAllBytes(Path.Combine(GetHomeDirectory(), "TempCharts", tempReportName)); string fileName = "ExamWiseReport." + type; //Delete temp file if (System.IO.File.Exists(Path.Combine(GetHomeDirectory(), "TempCharts", tempReportName))) { System.IO.File.Delete(Path.Combine(GetHomeDirectory(), "TempCharts", tempReportName)); } return(File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, fileName)); }
public JsonResult GenerateStats() { Users usercookie = Session["usercookie"] as Users; if (Session["usercookie"] == null) { return(Json(new { success = false, responseText = "Please login.Session expired!!." }, JsonRequestBehavior.AllowGet)); } else { int currentUserId = usercookie.Id; var chart = new ReportDesign(); ReportDesign.ScoresDataTable scores = chart.Scores; ReportDesign.SuccessRateDataTable successRate = chart.SuccessRate; ReportDataSourceComponents[] source = new ReportDataSourceComponents[] { }; if (usercookie.RoleId == 2) { using (DBEntities dbContext = new DBEntities()) { var log = dbContext.ReportCard.ToList(); foreach (ReportCard score in log) { scores.AddScoresRow(dbContext.Courses.Where(c => c.CourseId == score.CourseId).Select(c => c.CourseName).FirstOrDefault(), dbContext.Papers.Where(c => c.PaperId == score.Paperid).Select(c => c.PaperName).FirstOrDefault(), dbContext.Levels.Where(c => c.Level == score.LevelId).Select(c => c.LevelName).FirstOrDefault(), score.TotalScore, score.UserId.ToString(), dbContext.Users.Where(c => c.Id == currentUserId).Select(c => c.UserName).FirstOrDefault()); } var optionsLog = dbContext.Scores.Select(s => s.Score).ToList(); double successRateCount = 0; double FailRateCount = 0; for (int i = 0; i < optionsLog.Count; i++) { if (optionsLog[i] != 0) { successRateCount++; } else { FailRateCount++; } } successRate.AddSuccessRateRow(successRateCount / (successRateCount + FailRateCount), FailRateCount / (successRateCount + FailRateCount)); source = new[] { new ReportDataSourceComponents("Scores", scores), new ReportDataSourceComponents("SuccessRate", successRate) }; } } else { using (DBEntities dbContext = new DBEntities()) { var log = dbContext.ReportCard.Where(s => s.UserId == currentUserId).ToList(); foreach (ReportCard score in log) { scores.AddScoresRow(dbContext.Courses.Where(c => c.CourseId == score.CourseId).Select(c => c.CourseName).FirstOrDefault(), dbContext.Papers.Where(c => c.PaperId == score.Paperid).Select(c => c.PaperName).FirstOrDefault(), dbContext.Levels.Where(c => c.Level == score.LevelId).Select(c => c.LevelName).FirstOrDefault(), score.TotalScore, score.UserId.ToString(), dbContext.Users.Where(c => c.Id == currentUserId).Select(c => c.UserName).FirstOrDefault()); } var optionsLog = dbContext.Scores.Where(s => s.UserId == currentUserId).Select(s => s.Score).ToList(); double successRateCount = 0; double FailRateCount = 0; for (int i = 0; i < optionsLog.Count; i++) { if (optionsLog[i] != 0) { successRateCount++; } else { FailRateCount++; } } successRate.AddSuccessRateRow((successRateCount / (successRateCount + FailRateCount)) * 100, (FailRateCount / (successRateCount + FailRateCount)) * 100); source = new[] { new ReportDataSourceComponents("Scores", scores), new ReportDataSourceComponents("SuccessRate", successRate) }; } } string templateName = "DashBoardChart.rdlc"; string path = GetTemplateFullPath(templateName); var reportOutput = PublishReportForTemplate("Excel", path, source); string tempReportName = Guid.NewGuid() + ".xls"; WriteReportToFile(tempReportName, reportOutput); //now export chart to img Workbook workbook = new Workbook(); workbook.LoadFromFile(Path.Combine(GetHomeDirectory(), "TempCharts", tempReportName), ExcelVersion.Version97to2003); Worksheet sheet = workbook.Worksheets[0]; ExcelPicture ScoresPicture = sheet.Pictures[0]; ExcelPicture SuccessRatePicture = sheet.Pictures[1]; string scoresPath; string successRatePath; if (usercookie.RoleId == 2) { scoresPath = Path.Combine(GetHomeDirectory(), "TempCharts", "AdminScoresChart.png"); successRatePath = Path.Combine(GetHomeDirectory(), "TempCharts", "AdminSuccessRateChart.png"); } else { scoresPath = Path.Combine(GetHomeDirectory(), "TempCharts", "UserScoresChart.png"); successRatePath = Path.Combine(GetHomeDirectory(), "TempCharts", "UserSuccessRateChart.png"); } //Delete old score chart if (System.IO.File.Exists(scoresPath)) { System.IO.File.Delete(scoresPath); } //Delete old successRate chart if (System.IO.File.Exists(successRatePath)) { System.IO.File.Delete(successRatePath); } ScoresPicture.Picture.Save(scoresPath, ImageFormat.Png); SuccessRatePicture.Picture.Save(successRatePath, ImageFormat.Png); //Delete temp file if (System.IO.File.Exists(Path.Combine(GetHomeDirectory(), "TempCharts", tempReportName))) { System.IO.File.Delete(Path.Combine(GetHomeDirectory(), "TempCharts", tempReportName)); } return(Json(new { success = true, responseText = "" }, JsonRequestBehavior.AllowGet)); } }