public JsonResult GetAllLinks()
{
SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@UserNameFilter", "") };
var list = Json(RDFacadeExtensions.GetModelFromQuery <DTO_menubyuser>(_context, "Exec SDR_QFS_AllLinks", parms));
return(list);
}
public JsonResult GetLinkById(int TopicUserId, string username)
{
SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@UserNameFilter", username) };
var list = RDFacadeExtensions.GetModelFromQuery <DTO_menubyuser>(_context, "Exec dbo.SDR_QFS_MenuByUser @UserNameFilter", parms);
list = list.Where(p => p.TopicUserID == TopicUserId);
return(Json(list));
}
public JsonResult GetSingleLink(SDR_QFS_Data data)
{
if (data.TID <= 0)
{
return(this.Json(null));
}
SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@TopicFilter", data.TID) };
var list = RDFacadeExtensions.GetModelFromQuery <SDR_QFS_Data>(_context, "Exec dbo.SDR_QFS_Topic @TopicFilter", parms);
return(Json(list));
}
public ActionResult EditUser(string SearchParam, int CurrentPage, string CurrentFilter)
{
if (string.IsNullOrEmpty(SearchParam))
{
return((ActionResult)this.View());
}
ViewBag.Message = "Edit User";
ViewBag.CurrentPage = "";
ViewBag.CurrentFilter = "";
SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@UserNameFilter", SearchParam) };
var list = Json(RDFacadeExtensions.GetModelFromQuery <DTO_user>(_context, "Exec SDR_QFS_userByUsername @UserNameFilter", parms));
return(View("EditUser", list));
}
public JsonResult Details(string SearchParam, int CurrentPage, string CurrentFilter)
{
if (string.IsNullOrEmpty(SearchParam))
{
return(this.Json(null));
}
else
{
ViewBag.Message = "Details";
ViewBag.Page = CurrentPage;
ViewBag.CurrentUser = CurrentFilter;
ViewBag.SearchParam = SearchParam;
SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@UserNameFilter", SearchParam) };
var list = RDFacadeExtensions.GetModelFromQuery <DTO_user>(_context, "Exec dbo.SDR_QFS_MenuSP @UserNameFilter", parms);
ViewBag.TotalRecords = list.Count();
return(Json(list));
}
}
public ActionResult Detailsview(string SearchParam, int CurrentPage, string CurrentFilter)
{
IEnumerable <DTO_menubyuser> list;
if (string.IsNullOrEmpty(SearchParam))
{
return((ActionResult)this.View("Details"));
}
else
{
SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@UserNameFilter", SearchParam) };
list = RDFacadeExtensions.GetModelFromQuery <DTO_menubyuser>(_context, "Exec SDR_QFS_MenuByUser @UserNameFilter", parms);
ViewBag.CurrentUser = SearchParam;
ViewBag.page = CurrentPage;
ViewBag.CurrentFilter = CurrentFilter;
}
return(View("Details", list));
}
public ActionResult CopyUserLinks(string currentuser, string copyTo)
{
if (!ModelState.IsValid)
{
return((ActionResult)this.View("Index", currentuser));
}
else
{
if (!string.IsNullOrEmpty(currentuser) && !string.IsNullOrEmpty(copyTo))
{
SqlParameter parm1 = new SqlParameter("@copyfrom", currentuser);
SqlParameter parm2 = new SqlParameter("@copyto", copyTo);
SqlParameter[] parms = { parm1, parm2 };
var list = Json(RDFacadeExtensions.GetModelFromQuery <SDR_QFS_Data>(_context, "exec dbo.SDR_QFS_CopyLinks @copyfrom, @copyto", parms));
}
}
//return (ActionResult)this.RedirectToAction("UserList", new { sortOrder = "", currentFilter = copyTo, searchString = copyTo });
return(RedirectToAction("Index", new { sortOrder = "", currentFilter = copyTo, searchString = copyTo }));
}
