public List<assignmentResult> getAssignmentsResult(string cid , int aNo) { var query = from x in db.assignmentResults where x.cid.Equals(cid) && x.aNumber == aNo select x; /*var q = from x in db.assignmentResults.Where(x => x.cid.Equals(cid)) select x;*/ List<assignmentResult> data = new List<assignmentResult>(); foreach (var a in query) { //foreach (var s in query) //{ // if (s.aid.Equals(a.aid)) //{ assignmentResult ass = new assignmentResult(); ass.aid = a.aid; ass.cid = a.cid; ass.marksObtained = a.marksObtained; ass.totalMarks = a.totalMarks; ass.sid = a.sid; ass.outPutFilePath = a.outPutFilePath; ass.codeFilePath = a.codeFilePath; ass.aNumber = a.aNumber; data.Add(ass); //} //} } return data; }
public ActionResult SaveSubmitAssignment() { HttpPostedFileBase file = Request.Files[0]; file.SaveAs(Server.MapPath(@"~\Files\" + file.FileName)); var dataFile = Server.MapPath(@"~\Files\" + file.FileName); HttpPostedFileBase file1 = Request.Files[1]; if (file.ContentType.Equals("text/plain") && file1.ContentType.Equals("text/plain")) { file1.SaveAs(Server.MapPath(@"~\Files\" + file1.FileName)); var dataFile1 = Server.MapPath(@"~\Files\" + file1.FileName); string cid = Request["cid"]; int aNo = Convert.ToInt32(Request["aNumber"]); assignment ass = student.getAssignmentData(cid, aNo); var dataFile2 = ass.solutionFilePath; assignmentResult a = new assignmentResult(); a.aid = ass.aid; a.cid = cid; a.sid = Session["id"].ToString(); a.aNumber = ass.aNumber; a.totalMarks = ass.totalMarks; a.codeFilePath = dataFile; a.outPutFilePath = dataFile1; int ans = student.SaveAssignmentResult(a); if (ans == 0) { ViewBag.ErrorType = "Assignment Submission"; ViewBag.message = "You have already submit this assignment"; return View("ErrorPage"); } Log log = new Log(); log.courseId = cid; log.discription = "Submit Assignment"; log.totalMarks = Convert.ToInt32(a.totalMarks); log.tName = ass.tid; log.type = "Quiz"; log.studentId = a.sid; log.obtainedMarks = Convert.ToInt32(a.marksObtained); log.date = DateTime.Now; db.Logs.Add(log); return View("StudentHome"); } else { ViewBag.ErrorType = "File Uploading"; ViewBag.message = "Please upload a text code file and text output file"; return View("ErrorPage"); } }
public int SaveAssignmentResult(assignmentResult ass) { var query = from x in db.assignmentResults where x.cid == ass.cid && x.sid == ass.sid && x.aid == ass.aid select x; if (query.Count() <= 0) { db.assignmentResults.Add(ass); db.SaveChanges(); return 1; } else return 0; }
public ActionResult getAssignmentsResult() { string id = Session["id"].ToString(); string cid = Request["cid"].ToString(); var quer = from x in db.courses where x.cid == cid select x; string cname = ""; foreach (var a in quer) cname = a.name; List<assignmentResult> data = new List<assignmentResult>(); var query = from x in db.assignmentResults where x.cid == cid && x.sid == id select x; foreach (var q in query) { assignmentResult a = new assignmentResult(); a.cid = q.cid; a.sid = q.sid; a.marksObtained = q.marksObtained; a.totalMarks = q.totalMarks; a.comment = q.comment; data.Add(a); } ViewBag.name = cname; return View(data); }
public void SaveUpdatedAssignmentResult(assignmentResult result) { db.Entry(result).State = EntityState.Modified; db.SaveChanges(); }