// GET: ViewResult
public ActionResult Index(int?stdId)
{
var report = (from courseInfo in db.ResultEntries
where courseInfo.StudentRegistrationId == stdId
select courseInfo).ToList();
foreach (var stdCourseInfo in report)
{
courseCode = stdCourseInfo.aCourse.Code;
courseName = stdCourseInfo.aCourse.Name;
gradeName = stdCourseInfo.aGradeLetter.GradeName;
}
Vvalue aV = new Vvalue();
aV.t1 = courseCode;
aV.t2 = courseName;
aV.t3 = gradeName;
FileStream fs = new FileStream("Chapter1_Example1.pdf", FileMode.Create, FileAccess.Write, FileShare.None);
Document doc = new Document();
PdfWriter writer = PdfWriter.GetInstance(doc, fs);
doc.Open();
doc.Add(new PdfPTable(3));
doc.Close();
//var report = (from courseInfo in db.ResultEntries
// where courseInfo.StudentRegistrationId == stdId
// select courseInfo).ToList();
return new RazorPDF.PdfResult(aV, "Index");
//var viewResults = db.ViewResults.Include(v => v.aSruStudentRegistration);
// return View(viewResults.ToList());
}
public JsonResult GetDropDownListSelectedData3(string id)
{
var aa = from T in db.Courses
where T.Code.Equals(id)
select new { T.Credit, T.Name };
foreach (var ele in aa)
{
name1 = ele.Name;
credit1 = ele.Credit;
}
Vvalue aV = new Vvalue();
aV.t1 = credit1;
aV.t3 = name1;
return Json(aV, JsonRequestBehavior.AllowGet);
}
public JsonResult GetDropDownListSelectedData(int? id)
{
var aa = (from T in db.StudentRegistrations
where T.Id == id
select T).ToList();
//string name;
//string email;
//int dept;
foreach (var ele in aa)
{
name = ele.Name;
email = ele.Email;
dept = ele.Departments.DepartmentCode;
}
Vvalue aV = new Vvalue();
aV.t1 = name;
aV.t2 = email;
aV.t3 = dept;
return Json(aV, JsonRequestBehavior.AllowGet);
}
public JsonResult GetDropDownListSelectedData(string id)
{
var aa = from T in db.Teachers
where T.Name.Equals(id)
select T.CreditToBTaken;
//aTeacher.CreditToBTaken = Convert.ToDouble(aa);
var bb = from T2 in db.TeacherAssignments
where T2.aTeacher.Name.Equals(id)
select T2.Credit;
double valaa = 0;
foreach (var ele in aa)
{
valaa += Convert.ToDouble(ele);
}
double valbb = 0;
foreach (var ele in bb)
{
valbb += Convert.ToDouble(ele);
}
Vvalue aVvalue = new Vvalue();
double val = valaa - valbb;
//double val = Convert.ToDouble(aa.ElementAt(0)) - Convert.ToDouble(bb.ElementAt(0));
aVvalue.t1 = val;
aVvalue.t2 = valaa;
return Json(aVvalue, JsonRequestBehavior.AllowGet);
}
