public List <vewOperatorReqChange_Groupby> Get_ApprovedDetailGroup()
{
List <vewOperatorReqChange_Groupby> Detail = new List <vewOperatorReqChange_Groupby>();
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = "SELECT [DocNo] ,[ReqOperatorID] ,CONVERT(varchar, [ReqDate],120) as [ReqDate],count(*) as TotalJob FROM [SPTOSystem].[dbo].[vewOperatorReqChange]";
strSQL += " where [ChangeOperatorID] is null or [ChangeOperatorID] = '' group by[DocNo],[ReqOperatorID], CONVERT(varchar, [ReqDate], 120) order by CONVERT(varchar, [ReqDate], 120) desc ";
dt = ObjRun.GetDatatables(strSQL);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
Detail.Add(new vewOperatorReqChange_Groupby()
{
DocNo = row["DocNo"].ToString(),
ReqOperatorID = row["ReqOperatorID"].ToString(),
ReqDate = row["ReqDate"].ToString(),
TotalJob = Convert.ToInt32(row["TotalJob"].ToString()),
});
}
}
return(Detail);
}
public DataTable GetSectionCode(string strDivision, string strDepartment)
{
var ObjRun = new mgrSQLConnect(_configuration);
dt = new DataTable();
strSQL = "";
int Chk = 0;
strSQL += "SELECT [SectionCode],[Section],[Department],[Division]";
strSQL += "FROM [SPTOSystem].[dbo].[vewT_Section_Master] ";
if (strDivision != "" && strDivision != null)
{
strSQL += Chk == 0 ? " Where " : " and ";
strSQL += "Substring(sectionCode,1,1) = '" + strDivision + "'";
Chk++;
}
if (strDepartment != "" && strDepartment != null)
{
strSQL += Chk == 0 ? " Where " : " and ";
strSQL += "Substring(sectionCode,1,2) = '" + strDepartment + "'";
Chk++;
}
strSQL += "group by [SectionCode],[Section],[Department],[Division] ";
dt = ObjRun.GetDatatables(strSQL);
return(dt);
}
public List <SelectListItem> GetItemDropDownList(string StrSQL, string TextDisplay)
{
var ObjRun = new mgrSQLConnect(_configuration);
dt = ObjRun.GetDatatables(StrSQL);
List <SelectListItem> listItems = new List <SelectListItem>();
if (dt.Rows.Count != 0)
{
listItems.Add(new SelectListItem()
{
Text = "-- Choose " + TextDisplay + " --",
Value = "0"
});
foreach (DataRow row in dt.Rows)
{
listItems.Add(new SelectListItem()
{
Text = row[0].ToString().Trim(),
Value = row[1].ToString().Trim(),
});
}
}
return(listItems);
}
public List <reqeustInquiry> GetRequestList()
{
List <reqeustInquiry> Detail = new List <reqeustInquiry>();
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = "SELECT * FROM[SPTOSystem].[dbo].[vewOperatorReqChange]";
strSQL += " ";
dt = ObjRun.GetDatatables(strSQL);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
Detail.Add(new reqeustInquiry()
{
DocNo = row["DocNo"].ToString(),
OperatorID = row["OperatorID"].ToString(),
SectionCode = row["SectionCode"].ToString(),
SectionAttribute = row["SectionAttribute"].ToString(),
OperatorGroup = row["OperatorGroup"].ToString(),
License = row["License"].ToString(),
Active = row["Active"].ToString(),
ReqOperatorID = row["ReqOperatorID"].ToString(),
ReqDate = row["ReqDate"].ToString(),
ChangeOperatorID = row["ChangeOperatorID"].ToString(),
ChangeDate = row["ChangeDate"].ToString(),
});
}
}
return(Detail);
}
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 List <vewOperatorAdditionalDepTemp> GetUserDetail_Additional(string OPID)
{
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = "SELECT * FROM [SPTOSystem].[dbo].[vewOperatorAdditionalDepTemp] where [OperatorID] = '" + OPID + "' order by [SectionCode] asc ";
dt = ObjRun.GetDatatables(strSQL);
List <vewOperatorAdditionalDepTemp> Temp = new List <vewOperatorAdditionalDepTemp>();
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
Temp.Add(new vewOperatorAdditionalDepTemp()
{
OperatorID = row["OperatorID"].ToString(),
SectionCode = row["SectionCode"].ToString(),
Section = row["Section"].ToString(),
Department = row["Department"].ToString(),
Division = row["Division"].ToString(),
});
}
}
return(Temp);
}
public List <ItemCode_Detail> Get_ItemCode_TableDetail(string ItemCateg)
{
var ObjRun = new mgrSQLConnect(_configuration);
List <ItemCode_Detail> Detail = new List <ItemCode_Detail>();
strSQL = " select * FROM [SPTOSystem].[dbo].[vewItemCodeList] where ItemCateg = '" + ItemCateg.Trim() + "' order by ItemCode asc ";
dt = ObjRun.GetDatatables(strSQL);
if (dt.Rows.Count != 0)
{
foreach (DataRow row in dt.Rows)
{
Detail.Add(new ItemCode_Detail()
{
Nbr = Convert.ToInt32(row["Nbr"].ToString()),
ItemCateg = row["ItemCateg"].ToString(),
ItemCode = row["ItemCode"].ToString(),
ItemName = row["ItemName"].ToString(),
DisplayOrder = Convert.ToInt32(row["DisplayOrder"].ToString()),
TimeLimit = Convert.ToInt32(row["TimeLimit"].ToString()),
ValueCodeQuestion = row["ValueCodeQuestion"].ToString(),
ValueCodeAnswer = row["ValueCodeAnswer"].ToString(),
});
}
}
return(Detail);
}
public List <ExamApproved_Detail> Get_ExamDetail_Approved(string ValueCodeQuestion)
{
var ObjRun = new mgrSQLConnect(_configuration);
List <ExamApproved_Detail> Detail = new List <ExamApproved_Detail>();
strSQL = "SELECT [Seq],[Question],count(*) as Total_ANS ,[ValueStatus],Rewrite_Master FROM [SPTOSystem].[dbo].[vewQuestionAll]" +
" where [ValueCodeQuestion] ='" + ValueCodeQuestion + "' and[ValueStatus] != 'RUN' group by[Seq] ,[Question] ,[ValueStatus],[Rewrite_Master]";
dt = ObjRun.GetDatatables(strSQL);
if (dt.Rows.Count != 0)
{
foreach (DataRow row in dt.Rows)
{
Detail.Add(new ExamApproved_Detail()
{
Seq = Convert.ToInt32(row["Seq"].ToString()),
Question = row["Question"].ToString(),
Total_ANS = Convert.ToInt32(row["Total_ANS"].ToString()),
ValueStatus = row["ValueStatus"].ToString(),
Rewrite_Master = Convert.ToInt32(row["Rewrite_Master"].ToString()),
});
}
}
return(Detail);
}
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 List <vewOperatorReqChangeCompare> Get_ApprovedDetail(string DocNO)
{
List <vewOperatorReqChangeCompare> Detail = new List <vewOperatorReqChangeCompare>();
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = "SELECT [DocNo],[Nbr],[Seq],[OperatorID],[New_SectionCode],[New_Section],[New_SectionAttribute],[New_OperatorGroup],[New_GroupName],REPLACE([New_License], ';', ',') as [New_License]";
strSQL += " ,[New_Active],[ReqOperatorID],[GroupName],[SectionCode],[Section],[SectionAttribute] ,[License] ,[Active] ,CONVERT(varchar, [ReqDate],120) as [ReqDate] ,ChangeOperatorID ";
strSQL += " FROM[SPTOSystem].[dbo].[vewOperatorReqChangeCompare] where [DocNo] = '" + DocNO + "' and ([ChangeOperatorID] is null or [ChangeOperatorID] = '' ) ";
dt = ObjRun.GetDatatables(strSQL);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
Detail.Add(new vewOperatorReqChangeCompare()
{
DocNo = row["DocNo"].ToString(),
Nbr = Convert.ToInt32(row["Nbr"].ToString()),
Seq = row["Seq"].ToString(),
OperatorID = row["OperatorID"].ToString(),
New_SectionCode = row["New_SectionCode"].ToString(),
New_Section = row["New_Section"].ToString(),
New_SectionAttribute = row["New_SectionAttribute"].ToString(),
New_OperatorGroup = row["New_OperatorGroup"].ToString(),
New_GroupName = row["New_GroupName"].ToString(),
New_License = row["New_License"].ToString(),
New_Active = row["New_Active"].ToString(),
ReqOperatorID = row["ReqOperatorID"].ToString(),
GroupName = row["GroupName"].ToString(),
SectionCode = row["SectionCode"].ToString(),
Section = row["Section"].ToString(),
SectionAttribute = row["SectionAttribute"].ToString(),
License = row["License"].ToString(),
Active = row["Active"].ToString(),
ReqDate = row["ReqDate"].ToString(),
ChangeOperatorID = row["ChangeOperatorID"].ToString(),
//Nbr = Convert.ToInt32(row["Nbr"].ToString()),
//DocNo = row["DocNo"].ToString(),
//Seq = Convert.ToInt32(row["Seq"].ToString()),
//OperatorID = row["OperatorID"].ToString(),
//SectionCode = row["SectionCode"].ToString(),
//SectionAttribute = row["SectionAttribute"].ToString(),
//OperatorGroup = row["OperatorGroup"].ToString(),
//License = row["License"].ToString(),
//Active = row["Active"].ToString(),
//ReqOperatorID = row["ReqOperatorID"].ToString(),
//ReqDate = row["ReqDate"].ToString(),
//ChangeOperatorID = row["ChangeOperatorID"].ToString(),
//ChangeDate = row["ChangeDate"].ToString(),
});
}
}
return(Detail);
}
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 DataTable Get_ValueCode(string Itemcode)
{
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = "SELECT [ValueCodeQuestion] ,[ValueCodeAnswer] FROM[SPTOSystem].[dbo].[InputItem] where ItemCode = '" + Itemcode.Trim() + "'";
dt = ObjRun.GetDatatables(strSQL);
return(dt);
}
public DataTable Get_ValueCount(string ValueCodeQuestion)
{
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = "SELECT [ValueCodeQuestion] ,ISNULL([Seq],0) as [Seq],ItemName FROM[SPTOSystem].[dbo].[vewQuestionAll] where[ValueCodeQuestion] ='" + ValueCodeQuestion + "' group by[ValueCodeQuestion], [Seq],ItemName order by[Seq] desc";
dt = ObjRun.GetDatatables(strSQL);
return(dt);
}
public DataTable GetDivision_Additional()
{
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = "SELECT [Division] FROM[SPTOSystem].[dbo].[vewT_Section_Master] with(nolock) group by[Division] order by[Division] asc";
dt = ObjRun.GetDatatables(strSQL);
return(dt);
}
public DataTable InputItem_Detail(string Itemcode)
{
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = " select top 1 [ItemCode],[ValueCodeQuestion], [ValueCodeAnswer],[Rewrite] ,Convert(nvarchar(16),[UpdDate],120) as [UpdDate] FROM [SPTOSystem].[dbo].[InputItem] where [ItemCode] = '" + Itemcode.Trim() + "' order by [UpdDate] desc";
dt = ObjRun.GetDatatables(strSQL);
return(dt);
}
public DataTable GetSection_Additional(string DIV, string DEP)
{
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = "SELECT [Section],SectionCode FROM [SPTOSystem].[dbo].[vewT_Section_Master] with(nolock) ";
strSQL += "where Division = '" + DIV.Trim() + "' and [Department] = '" + DEP.Trim() + "' order by[Section] asc";
dt = ObjRun.GetDatatables(strSQL);
return(dt);
}
public string Get_ValueCodeAnswer(string valueCodeQuestion)
{
string valueCodeAnswer;
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = " select top 1 [ValueCodeAnswer] FROM [SPTOSystem].[dbo].[vewQuestionAll] where [ValueCodeQuestion] = '" + valueCodeQuestion.Trim() + "'";
dt = ObjRun.GetDatatables(strSQL);
valueCodeAnswer = dt.Rows[0][0].ToString();
return(valueCodeAnswer);
}
public string HTML_Question_Detail(string ValueQuestion, string ValueAnswer, int Seq, string Job)
{
string HTML_Test;
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = "[dbo].[sprEditQuestion_SelectHTML] '" + ValueQuestion.Trim() + "','" + ValueAnswer.Trim() + "','" + Seq.ToString() + "','0','" + Job + "' ";
dt = ObjRun.GetDatatables(strSQL);
HTML_Test = dt.Rows[0][0].ToString();
return(HTML_Test);
}
public string GetStroeTemp_Additional(string OPID, string MakerID, string SectionCode, string Job)
{
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = "EXEC [dbo].[sprOperatorSectionAttributeTemp] ";
strSQL += " '" + Job + "', '" + MakerID + "','" + OPID + "','" + SectionCode.Trim() + "' ";
DataTable dt = ObjRun.GetDatatables(strSQL);
string check = dt.Rows[0][0].ToString();
return(check);
}
public DataTable Get_ExamDetail(string Itemcode)
{
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = " select [ItemCode],ItemCategName,[ValueCodeQuestion],[ValueCodeAnswer],ISNULL(Seq,0) as Seq ,ISNULL([Question],'') as [Question] ,[InputItemName] ,count(*) as Ans_Count ";
strSQL += ",ISNULL((select max(Seq) FROM [SPTOSystem].[dbo].[vewQuestionAll] where[ItemCode] = '" + Itemcode.Trim() + "' and (Rewrite_ValueList = Rewrite_Master or Rewrite_ValueList = 0)),0) As Max_Seq ,[ValueStatus],Rewrite_Master,[Rewrite_ValueList],Convert(nvarchar(16),[UpdDate],120) as [UpdDate] FROM[SPTOSystem].[dbo].[vewQuestionAll] where[ItemCode] = '" + Itemcode.Trim() + "' ";
strSQL += " and (Rewrite_ValueList = Rewrite_Master or Rewrite_ValueList = 0) group by[ItemCode], ItemCategName,[ValueCodeQuestion],[ValueCodeAnswer],[Question],[Seq],[InputItemName] ,[ValueStatus],Rewrite_Master,[Rewrite_ValueList],Convert(nvarchar(16),[UpdDate],120) order by[ValueStatus],[ValueCodeQuestion], Seq";
dt = ObjRun.GetDatatables(strSQL);
return(dt);
}
public DataTable GetGroupName()
{
mgrSQLConnect ObjRun = new mgrSQLConnect(_configuration);
dt = new DataTable();
strSQL = "";
strSQL += "SELECT [OperatorGroup] ,[GroupName] FROM [SPTOSystem].[dbo].[OperatorGroup]";
dt = ObjRun.GetDatatables(strSQL);
return(dt);
}
public string View_Question(int seq, string ValueCodeQuestion, string ValueCodeAnswer, string ValueStatus)
{
string MS = "";
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = "[dbo].[sprMakeHTMLQuestion] '" + seq.ToString() + "','" + ValueCodeQuestion + "','" + ValueCodeAnswer + "','" + ValueStatus + "'";
dt = ObjRun.GetDatatables(strSQL);
MS = dt.Rows[0][0].ToString();
return(MS);
}
public string Valueslist_Management(string Job, string ValueCode, int Seq, string Value_HTML, string Value_TEXT, string Answer, string Need, string ComputerName, string OPID, string ValueQuestion, string ValueAnswer, int Rewrite)
{
string MS;
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = " [dbo].[sprValueList_Management] '" + Job + "', '" + ValueCode + "', '" + Seq + "', N'" + Value_HTML + "', N'" + Value_TEXT + "', " +
"'" + Answer + "', '" + Need + "', '" + ComputerName + "', '" + OPID + "', '" + ValueQuestion + "', '" + ValueAnswer + "','" + Rewrite.ToString() + "' ";
dt = ObjRun.GetDatatables(strSQL);
MS = dt.Rows[0][1].ToString();
return(MS);
}
public string OperatorReqChange(string Flag, string DocNo, string OperatorID, string SectionCode, string SectionAttribute, string OperatorGroup,
string License, string Active, string ReqOperatorID, string ChangeOperatorID)
{
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = "EXEC [dbo].[sprOperatorReqChange] ";
strSQL += " '" + Flag + "' ,'" + DocNo + "' ,'" + OperatorID + "','" + SectionCode + "' ,'" + SectionAttribute + "' ,'" + OperatorGroup + "' ,";
strSQL += "'" + License + "','" + Active + "' ,'" + ReqOperatorID + "' ,'" + ChangeOperatorID + "' ";
DataTable dt = ObjRun.GetDatatables(strSQL);
string check = dt.Rows[0][1].ToString();
return(check);
}
//public List<SelectListItem> GetCategory(string ItemCategType) {
// var ObjRun = new mgrSQLConnect(_configuration);
// strSQL = " SELECT[ItemCateg],[ItemCateg]+' - '+[ItemCategName] as [ItemCategName] FROM[SPTOSystem].[dbo].[ItemCategory] where ItemCategType ='"+ItemCategType.Trim()+"'group by[ItemCateg],[ItemCategName] order by ItemCateg asc";
// dt = ObjRun.GetDatatables(strSQL);
// List<SelectListItem> listItems = new List<SelectListItem>();
// if (dt.Rows.Count != 0)
// {
// listItems.Add(new SelectListItem()
// {
// Text = "--- Choose Category ---",
// Value = "0"
// });
// foreach (DataRow row in dt.Rows)
// {
// listItems.Add(new SelectListItem()
// {
// Text = row["ItemCategName"].ToString().Trim(),
// Value = row["ItemCateg"].ToString().Trim(),
// });
// }
// }
// return listItems;
//}
//public List<SelectListItem> GetCategType()
//{
// var ObjRun = new mgrSQLConnect(_configuration);
// strSQL = " SELECT ItemCategType FROM [SPTOSystem].[dbo].[ItemCategory] group by ItemCategType order by ItemCategType asc";
// dt = ObjRun.GetDatatables(strSQL);
// List<SelectListItem> listItems = new List<SelectListItem>();
// if (dt.Rows.Count != 0)
// {
// listItems.Add(new SelectListItem()
// {
// Text = "--- Choose Type ---",
// Value = ""
// });
// foreach (DataRow row in dt.Rows)
// {
// listItems.Add(new SelectListItem()
// {
// Text = row["ItemCategType"].ToString().Trim(),
// Value = row["ItemCategType"].ToString().Trim(),
// });
// }
// }
// return listItems;
//}
public string Itemcode_Management(string Job, string ItemCateg, string ItemCode, string ItemName, int time, int Nbr, string IP, string OPID, string ValueCodeQuestion, string ValueCodeAnswer)
{
string MS;
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = "EXEC [dbo].[sprItemCode_Management] '" + Job + "', '" + ItemCateg + "','" + ItemCode + "','" + ItemName + "','" + Nbr + "','" + time + "','" + OPID + "','" + IP + "' ,'" + ValueCodeQuestion + "' ,'" + ValueCodeAnswer + "' ";
dt = ObjRun.GetDatatables(strSQL);
MS = dt.Rows[0][0].ToString();
return(MS);
}
public DataTable GetDivision()
{
mgrSQLConnect ObjRun = new mgrSQLConnect(_configuration);
dt = new DataTable();
strSQL = "";
strSQL += "SELECT Substring(sectionCode,1,1) as sectionCode ,[Division] " +
"FROM [SPTOSystem].[dbo].[vewT_Section_Master] ";
strSQL += " group by Substring(sectionCode,1,1) ,[Division] ";
dt = ObjRun.GetDatatables(strSQL);
return(dt);
}
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 string GetExamHTML(string ItemCateg, string ItemCode)
{
string HTMLTEXT = "";
var ObjRun = new mgrSQLConnect(_configuration);
strSQL = " [dbo].[sprMakeHTMLExam] '"+ ItemCateg + "', '" + ItemCode + " '";
dt = ObjRun.GetDatatables(strSQL);
if (dt.Rows.Count > 0)
{
HTMLTEXT = dt.Rows[0][0].ToString();
}
return(HTMLTEXT);
}
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);
}