public string MakingExam(string strItemCateg, string strItemCode) { dt = new DataTable(); mgrSQLConnect ObjRun = new mgrSQLConnect(_configuration); ResultItemCateg ResultOPcateg = new ResultItemCateg(); List <_OperatorItemCateg> dataList = new List <_OperatorItemCateg>(); string Result = ""; try { strSQL = ""; strSQL += "sprMakeHTMLExam"; strSQL += " N'" + strItemCateg + "',"; strSQL += " N'" + strItemCode + "'"; dt = ObjRun.GetDatatables(strSQL); if (dt.Rows.Count != 0) { Result = dt.Rows[0][0].ToString(); } else { Result = "Error"; } } catch (Exception e) { Result = e.Message; } return(Result); }
public DataTable GetItemCateg(string strItemCateg) { dt = new DataTable(); mgrSQLConnect ObjRun = new mgrSQLConnect(_configuration); ResultItemCateg ResultOPcateg = new ResultItemCateg(); List <_OperatorItemCateg> dataList = new List <_OperatorItemCateg>(); try { strSQL = ""; strSQL += "SELECT * FROM [SPTOSystem].[dbo].[ItemCategory]"; strSQL += " where ItemCateg ='" + strItemCateg + "'"; dt = ObjRun.GetDatatables(strSQL); if (dt.Rows.Count != 0) { strSQL = "XX"; } else { strSQL = "aaa"; } } catch (Exception) { dt = null; } return(dt); }
public JsonResult GetInputItem(string itemCateg) { var UserName = User.Identity.Name; _OperatorItemCateg dataOperator = new _OperatorItemCateg(); DataTable dt = new DataTable(); mgrSQLcommand ObjRun = new mgrSQLcommand(_configuration); //List<_OperatorItemCateg> dataList = new List<_OperatorItemCateg>(); ResultItemCateg ResultOPcateg = new ResultItemCateg(); ResultOPcateg = ObjRun.GetInputItemList(itemCateg, UserName); var jsonResult = Json(new { data = ResultOPcateg._listOpCateg, _strResult = ResultOPcateg.strResult }); return(jsonResult); }
public ResultItemCateg GetOperatorItemCateg(string Opid) { dt = new DataTable(); mgrSQLConnect ObjRun = new mgrSQLConnect(_configuration); ResultItemCateg ResultOPcateg = new ResultItemCateg(); List <_OperatorItemCateg> dataList = new List <_OperatorItemCateg>(); try { strSQL = ""; //strSQL += "SELECT * FROM [SPTOSystem].[dbo].[vewItemCategPlan]"; // strSQL += " where OperatorID ='" + Opid + "'"; strSQL += "sprGetExamMode"; strSQL += "''"; strSQL += ",'" + Opid + "'"; strSQL += ",'Licence'"; dt = ObjRun.GetDatatables(strSQL); if (dt.Rows.Count != 0) { foreach (DataRow row in dt.Rows) { dataList.Add(new _OperatorItemCateg() { ItemCateg = row["ItemCateg"].ToString().Trim(), ItemCategName = row["ItemCategName"].ToString().Trim(), cntItemCateg = row["cntItemCateg"].ToString().Trim(), }); } ResultOPcateg._listOpCateg = dataList; ResultOPcateg.strResult = "OK"; } else { ResultOPcateg.strResult = "No exam found <br/> ไม่พบข้อสอบ"; } } catch (Exception e) { ResultOPcateg.strResult = e.Message + " :: " + strSQL; } return(ResultOPcateg); }
public ResultItemCateg GetInputItemList(string strItemCateg, string OPID) { dt = new DataTable(); mgrSQLConnect ObjRun = new mgrSQLConnect(_configuration); ResultItemCateg ResultOPcateg = new ResultItemCateg(); List <_OperatorItemCateg> dataList = new List <_OperatorItemCateg>(); try { strSQL = ""; strSQL += "sprGetExamMode"; strSQL += "'" + strItemCateg + "'"; strSQL += ",'" + OPID + "'"; strSQL += ",'Mode'"; dt = ObjRun.GetDatatables(strSQL); if (dt.Rows.Count != 0) { foreach (DataRow row in dt.Rows) { dataList.Add(new _OperatorItemCateg() { ItemCateg = row["ItemCode"].ToString().Trim(), ItemCategName = row["ItemName"].ToString().Trim(), cntItemCateg = row["TimeLimit"].ToString().Trim(), }); } ResultOPcateg._listOpCateg = dataList; ResultOPcateg.strResult = "OK"; } else { ResultOPcateg.strResult = "Err :" + strSQL; } } catch (Exception e) { ResultOPcateg.strResult = e.Message; } return(ResultOPcateg); }
public DataTable GetInputItems(string strItemCode) { dt = new DataTable(); mgrSQLConnect ObjRun = new mgrSQLConnect(_configuration); ResultItemCateg ResultOPcateg = new ResultItemCateg(); List <_OperatorItemCateg> dataList = new List <_OperatorItemCateg>(); try { strSQL = ""; strSQL += "SELECT * FROM [SPTOSystem].[dbo].[InputItemList]"; strSQL += " where ItemCode ='" + strItemCode + "'"; dt = ObjRun.GetDatatables(strSQL); } catch (Exception) { dt = null; } return(dt); }