public JsonResult GetSection_Addition(string DIV, string DEP)
{
List <SelectListItem> listItems = new List <SelectListItem>();
DataTable dt = new DataTable();
mgrSQLcommand_Additional ObjRun = new mgrSQLcommand_Additional(_configuration);
dt = ObjRun.GetSection_Additional(DIV, DEP);
if (dt.Rows.Count != 0)
{
listItems.Add(new SelectListItem()
{
Text = "Choose Section",
Value = "0"
});
foreach (DataRow row in dt.Rows)
{
listItems.Add(new SelectListItem()
{
Text = row["SectionCode"].ToString().Trim() + "-" + row["Section"].ToString().Trim(),
Value = row["SectionCode"].ToString().Trim(),
});
}
}
return(Json(new MultiSelectList(listItems, "Value", "Text")));
}
// [HttpPost]
public JsonResult GetMakeTemp_Additional(string OPID, string MakerID)
{
mgrSQLcommand_Additional ObjRun = new mgrSQLcommand_Additional(_configuration);
string Message;
Message = ObjRun.GetStroeTemp_Additional(OPID, MakerID, "", "VEW");
if (Message == "OK")
{
return(Json(new { success = true }));
}
return(Json(new { success = false }));
}
public IActionResult DeleteSectionCode_Additional(string OPID, string MakerID, string[] SectionCode)
{
mgrSQLcommand_Additional ObjRun = new mgrSQLcommand_Additional(_configuration);
try
{
foreach (string Code in SectionCode)
{
ObjRun.GetStroeTemp_Additional(OPID, MakerID, Code, "DEL");
}
}
catch (Exception ex)
{
return(Json(new { success = false, responseText = ex.Message.ToString() }));
}
return(Json(new { success = true, responseText = "Delete Data success" }));
}
public IActionResult Load_OperatorAdditional_Detail(string OPID)
{
mgrSQLcommand_Additional ObjRun = new mgrSQLcommand_Additional(_configuration);
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;
DataTable dt = new DataTable();
// var dataShow = _sptoDbContext.vewOperatorAdditionalDep.Where(x => x.OperatorID == OPID).ToList();
List <vewOperatorAdditionalDepTemp> TempData = new List <vewOperatorAdditionalDepTemp>();
TempData = ObjRun.GetUserDetail_Additional(OPID);
var DataShow = (from tempdata in TempData
select tempdata);
// var data = DataShow.ToList();
var data = DataShow.Skip(skip).Take(pageSize).ToList();
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }));
// return Json(new {draw, recordsFiltered = recordsTotal, recordsTotal, data });
//}
//catch (Exception ex)
//{
// return Json(new { success = false, responseText = ex.Message.ToString() });
//}
}
public IActionResult Save_Additional(string OPID, string MakerID)
{
mgrSQLcommand_Additional ObjRun = new mgrSQLcommand_Additional(_configuration);
string Message_ = "";
try
{
Message_ = ObjRun.GetStroeTemp_Additional(OPID, MakerID, "", "SVE");
if (Message_ == "OK")
{
return(Json(new { success = true, responseText = "Save data success" }));
}
else
{
return(Json(new { success = false, responseText = Message_ }));
}
}
catch (Exception ex)
{
return(Json(new { success = false, responseText = ex.Message.ToString() }));
}
}
