public ActionResult CreateReport(CourseMonitoringReport acr, String waiting)
{
if (ModelState.IsValid)
{
CRMContext db = new CRMContext();
if (waiting != null)
{
acr.approveStatusId = 2;
var userName = User.Identity.Name;
var user = db.Accounts.SingleOrDefault(u => u.userName == userName);
var AnnualCourse = db.AnnualCourses.SingleOrDefault(a => a.annualCourseId == acr.annualCourseId);
int CMId = (int)AnnualCourse.Course.Faculty.cmAccount;
var Cm = db.Accounts.SingleOrDefault(u => u.accountId == CMId);
db.CourseMonitoringReports.Add(acr);
db.SaveChanges();
int ID = db.CourseMonitoringReports.Max(item => item.CourseMonitoringReportId);
var body = "<p>Email From: {0} ({1})</p><p>Message: {2}</p><p>Link: {3}</p>";
var uri = HttpContext.Request.Url;
String url = uri.GetLeftPart(UriPartial.Authority);
url = url + "/CM/Detail?reportId=" +ID;
var message = string.Format(body, user.Profile.name, user.Profile.email, "There is a report that you need to approve", url);
Task.Run(async () => await CustomHtmlHelpers.Helpers.sendMail(Cm.Profile.email, message));
}else{
db.CourseMonitoringReports.Add(acr);
db.SaveChanges();
}
return RedirectToAction("ReportList");
}
return View();
}
public ActionResult Index(string sortOrder,String currentFilter, String searchString, int? page)
{
CRMContext db = new CRMContext();
var currUser = User.Identity;
String userName = currUser.Name;
ViewBag.NameSortParm = sortOrder == "Name" ? "name_desc" : "Name";
ViewBag.StatusSortParm = sortOrder == "Status" ? "status_desc" : "Status";
ViewBag.currentSort = sortOrder;
var courses = (from cmr in db.CourseMonitoringReports
join ac in db.AnnualCourses on cmr.annualCourseId equals ac.annualCourseId
join c in db.Courses on ac.courseId equals c.courseId
join fac in db.Faculties on c.facultyId equals fac.facultyId
join a in db.Accounts on fac.cmAccount equals a.accountId
where a.userName == userName && cmr.approveStatusId != 1
select cmr
);
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.currentFilter = searchString;
if (!String.IsNullOrEmpty(searchString))
{
courses = courses.Where(s => s.AnnualCourse.Course.courseName.Contains(searchString));
}
switch (sortOrder)
{
case "name_desc":
courses = courses.OrderByDescending(c => c.AnnualCourse.Course.courseName);
break;
case "Name":
courses = courses.OrderBy(c => c.AnnualCourse.Course.courseName);
break;
case "status_desc":
courses = courses.OrderByDescending(c => c.approveStatusId);
break;
case "Status":
courses = courses.OrderBy(c => c.approveStatusId);
break;
default:
courses = courses.OrderBy(c => c.CourseMonitoringReportId);
break;
}
int pageSize = 10;
int pageNumber = (page ?? 1);
return View(courses.ToPagedList(pageNumber, pageSize));
}
public ActionResult Detail(int reportId)
{
CRMContext db = new CRMContext();
var report = db.CourseMonitoringReports.SingleOrDefault(c => c.CourseMonitoringReportId == reportId);
if (report == null)
{
return HttpNotFound();
}
return View(report);
}
public ActionResult ExceptionReport()
{
CRMContext db = new CRMContext();
List<CourseMonitoringReport> cmrList = db.CourseMonitoringReports.ToList();
var dictionary1 = new Dictionary<string, StatisticModel>();
foreach (CourseMonitoringReport a in cmrList)
{
string academicYear = Convert.ToString(a.AnnualCourse.academicYear);
bool isExisted = dictionary1.Keys.Any(k => k.Equals(academicYear));
if (!isExisted)
{
StatisticModel model2 = new StatisticModel();
model2.academicYear = Convert.ToInt32(academicYear);
model2.pendingCount = 0;
dictionary1[academicYear] = model2;
}
StatisticModel model = dictionary1[academicYear];
if (a.ApproveStatu.name.Equals("Pending"))
{
model.pendingCount++;
}
}
var dictionary2 = new Dictionary<string, StatisticModel>();
foreach (CourseMonitoringReport a in cmrList)
{
string academicYear = Convert.ToString(a.AnnualCourse.academicYear);
bool isExisted = dictionary2.Keys.Any(k => k.Equals(academicYear));
if (!isExisted)
{
StatisticModel model2 = new StatisticModel();
model2.academicYear = Convert.ToInt32(academicYear);
model2.pendingCount = 0;
dictionary2[academicYear] = model2;
}
StatisticModel model = dictionary2[academicYear];
if (String.IsNullOrEmpty(a.dltComment))
{
model.pendingCount++;
}
}
var dictionary11= new Dictionary<string, StatisticModel>();
foreach (var item in dictionary1.OrderBy(i => i.Key))
{
dictionary11.Add(item.Key, item.Value);
}
var dictionary22 = new Dictionary<string, StatisticModel>();
foreach (var item in dictionary2.OrderBy(i => i.Key))
{
dictionary22.Add(item.Key, item.Value);
}
ViewBag.dict1 = dictionary11;
ViewBag.dict2 = dictionary22;
return View();
}
public ActionResult Index()
{
CRMContext db = new CRMContext();
var currUser =User.Identity;
String userName = currUser.Name;
var course = (from ac in db.AnnualCourses
join a in db.Accounts on ac.clAccount equals a.accountId
where a.userName == userName
select ac).ToList();
return View(course);
}
public ActionResult Index()
{
CRMContext db = new CRMContext();
var currUser = User.Identity;
String userName = currUser.Name;
var courses = (from cmr in db.CourseMonitoringReports
join ac in db.AnnualCourses on cmr.annualCourseId equals ac.annualCourseId
join c in db.Courses on ac.courseId equals c.courseId
join fac in db.Faculties on c.facultyId equals fac.facultyId
join a in db.Accounts on fac.dltAccount equals a.accountId
where a.userName == userName && cmr.approveStatusId == 4
select cmr
);
return View(courses);
}
public ActionResult StatisticReport()
{
CRMContext db = new CRMContext();
List<CourseMonitoringReport> cmrList = db.CourseMonitoringReports.ToList();
var dictionary = new Dictionary<string, StatisticModel>();
foreach (CourseMonitoringReport a in cmrList)
{
string academicYear = Convert.ToString(a.AnnualCourse.academicYear);
bool isExisted = dictionary.Keys.Any(k => k.Equals(academicYear));
if (!isExisted)
{
StatisticModel model2 = new StatisticModel();
model2.academicYear = Convert.ToInt32(academicYear);
model2.approvedCount = 0;
model2.pendingCount = 0;
model2.rejectedCount = 0;
model2.waitingCount = 0;
dictionary[academicYear] = model2;
}
StatisticModel model = dictionary[academicYear];
if (a.ApproveStatu.name.Equals("Pending"))
{
model.pendingCount++;
}
if (a.ApproveStatu.name.Equals("Approved"))
{
model.approvedCount++;
}
if (a.ApproveStatu.name.Equals("Waiting"))
{
model.waitingCount++;
}
if (a.ApproveStatu.name.Equals("Rejected"))
{
model.rejectedCount++;
}
}
var dictionary2 = new Dictionary<string, StatisticModel>();
foreach (var item in dictionary.OrderBy(i => i.Key))
{
dictionary2.Add(item.Key,item.Value);
}
ViewBag.dict = dictionary2;
return View();
}
public ActionResult Detail(int reportId) {
CRMContext db = new CRMContext();
var report = db.CourseMonitoringReports.SingleOrDefault(c => c.CourseMonitoringReportId == reportId);
if (report == null)
{
return HttpNotFound();
}
List<SelectListItem> items = new List<SelectListItem>();
items.Add(new SelectListItem { Text = "-- Select One --", Value = "2" });
items.Add(new SelectListItem { Text = "Approve", Value = "4", Selected = (4 == report.approveStatusId ? true : false) });
items.Add(new SelectListItem { Text = "Reject", Value = "3", Selected=(3==report.approveStatusId ? true : false) });
ViewBag.listEvent = items;
return View(report);
}
public ActionResult CreateReport(String annualCourseId)
{
ViewBag.annualCourseId = annualCourseId;
int Id=Int32.Parse(annualCourseId);
CRMContext db = new CRMContext();
var students = (from student in db.Students
where student.AnnualCourseId == Id
select student).ToList();
int markA=0;
int markB=0;
int markC=0;
int markD=0;
int total = 0;
foreach(Student s in students){
if (s.Mark >= 80)
{
markA++;
}
if (s.Mark >= 60 && s.Mark <= 79)
{
markB++;
}
if (s.Mark >= 40 && s.Mark <= 59)
{
markC++;
}
if (s.Mark < 40)
{
markD++;
}
total++;
}
ViewBag.markA = markA;
ViewBag.markB = markB;
ViewBag.markC = markC;
ViewBag.markD = markD;
ViewBag.total = total;
return View();
}
public ActionResult ResponseComment(int courseMonitoringReportId, String dltComment)
{
CRMContext db = new CRMContext();
var report = db.CourseMonitoringReports.SingleOrDefault(c => c.CourseMonitoringReportId == courseMonitoringReportId);
if (report != null)
{
report.dltComment = dltComment;
db.Entry(report).State = EntityState.Modified;
db.SaveChanges();
var clEmail = report.AnnualCourse.Account.Profile.email;
var userName = User.Identity.Name;
var user = db.Accounts.SingleOrDefault(u => u.userName == userName);
var body = "<p>Email From: {0} ({1})</p><p>Message: {2}</p><p>Content: {3}</p><p>Link: {4}</p>";
var uri = HttpContext.Request.Url;
String url = uri.GetLeftPart(UriPartial.Authority);
url = url + "/CL/ReportDetail?id=" + report.CourseMonitoringReportId;
var message = string.Format(body, user.Profile.name, user.Profile.email, "Your report has been repsoned.",dltComment,url);
Task.Run(async () => await CustomHtmlHelpers.Helpers.sendMail(clEmail, message));
}
return RedirectToAction("Detail", new { reportId = courseMonitoringReportId });
}
public ActionResult CreateStatusStatisTicReportChart()
{
CRMContext db = new CRMContext();
List<CourseMonitoringReport> cmrList = db.CourseMonitoringReports.ToList();
var dictionary = new Dictionary<string, StatisticModel>();
foreach (CourseMonitoringReport a in cmrList)
{
string academicYear = Convert.ToString(a.AnnualCourse.academicYear);
bool isExisted = dictionary.Keys.Any(k => k.Equals(academicYear));
if (!isExisted)
{
StatisticModel model2 = new StatisticModel();
model2.academicYear = Convert.ToInt32(academicYear);
model2.approvedCount = 0;
model2.pendingCount = 0;
model2.rejectedCount = 0;
model2.waitingCount = 0;
dictionary[academicYear] = model2;
}
StatisticModel model = dictionary[academicYear];
if (a.ApproveStatu.name.Equals("Pending"))
{
model.pendingCount++;
}
if (a.ApproveStatu.name.Equals("Approved"))
{
model.approvedCount++;
}
if (a.ApproveStatu.name.Equals("Waiting"))
{
model.waitingCount++;
}
if (a.ApproveStatu.name.Equals("Rejected"))
{
model.rejectedCount++;
}
}
var dictionary2 = new Dictionary<string, StatisticModel>();
foreach (var item in dictionary.OrderBy(i => i.Key))
{
dictionary2.Add(item.Key, item.Value);
}
String[] academicYears = dictionary2.Keys.ToArray<String>();
Dictionary<string, string[]> pendingDict = new Dictionary<string, string[]>();
Dictionary<string, string[]> waitingDict = new Dictionary<string, string[]>();
Dictionary<string, string[]> approveDict = new Dictionary<string, string[]>();
Dictionary<string, string[]> rejectDict = new Dictionary<string, string[]>();
String[] pendingList = null;
String[] watingList = null;
String[] approveList = null;
String[] rejectList = null;
for (int i = 0; i < academicYears.Count(); i++) {
String year = academicYears[i];
StatisticModel theModel = dictionary2[year];
if (i == 0)
{
pendingList = new String[academicYears.Count()];
watingList = new String[academicYears.Count()];
approveList = new String[academicYears.Count()];
rejectList = new String[academicYears.Count()];
pendingDict["something"] = pendingList;
waitingDict["something"] = watingList;
approveDict["something"] = approveList;
rejectDict["something"] = rejectList;
}
pendingList[i] = Convert.ToString(theModel.pendingCount);
watingList[i] = Convert.ToString(theModel.waitingCount);
approveList[i] = Convert.ToString(theModel.approvedCount);
rejectList[i] = Convert.ToString(theModel.rejectedCount);
}
var chart = new Chart(width: 800, height: 400, theme: ChartTheme.Green)
.AddTitle("Status statistic of Course Monitoring Report Chart")
.AddLegend()
.AddSeries(chartType: "StackedColumn",
xValue: academicYears,
yValues: pendingDict[pendingDict.Keys.ElementAt(0)],
name: "Pending")
.AddSeries(chartType: "StackedColumn",
xValue: academicYears,
yValues: waitingDict[waitingDict.Keys.ElementAt(0)],
name: "Waiting")
.AddSeries(chartType: "StackedColumn",
xValue: academicYears,
yValues: rejectDict[rejectDict.Keys.ElementAt(0)],
name: "Rejected")
.AddSeries(chartType: "StackedColumn",
xValue: academicYears,
yValues: approveDict[approveDict.Keys.ElementAt(0)],
name: "Approved")
.GetBytes("png");
return File(chart, "image/bytes");
}
public ActionResult Approve(int courseMonitoringReportId, int status, String approve_desc)
{
CRMContext db = new CRMContext();
var report = db.CourseMonitoringReports.SingleOrDefault(c => c.CourseMonitoringReportId == courseMonitoringReportId);
if (report != null)
{
var statusName = "";
report.approveStatusId = status;
report.approve_desc = approve_desc;
db.Entry(report).State = EntityState.Modified;
db.SaveChanges();
var userName = User.Identity.Name;
var user = db.Accounts.SingleOrDefault(u => u.userName == userName);
var ClEmail = report.AnnualCourse.Account.Profile.email;
var pvcEmail = report.AnnualCourse.Course.Faculty.Account2.Profile.email;
var dltEmail = report.AnnualCourse.Course.Faculty.Account1.Profile.email;
if (status == 3)
{
statusName = "rejected";
}
else if (status == 4)
{
statusName = "approved";
}
var uri = HttpContext.Request.Url;
String url = uri.GetLeftPart(UriPartial.Authority);
String clURL = url + "/CL/ReportDetail?id=" + report.CourseMonitoringReportId;
var body = "<p>Email From: {0} ({1})</p><p>Message: {2}</p><p>Link: {3}</p>";
var message = string.Format(body, user.Profile.name, user.Profile.email, "Your report have been " + statusName + " by " + user.Profile.name, clURL);
Task.Run(async () => await CustomHtmlHelpers.Helpers.sendMail(ClEmail, message));
String dltURL = url + "/DLT/Detail?reportId=" + report.CourseMonitoringReportId;
var dtlbody = "<p>Email From: {0} ({1})</p><p>Message: {2}</p><p>Link: {3}</p>";
var dltmessage = string.Format(dtlbody, user.Profile.name, user.Profile.email, "There is a report of " + report.AnnualCourse.Account.Profile.name, dltURL);
Task.Run(async () => await CustomHtmlHelpers.Helpers.sendMail(dltEmail, dltmessage));
String pvcURL = url + "/PVC/Detail?reportId=" + report.CourseMonitoringReportId;
var pvcbody = "<p>Email From: {0} ({1})</p><p>Message: {2}</p><p>Link: {3}</p>";
var pvcmessage = string.Format(pvcbody, report.AnnualCourse.Account.Profile.name, report.AnnualCourse.Account.Profile.email, "There is a report of " + report.AnnualCourse.Account.Profile.name, pvcURL);
Task.Run(async () => await CustomHtmlHelpers.Helpers.sendMail(pvcEmail, pvcmessage));
}
return RedirectToAction("Detail", new { reportId = courseMonitoringReportId });
}
public ActionResult SubmitComment(int courseMonitoringReportId, String comment_content)
{
System.Diagnostics.Debug.WriteLine("SubmitComment " + comment_content);
if (ModelState.IsValid)
{
CRMContext db = new CRMContext();
Comment cmt = new Comment();
cmt.content = comment_content;
var acc = db.Accounts.SingleOrDefault(a => a.userName == User.Identity.Name);
cmt.accountId = acc.accountId;
cmt.time = DateTime.Now;
cmt.monitoringReportId = courseMonitoringReportId;
db.Comments.Add(cmt);
db.SaveChanges();
return RedirectToAction("Detail", new { reportId = courseMonitoringReportId });
}
return View();
}
public async Task<ActionResult> EditReport(CourseMonitoringReport acr, String waiting)
{
CRMContext db = new CRMContext();
if (ModelState.IsValid)
{
if (waiting != null)
{
acr.approveStatusId=2;
var userName = User.Identity.Name;
var user = db.Accounts.SingleOrDefault(u => u.userName == userName);
var AnnualCourse = db.AnnualCourses.SingleOrDefault(a => a.annualCourseId == acr.annualCourseId);
int CMId =(int) AnnualCourse.Course.Faculty.cmAccount;
var Cm = db.Accounts.SingleOrDefault(u => u.accountId == CMId);
var body = "<p>Email From: {0} ({1})</p><p>Message:</p><p>{2}</p><p>Link: {3}</p>";
var uri = HttpContext.Request.Url;
String url = uri.GetLeftPart(UriPartial.Authority);
url = url + "/CM/Detail?reportId=" + acr.CourseMonitoringReportId;
var message = new MailMessage();
message.To.Add(new MailAddress(Cm.Profile.email));
message.Subject = "Course Monitoring Report";
message.Body = string.Format(body, user.Profile.name, user.Profile.email, "There is a report That you need to approve", url);
message.IsBodyHtml = true;
using (var smtp = new SmtpClient())
{
await smtp.SendMailAsync(message);
}
}
db.Entry(acr).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("ReportList");
}
return View(acr);
}
public List<AnnualCourse> getAnnualCourseSearching(String txtAcademicYearFrom, String txtAcademicYearTo, String txtKeyWord)
{
try
{
CRMContext db = new CRMContext();
if (txtAcademicYearFrom != "" && txtAcademicYearTo == "" && txtKeyWord == "")
{
int dt = Int32.Parse(txtAcademicYearFrom);
var annualCourses = (from anc in db.AnnualCourses where anc.academicYear >= dt && anc.Status == "Wait" select anc).ToList();
return annualCourses;
}
if (txtAcademicYearFrom == "" && txtAcademicYearTo != "" && txtKeyWord == "")
{
int dt = Int32.Parse(txtAcademicYearTo);
var annualCourses = (from anc in db.AnnualCourses where anc.academicYear <= dt && anc.Status == "Wait" select anc).ToList();
return annualCourses;
}
if (txtAcademicYearFrom == "" && txtAcademicYearTo == "" && txtKeyWord != "")
{
var annualCourses = (from anc in db.AnnualCourses where anc.Course.courseName.Contains(txtKeyWord) && anc.Status == "Wait" select anc).ToList();
return annualCourses;
}
if (txtAcademicYearFrom != "" && txtAcademicYearTo != "" && txtKeyWord == "")
{
int dtFrom = Int32.Parse(txtAcademicYearFrom);
int dtTo = Int32.Parse(txtAcademicYearTo);
var annualCourses = (from anc in db.AnnualCourses where (anc.academicYear >= dtFrom && anc.academicYear <= dtTo) && anc.Status == "Wait" select anc).ToList();
return annualCourses;
}
if (txtAcademicYearFrom != "" && txtAcademicYearTo == "" && txtKeyWord != "")
{
int dtFrom = Int32.Parse(txtAcademicYearFrom);
var annualCourses = (from anc in db.AnnualCourses where anc.academicYear >= dtFrom && anc.Status == "Wait" && anc.Course.courseName.Contains(txtKeyWord) select anc).ToList();
return annualCourses;
}
if (txtAcademicYearFrom == "" && txtAcademicYearTo != "" && txtKeyWord != "")
{
int dtTo = Int32.Parse(txtAcademicYearTo);
var annualCourses = (from anc in db.AnnualCourses where anc.academicYear <= dtTo && anc.Status == "Wait" && anc.Course.courseName.Contains(txtKeyWord) select anc).ToList();
return annualCourses;
}
if (txtAcademicYearFrom != "" && txtAcademicYearTo != "" && txtKeyWord != "")
{
int dtFrom = Int32.Parse(txtAcademicYearFrom);
int dtTo = Int32.Parse(txtAcademicYearTo);
var annualCourses = (from anc in db.AnnualCourses where (anc.academicYear >= dtFrom && anc.academicYear <= dtTo) && anc.Status == "Wait" && anc.Course.courseName.Contains(txtKeyWord) select anc).ToList();
return annualCourses;
}
}
catch (Exception e)
{
}
return null;
}
public ActionResult ViewAvaibleAnnualCourse(String txtAcademicYearFrom, String txtAcademicYearTo, String txtKeyWord, int? page)
{
CRMContext db = new CRMContext();
List<AnnualCourse> annucalCourses = new List<AnnualCourse>();
ViewBag.From = txtAcademicYearFrom;
ViewBag.To = txtAcademicYearTo;
Regex regex = new Regex(@"^\d{4}$");
Match from = regex.Match(txtAcademicYearFrom);
Match to = regex.Match(txtAcademicYearTo);
int pageSize = 10;
int pageNumber = (page ?? 1);
if (from.Success && to.Success) {
if (txtAcademicYearFrom == "" && txtAcademicYearTo == "" && txtKeyWord == "")
{
ModelState.AddModelError("", "Please, typing any field for searching !");
var annualCourses = from anc in db.AnnualCourses where anc.Course.courseName == "" select anc;
return View(annualCourses.ToPagedList(pageNumber, pageSize));
}
else
{
List<AnnualCourse> listAnnualCourse = getAnnualCourseSearching(txtAcademicYearFrom, txtAcademicYearTo, txtKeyWord);
return View(listAnnualCourse.ToPagedList(pageNumber, pageSize));
}
}
else
{
List<AnnualCourse> listAnnualCourse = getAnnualCourseSearching(txtAcademicYearFrom, txtAcademicYearTo, txtKeyWord);
if (listAnnualCourse == null)
{
listAnnualCourse = new List<AnnualCourse>();
}
ModelState.AddModelError("", "From or To Year is not valid");
return View(listAnnualCourse.ToPagedList(pageNumber, pageSize));
}
}
public ActionResult ViewAvaibleAnnualCourse(string sortOrder, String currentFilter, int? page)
{
CRMContext db = new CRMContext();
ViewBag.SortAcademicYear = sortOrder == "Year" ? "year_desc" : "Year";
ViewBag.SortUserName = sortOrder == "UserName" ? "username_desc" : "UserName";
ViewBag.SortCourseName = sortOrder == "CourseName" ? "coursename_desc" : "CourseName";
ViewBag.currentSort = sortOrder;
int pageSize = 10;
int pageNumber = (page ?? 1);
var anCourses = from anc in db.AnnualCourses where anc.Status.Equals("Wait") select anc;
switch (sortOrder)
{
case "year_desc":
anCourses = anCourses.OrderByDescending(ac => ac.academicYear);
break;
case "Year":
anCourses = anCourses.OrderBy(c => c.academicYear);
break;
case "username_desc":
anCourses = anCourses.OrderByDescending(c => c.Account.userName);
break;
case "UserName":
anCourses = anCourses.OrderBy(c => c.Account.userName);
break;
case "coursename_desc":
anCourses = anCourses.OrderByDescending(c => c.Course.courseName);
break;
case "CourseName":
anCourses = anCourses.OrderBy(c => c.Course.courseName);
break;
default:
anCourses = anCourses.OrderBy(c => c.courseId);
break;
}
return View(anCourses.ToPagedList(pageNumber, pageSize));
}
public ActionResult DeleteReport(int id)
{
CRMContext db = new CRMContext();
CourseMonitoringReport acr = db.CourseMonitoringReports.SingleOrDefault(a => a.CourseMonitoringReportId == id);
if (acr == null)
{
return HttpNotFound();
}
db.CourseMonitoringReports.Remove(acr);
db.SaveChanges();
return RedirectToAction("ReportList");
}
public ActionResult Index()
{
CRMContext db = new CRMContext();
return View(db.CourseMonitoringReports.ToList());
//return View();
}
public ActionResult CreateNoResponseReportChart()
{
CRMContext db = new CRMContext();
List<CourseMonitoringReport> cmrList = db.CourseMonitoringReports.ToList();
var dictionary = new Dictionary<string, StatisticModel>();
foreach (CourseMonitoringReport a in cmrList)
{
string academicYear = Convert.ToString(a.AnnualCourse.academicYear);
bool isExisted = dictionary.Keys.Any(k => k.Equals(academicYear));
if (!isExisted)
{
StatisticModel model2 = new StatisticModel();
model2.academicYear = Convert.ToInt32(academicYear);
model2.pendingCount = 0;
dictionary[academicYear] = model2;
}
StatisticModel model = dictionary[academicYear];
if (String.IsNullOrEmpty(a.dltComment))
{
model.pendingCount++;
}
}
var dictionary2 = new Dictionary<string, StatisticModel>();
foreach (var item in dictionary.OrderBy(i => i.Key))
{
dictionary2.Add(item.Key, item.Value);
}
String[] academicYears = dictionary2.Keys.ToArray<String>();
Dictionary<string, string[]> pendingDict = new Dictionary<string, string[]>();
String[] pendingList = null;
for (int i = 0; i < academicYears.Count(); i++)
{
String year = academicYears[i];
StatisticModel theModel = dictionary2[year];
if (i == 0)
{
pendingList = new String[academicYears.Count()];
pendingDict["something"] = pendingList;
}
pendingList[i] = Convert.ToString(theModel.pendingCount);
}
var chart = new Chart(width: 600, height: 300, theme: ChartTheme.Green)
.AddTitle("No Response Course Monitoring Report Chart")
.AddSeries(chartType: "Bar",
xValue: academicYears,
yValues: pendingDict[pendingDict.Keys.ElementAt(0)])
.GetBytes("png");
return File(chart, "image/bytes");
}
public ActionResult TakeAnnualCourse(int annualCourseId)
{
CRMContext db = new CRMContext();
AnnualCourse anCourse = db.AnnualCourses.SingleOrDefault(ac => ac.annualCourseId == annualCourseId);
var currUser = User.Identity;
String userName = currUser.Name;
Account a = db.Accounts.SingleOrDefault(u => u.userName == userName);
anCourse.clAccount = a.accountId;
anCourse.Status = "Activate";
db.SaveChanges();
return RedirectToAction("Index");
}
public ActionResult ReportList()
{
CRMContext db = new CRMContext();
var currUser = User.Identity;
String userName = currUser.Name;
var Reports = (from cmr in db.CourseMonitoringReports
select cmr);
Reports = Reports.Where(s => s.AnnualCourse.Account.userName == userName);
return View(Reports);
}
public ActionResult EditReport(int id)
{
CRMContext db = new CRMContext();
CourseMonitoringReport acr = db.CourseMonitoringReports.SingleOrDefault(a => a.CourseMonitoringReportId == id);
if (acr == null)
{
return HttpNotFound();
}
return View(acr);
}