public _ExamResultList GetDataExamResultList(_excamResultCtrl strCtrl)
{
_ExamResultList resultList = new _ExamResultList();
mgrSQLConnect ObjRun = new mgrSQLConnect(_configuration);
List <_ExamResultDetail> listItems = new List <_ExamResultDetail>();
dt = new DataTable();
strSQL = "";
try
{
strSQL = "sprExamResultInquiry ";
strSQL += " '" + strCtrl.PlanRefID + "',";
strSQL += " '" + strCtrl.ItemCateg + "',";
strSQL += " '" + strCtrl.ItemCode + "',";
strSQL += " '" + strCtrl.OperatorID + "',";
strSQL += " '" + strCtrl.StartTime + "',";
strSQL += " '" + strCtrl.EndTime + "'";
dt = ObjRun.GetDatatables(strSQL);
if (dt.Rows.Count != 0)
{
foreach (DataRow row in dt.Rows)
{
listItems.Add(new _ExamResultDetail()
{
PlanRefID = row["PlanRefID"].ToString().Trim(),
ItemCateg = row["ItemCateg"].ToString().Trim(),
ItemCategName = row["ItemCategName"].ToString().Trim(),
ItemCode = row["ItemCode"].ToString().Trim(),
ItemName = row["ItemName"].ToString().Trim(),
OperatorID = row["OperatorID"].ToString().Trim(),
OperatorName = row["OperatorName"].ToString().Trim(),
Minutes = row["Minutes"].ToString().Trim(),
StartTime = row["StartTime"].ToString().Trim(),
EndTime = row["EndTime"].ToString().Trim(),
Level = row["Level"].ToString().Trim(),
Correct = row["Correct"].ToString().Trim(),
Wrong = row["Wrong"].ToString().Trim(),
Total = row["Total"].ToString().Trim(),
Results = row["Results"].ToString().Trim(),
AddDate = row["AddDate"].ToString().Trim(),
});
}
resultList.DataExamReultList = listItems;
resultList.strResult = "OK";
}
else
{
resultList.strResult = "Data not found";
}
}
catch (Exception e)
{
resultList.strResult = "Error : " + e.Message;
}
return(resultList);
}
public JsonResult GetExamResultList(_excamResultCtrl strCtrl)
{
DateTime test = Convert.ToDateTime(strCtrl.EndTime);
mgrSQLcommand ObjRun = new mgrSQLcommand(_configuration);
_ExamResultList listItems = new _ExamResultList();
string strresult = "";
try
{
listItems = ObjRun.GetDataExamResultList(strCtrl);
}
catch (Exception e)
{
strresult = e.Message;
}
var jsonResult = Json(new { data = listItems.DataExamReultList, strResult = listItems.strResult });
//var jsonResult = Json(new { data="" });
return(jsonResult);
}
