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