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