public JsonResult ShowComepare(int Nbr)
{
// try
// {
mgrSQLcommand_TEC_Approved ObjRun = new mgrSQLcommand_TEC_Approved(_configuration);
List <ReqChangeCompareData> DataShow = new List <ReqChangeCompareData>();
var draw = HttpContext.Request.Form["draw"].FirstOrDefault();
var start = Request.Form["start"].FirstOrDefault();
var length = Request.Form["length"].FirstOrDefault();
var sortColumn = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"]
.FirstOrDefault();
var sortColumnDir = Request.Form["order[0][dir]"].FirstOrDefault();
var searchValue = Request.Form["search[value]"].FirstOrDefault();
var pageSize = length != null?Convert.ToInt32(length) : 10;
var skip = start != null?Convert.ToInt32(start) : 0;
var recordsTotal = 0;
DataShow = ObjRun.GetCompareData(Nbr);
// var DataShow = _sptoDbContext.vewOperatorReqChange.Where(x => x.DocNo == DocNo).ToList();
// var dataShow = _sptoDbContext.vewOperatorAdditionalDep.Where(x => x.OperatorID == OPID).ToList();
var data = DataShow.ToList();
// return Json(new { success = true, data });
return(Json(new { draw, recordsFiltered = recordsTotal, recordsTotal, data }));
}
public IActionResult ApproveData(string [] Nbr_Array, string MakerID, string reqOperatorID)
{
string Nbr = "";
try
{
string Message = "";
mgrSQLcommand_TEC_Approved ObjRun = new mgrSQLcommand_TEC_Approved(_configuration);
for (int i = 0; i < Nbr_Array.Length; i++)
{
Nbr = Nbr_Array[i];
Message = ObjRun.OperatorReqChange("UPD", Nbr.Trim(), "", "", "", "", "", "", reqOperatorID.Trim(), MakerID.Trim());
}
if (Message == "OK")
{
return(Json(new { success = true, responseText = "Approved Data Success" }));
}
else
{
return(Json(new { success = false, responseText = Message }));
}
}
catch (Exception ex)
{
return(Json(new { success = false, responseText = ex.Message.ToString() }));
}
}
public JsonResult GetDataInquiry()
{
var _Result = "OK";
var _DataResult = "";
var _ResultLabel = true;
List <reqeustInquiry> dataOperator = new List <reqeustInquiry>();
mgrSQLcommand_TEC_Approved ObjRun = new mgrSQLcommand_TEC_Approved(_configuration);
dataOperator = ObjRun.GetRequestList();
var jsonResult = Json(new
{ strResult = _Result, dataLabel = _DataResult, strboolbel = _ResultLabel, data = dataOperator });
return(jsonResult);
}
public IActionResult GetFullDetail(string DocNo)
{
// try
// {
mgrSQLcommand_TEC_Approved ObjRun = new mgrSQLcommand_TEC_Approved(_configuration);
List <vewOperatorReqChangeCompare> DataShow = new List <vewOperatorReqChangeCompare>();
var draw = HttpContext.Request.Form["draw"].FirstOrDefault();
var start = Request.Form["start"].FirstOrDefault();
var length = Request.Form["length"].FirstOrDefault();
var sortColumn = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"]
.FirstOrDefault();
var sortColumnDir = Request.Form["order[0][dir]"].FirstOrDefault();
var searchValue = Request.Form["search[value]"].FirstOrDefault();
var pageSize = length != null?Convert.ToInt32(length) : 10;
var skip = start != null?Convert.ToInt32(start) : 0;
var recordsTotal = 0;
DataShow = ObjRun.Get_ApprovedDetail(DocNo);
// var DataShow = _sptoDbContext.vewOperatorReqChange.Where(x => x.DocNo == DocNo).ToList();
// var dataShow = _sptoDbContext.vewOperatorAdditionalDep.Where(x => x.OperatorID == OPID).ToList();
var data = DataShow.ToList();
// return Json(new { success = true, data });
return(Json(new { draw, recordsFiltered = recordsTotal, recordsTotal, data }));
//}
//catch (Exception ex)
//{
// return Json(new { success = false, responseText = ex.Message.ToString() });
//}
}
