public ActionResult List() { if (DataMemory.CurrentUser == null) { return(RedirectToAction("Logout", "Admin")); } var request = new SearchNewsRequest { CurrentPage = 1, Start = 1, End = ConfigInfo.RecordOnPage, OrderBy = "CreateDate", OrderByType = "DESC" }; return(View(SearchNews(request))); }
private ListNews SearchNews(SearchNewsRequest request) { var total = 0; var ds = _newsDa.Search(request, ref total); var lstNew = CBO.Fill2ListFromDataSet <News>(ds, typeof(News)); decimal totalPage = Math.Ceiling(((decimal)total / (decimal)ConfigInfo.RecordOnPage)); var paging = HtmlControllHelpers.WritePaging(totalPage, request.CurrentPage, total, ConfigInfo.RecordOnPage, "Tin tức"); var listNews = new ListNews { Start = request.Start, Collection = lstNew, Paging = paging, TotalRecord = total, TotalPage = totalPage, CurrentPage = request.CurrentPage }; return(listNews); }
public DataSet Search(SearchNewsRequest model, ref int pTotal) { try { var spParameter = new SqlParameter[6]; #region Set param var parameter = new SqlParameter("@P_ORDER_BY", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = model.OrderBy }; spParameter[0] = parameter; parameter = new SqlParameter("@P_ORDER_TYPE", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = model.OrderByType }; spParameter[1] = parameter; parameter = new SqlParameter("@P_START", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = model.Start }; spParameter[2] = parameter; parameter = new SqlParameter("@P_END", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = model.End }; spParameter[3] = parameter; parameter = new SqlParameter("@P_CREATE_DATE", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = model.CreateDate }; spParameter[4] = parameter; parameter = new SqlParameter("@P_TOTAL", SqlDbType.Int) { Direction = ParameterDirection.Output, Value = -1 }; spParameter[5] = parameter; #endregion var ds = SqlHelper.ExecuteDataset(ConfigInfo.ConnectString, CommandType.StoredProcedure, "PROC_PAGE_SEARCH", spParameter); pTotal = Convert.ToInt32(spParameter[5].Value); return(ds); } catch (Exception ex) { Logger.Log.Error(ex.ToString()); return(new DataSet()); } }
public ActionResult Search(SearchNewsRequest request) { return(PartialView("~/Areas/Admin/Views/News/_listNews.cshtml", SearchNews(request))); }