private ListNews SearchNewsForPortal(PortalSearchNews portalSearchNews, out News news)
{
news = new News();
var total = 0;
var ds = _newsDa.GetForPortalIndex(portalSearchNews, ref total);
//var list = CBO.Fill2ListFromDataSet<News>(ds, typeof(News));
List <News> list = CBO <News> .FillCollectionFromDataSet(ds);
var totalPage = Math.Ceiling((decimal)total / ConfigInfo.RecordOnPageIndex);
var paging = HtmlControllHelpers.WritePagingPortal(totalPage, portalSearchNews.CurrentPage, total,
ConfigInfo.RecordOnPageIndex);
var listNews = new ListNews
{
Start = portalSearchNews.Start,
Collection = list,
Paging = paging,
TotalRecord = total,
TotalPage = totalPage,
CurrentPage = portalSearchNews.CurrentPage
};
ds = _newsDa.GetSpecialNews();
news = (News)CBO.FillObjectFromDataSet(ds, typeof(News));
return(listNews);
}
public ActionResult ListNews()
{
var portalSearchNews = new PortalSearchNews
{
CurrentPage = 1,
Start = 1,
End = ConfigInfo.RecordOnPageIndex
};
News news;
var listNews = SearchNewsForPortal(portalSearchNews, out news);
ViewBag.SpecialNews = news;
return(View(listNews));
}
public ActionResult SearchNewsPortal(int index)
{
if (index <= 0)
{
return(View("ListNews", new ListNews()));
}
var portalSearchNews = new PortalSearchNews
{
CurrentPage = index,
Start = (index - 1) * ConfigInfo.RecordOnPageIndex + 1,
End = index * ConfigInfo.RecordOnPageIndex
};
News news;
var listNews = SearchNewsForPortal(portalSearchNews, out news);
ViewBag.SpecialNews = news;
return(View("ListNews", listNews));
}
public DataSet GetForPortalIndex(PortalSearchNews request, ref int pTotal)
{
try
{
var spParameter = new SqlParameter[3];
var parameter = new SqlParameter("@P_START", SqlDbType.VarChar)
{
Direction = ParameterDirection.Input,
Value = request.Start
};
spParameter[0] = parameter;
parameter = new SqlParameter("@P_END", SqlDbType.VarChar)
{
Direction = ParameterDirection.Input,
Value = request.End
};
spParameter[1] = parameter;
parameter = new SqlParameter("@P_TOTAL", SqlDbType.Int)
{
Direction = ParameterDirection.Output,
Value = -1
};
spParameter[2] = parameter;
var ds = SqlHelper.ExecuteDataset(ConfigInfo.ConnectString, CommandType.StoredProcedure,
"PROC_NEWS_GET_VIEW", spParameter);
pTotal = Convert.ToInt32(spParameter[2].Value);
return(ds);
}
catch (Exception ex)
{
Logger.Log.Error(ex.ToString());
return(new DataSet());
}
}
