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 })); }