public ActionResult Reference()
{
ViewBag.total = 0;
string linkid;
using (var context = new AssessmentEntities())
{
try
{
linkid = Request.QueryString["linkid"].ToString();
var VerifyLink = context.ASSESSMENT_LINK.Where(link => link.RANDOM_STRING == linkid).ToList();
if (VerifyLink.Count == 1)
{
var linkDetails = VerifyLink.First();
var result = context.spRUBRICGETSEARCHRESULTS(linkDetails.DEPARTMENT_CD, linkDetails.OUTCOMES).ToList();
var rubRowID = result.Select(rubrowID => rubrowID.RUBRIC_ROWID.ToString()).ToList();
Session["RubRowIDS"] = rubRowID;
foreach (var item in rubRowID)
{
Session[item] = "0-0-0-0";
}
result.First().Instructor_EmailID = linkDetails.INSTRUCTOR_EMAILID;
return View(result);
}
else
{
ViewBag.ErrorMsg = "Invalid URL. Please check the Link again";
return View("Error");
}
}
catch (Exception ex)
{
ViewBag.ErrorMsg = "Unable to fetch data. Please contact the Assessment officer";
return View("Error");
}
}
}
public ActionResult Search(FormCollection f)
{
using (var context = new AssessmentEntities())
{
try
{
string Outcomes = f["Outcomes"].ToString();
string deptSelected = f["DEPARTMENT"].ToString();
var result = context.spRUBRICGETSEARCHRESULTS(deptSelected, Outcomes).ToList();
//saving variables for emailing
Session["Outcome"] = Outcomes;
Session["DEPARTMENT"] = deptSelected;
return PartialView("_Search", result);
}
catch (Exception ex)
{
Response.Write(ex.Message);
ViewBag.ErrorMsg = "Bad selection. No such rubric exist.";
return View("Error");
}
}
}
public PartialViewResult getRubricDetails(spRUBRICSGETRECORD_RUBID_Result rubricRecord, AssessmentEntities context)
{
var results = context.spRUBRICGETSEARCHRESULTS(rubricRecord.DEPARTMENT_CD, rubricRecord.OUTCOMES).SingleOrDefault();
return PartialView("_Search", results);
}