public JsonResult GetUpdateUserdetail(vewOperatorAlls dataDetail, List <vewOperatorLicense> dataLicenses,
string OpNo)
{
var _Result = "OK";
var _DataResult = "";
var _ResultLabel = true;
try
{
var dataOperator = new vewOperatorAlls();
mgrSQLcommand ObjRun = new mgrSQLcommand(_configuration);
string[] Result = ObjRun.GetUpdUserdetail(dataDetail, dataLicenses, OpNo, GetIp());
_ResultLabel = Convert.ToBoolean(Result[0]);
_Result = Result[1];
_DataResult = _Result != "OK" ? _Result : "";
}
catch (Exception e)
{
_ResultLabel = false;
_Result = "Error";
_DataResult = e.Message;
}
var jsonResult = Json(new
{ strResult = _Result, dataLabel = _DataResult, strboolbel = _ResultLabel, data = "" });
return(jsonResult);
}
public JsonResult GetActive()
{
List <SelectListItem> listItems = new List <SelectListItem>();
DataTable dt = new DataTable();
mgrSQLcommand ObjRun = new mgrSQLcommand(_configuration);
listItems.Add(new SelectListItem
{
Text = "Choose Active",
Value = ""
});
listItems.Add(new SelectListItem
{
Text = "Active job",
Value = "true"
});
listItems.Add(new SelectListItem
{
Text = "Resign",
Value = "false"
});
//}
return(Json(new MultiSelectList(listItems, "Value", "Text")));
}
public JsonResult GetAuthority()
{
List <SelectListItem> listItems = new List <SelectListItem>();
DataTable dt = new DataTable();
mgrSQLcommand ObjRun = new mgrSQLcommand(_configuration);
listItems.Add(new SelectListItem
{
Text = "Choose Authority",
Value = ""
});
listItems.Add(new SelectListItem
{
Text = "Administrator",
Value = "9"
});
listItems.Add(new SelectListItem
{
Text = "Employee",
Value = "0"
});
//}
return(Json(new MultiSelectList(listItems, "Value", "Text")));
}
public JsonResult GetGroupName()
{
List <SelectListItem> listItems = new List <SelectListItem>();
DataTable dt = new DataTable();
mgrSQLcommand ObjRun = new mgrSQLcommand(_configuration);
dt = ObjRun.GetGroupName();
if (dt.Rows.Count != 0)
{
listItems.Add(new SelectListItem()
{
Text = "Choose GroupName",
Value = ""
});
foreach (DataRow row in dt.Rows)
{
listItems.Add(new SelectListItem()
{
Text = row["GroupName"].ToString().Trim(),
Value = row["OperatorGroup"].ToString().Trim(),
});
}
}
return(Json(new MultiSelectList(listItems, "Value", "Text")));
}
public JsonResult GetDepartment(string strDivision)
{
List <SelectListItem> listItems = new List <SelectListItem>();
DataTable dt = new DataTable();
mgrSQLcommand ObjRun = new mgrSQLcommand(_configuration);
dt = ObjRun.GetDepartment(strDivision);
if (dt.Rows.Count != 0)
{
listItems.Add(new SelectListItem()
{
Text = "Choose Department",
Value = ""
});
foreach (DataRow row in dt.Rows)
{
listItems.Add(new SelectListItem()
{
Text = row["Department"].ToString().Trim(),
Value = row["SectionCode"].ToString().Trim(),
});
}
}
return(Json(new MultiSelectList(listItems, "Value", "Text")));
}
public JsonResult GetDataUserdetail(string opno)
{
var _Result = "OK";
var _DataResult = "";
var _ResultLabel = true;
vewOperatorAlls dataOperator = new vewOperatorAlls();
List <vewOperatorLicense> dataLicenses = new List <vewOperatorLicense>();
var data_ = _sptoDbContext.vewOperatorAll.FirstOrDefault(x => x.OperatorID == opno);
dataOperator = data_;
mgrSQLcommand ObjRun = new mgrSQLcommand(_configuration);
dataLicenses = ObjRun.GetUserLicense(opno);
_Result = dataOperator != null ? "OK" : "error";
_DataResult = _Result != "OK" ? "Data not found" : "";
ViewBag.NameEngUserDetail = dataOperator.NameEng;
ViewBag.JobTitleUserDetail = dataOperator.JobTitle;
var varsd = "http://10.29.1.12/RAJPTrainingControlSystem/PIC/" + opno + ".jpg";
ViewBag.imgProfileUserDetail = varsd;
var jsonResult = Json(new
{
strResult = _Result, dataLabel = _DataResult, strboolbel = _ResultLabel, data = dataOperator,
dataLicense = dataLicenses, DataProfile = varsd
});
return(jsonResult);
}
public IActionResult ModeExemList(string ItemCateg)
{
mgrSQLcommand ObjRun = new mgrSQLcommand(_configuration);
string strItemCateName = "";
DataTable dt = new DataTable();
dt = ObjRun.GetItemCateg(ItemCateg);
TempData["XX"] = ItemCateg;
strItemCateName = dt.Rows[0][2].ToString();
ViewBag.Itemcateg = ItemCateg;
ViewBag.ItemCateName = strItemCateName;
return(View());
}
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 JsonResult GetComtrolddl(string strCriteria)
{
ListSelectList_ listItems = new ListSelectList_();
mgrSQLcommand ObjRun = new mgrSQLcommand(_configuration);
string strresult = "";
try
{
listItems = ObjRun.GetPlaning(strCriteria);
}
catch (Exception e)
{
strresult = e.Message;
}
var jsonResult = Json(new { data = new MultiSelectList(listItems._ListSelectList, "Value", "Text"), dataResult = listItems.strResult });
return(jsonResult);
}
public JsonResult CommitExam(List <_ExamQuestionAnswer> ArrAns, string strItemCateg, string strItemInput, string OPID, string strStart)
{
string ItemCateg = strItemCateg;
string ItemInput = strItemInput;
string strOPID = OPID;
mgrSQLcommand ObjRun = new mgrSQLcommand(_configuration);
DateTime _strStartTime = Convert.ToDateTime(strStart);
string strStartTime = strStart;
string strEndTime = DateTime.Now.ToString();
string IP = Request.HttpContext.Connection.RemoteIpAddress.ToString();
_ExamCommitResult dt = new _ExamCommitResult();
dt = ObjRun.CommitExam(strOPID, ItemCateg, ItemInput, strStartTime, strEndTime, ArrAns, IP);
var jsonResult = Json(new { data = dt.strResult, dataResult = dt.strMgs, dataBool = dt.BoolResult });
return(jsonResult);
}
public JsonResult GetExamList(string itemCateg, string InputItem)
{
mgrSQLcommand ObjRun = new mgrSQLcommand(_configuration);
DataTable dt = new DataTable();
int strMinute = 0;
string Result = ObjRun.MakingExam(itemCateg, InputItem);
if (Result != "Error")
{
dt = ObjRun.GetInputItems(InputItem);
if (dt.Rows.Count != 0)
{
strMinute = Convert.ToInt32(dt.Rows[0]["TimeLimit"].ToString());
}
}
TempData["GG"] = DateTime.Now.ToString();
var jsonResult = Json(new { data = "OK", _strResult = Result, _strMinute = strMinute });
return(jsonResult);
}
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);
}
