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