public ActionResult ApprovedReport(int? id, string role)
{
List<StudentCourseModel> studentCourses = FacultySvc.GetAllStudentCourses();
List<CourseModel> courses;
UserModel user;
AccademicSessionModel accademic;
if (id != null)
{
courses = FacultySvc.GetCoursesByAccademicSession(id.Value, role)
.Where(p=>p.Status == (int)CourseStatusEnum.Approved).ToList();
accademic = FacultySvc.GetAccademicSessionsById(id.Value);
user = FacultySvc.GetUserById(1);
}
else
{
courses = FacultySvc.GetCourses();
user = FacultySvc.GetUserById(1);
accademic = new AccademicSessionModel(){AccName = ""};
}
var totalAll = 0;
DataTable dt = new DataTable("GradeDistributionDataTable");
dt.Columns.Add("CourseName");
dt.Columns.Add("CW0_9");
dt.Columns.Add("CW10_19");
dt.Columns.Add("CW20_29");
dt.Columns.Add("CW30_39");
dt.Columns.Add("CW40_49");
dt.Columns.Add("CW50_59");
dt.Columns.Add("CW60_69");
dt.Columns.Add("CW70_79");
dt.Columns.Add("CW80_89");
dt.Columns.Add("CW90_100");
var courseCode = "";
var accademicSession = "";
foreach (var course in courses)
{
courseCode += course.CourseCode + ", ";
DataRow dr = dt.NewRow();
dr["CourseName"] = course.CourseCode;
var currentCourse = studentCourses.Where(x =>x.CourseId == course.CourseId);
if (currentCourse.Any())
{
var total = currentCourse.Count();
totalAll += total;
float c1 = studentCourses.Where(x => x.Mark >= 0 && x.Mark <= 9 && x.CourseId == course.CourseId).ToList().Count();
float c2 = studentCourses.Where(x => x.Mark >= 10 && x.Mark <= 19 && x.CourseId == course.CourseId).ToList().Count();
float c3 = studentCourses.Where(x => x.Mark >= 20 && x.Mark <= 29 && x.CourseId == course.CourseId).ToList().Count();
float c4 = studentCourses.Where(x => x.Mark >= 30 && x.Mark <= 39 && x.CourseId == course.CourseId).ToList().Count();
float c5 = studentCourses.Where(x => x.Mark >= 40 && x.Mark <= 49 && x.CourseId == course.CourseId).ToList().Count();
float c6 = studentCourses.Where(x => x.Mark >= 50 && x.Mark <= 59 && x.CourseId == course.CourseId).ToList().Count();
float c7 = studentCourses.Where(x => x.Mark >= 60 && x.Mark <= 69 && x.CourseId == course.CourseId).ToList().Count();
float c8 = studentCourses.Where(x => x.Mark >= 70 && x.Mark <= 79 && x.CourseId == course.CourseId).ToList().Count();
float c9 = studentCourses.Where(x => x.Mark >= 80 && x.Mark <= 89 && x.CourseId == course.CourseId).ToList().Count();
float c10 = studentCourses.Where(x => x.Mark >= 90 && x.CourseId == course.CourseId).ToList().Count();
float per1 = (float)Math.Round(c1 * 100 / total, 2);
float per2 = (float)Math.Round(c2 * 100 / total, 2);
float per3 = (float)Math.Round(c3 * 100 / total, 2);
float per4 = (float)Math.Round(c4 * 100 / total, 2);
float per5 = (float)Math.Round(c5 * 100 / total, 2);
float per6 = (float)Math.Round(c6 * 100 / total, 2);
float per7 = (float)Math.Round(c7 * 100 / total, 2);
float per8 = (float)Math.Round(c8 * 100 / total, 2);
float per9 = (float)Math.Round(c9 * 100 / total, 2);
float per10 = (float)Math.Round(c10 * 100 / total, 2);
dr["CW0_9"] = per1 + "%";
dr["CW10_19"] = per2 + "%";
dr["CW20_29"] = per3 + "%";
dr["CW30_39"] = per4 + "%";
dr["CW40_49"] = per5 + "%";
dr["CW50_59"] = per6 + "%";
dr["CW60_69"] = per7 + "%";
dr["CW70_79"] = per8 + "%";
dr["CW80_89"] = per9 + "%";
dr["CW90_100"] = per10 + "%";
dt.Rows.Add(dr);
}
}
string reportPath = "~/Reports/CourseMonotoringReport.rdlc";
//DataTable tblStatisticalDataTable = new DataTable("StatisticalDataTable");
//tblStatisticalDataTable.Columns.Add("CourseName");
//tblStatisticalDataTable.Columns.Add("CWMean");
//tblStatisticalDataTable.Columns.Add("CWMedian");
//tblStatisticalDataTable.Columns.Add("CWStandardDeviation");
//tblStatisticalDataTable.Columns.Add("Overal");
//for (int j = 0; j < 10; j++)
//{
// DataRow dr = tblStatisticalDataTable.NewRow();
// dr[0] = "1";
// dr[1] = "1";
// dr[2] = "1";
// dr[3] = "1";
// dr[4] = "1";
// tblStatisticalDataTable.Rows.Add(dr);
//}
var title = courseCode.Remove(courseCode.Length - 2) + " Report";
//set param
List<ReportParameter> listParam = new List<ReportParameter>()
{
new ReportParameter("paramAccdemicSession", accademic.AccName),
new ReportParameter("paramCourseCode", title),
new ReportParameter("paramCourseLeader", user.UserName),
new ReportParameter("paramStudentCount", totalAll.ToString())
};
ReportViewer viewer = new ReportViewer {ProcessingMode = ProcessingMode.Local};
viewer.LocalReport.ReportPath = Server.MapPath(reportPath);
//viewer.LocalReport.DataSources.Add(new ReportDataSource("StatisticalDataset", tblStatisticalDataTable));
viewer.LocalReport.DataSources.Add(new ReportDataSource("GradeDistributionDataset", dt));
viewer.LocalReport.SetParameters(listParam);
byte[] bytes = viewer.LocalReport.Render("PDF");
Stream stream = new MemoryStream(bytes);
return File(stream, "application/pdf");
}
public AccademicSessionModel GetAccademicSessionsById(int id)
{
var response = new AccademicSessionModel();
var items = from f in DbContext.AccademicSessions select new AccademicSessionModel { AccId = f.AccademicSessionId, AccName = f.AccSessName };
if (items.Any())
{
response = items.First();
}
return response;
}