public ActionResult Search(NewsListModels newsList)
{
MstNewsTypeDAO newsTypeDAO = new MstNewsTypeDAO(this.mapper);
MstNewsTypeModels allType = new MstNewsTypeModels();
newsList.newsTypeModelsList = newsTypeDAO.GetAll();
newsList.newsTypeModelsList.Insert(0, allType);
NewNewsDAO newsDAO = new NewNewsDAO(this.mapper);
newsList.newsList = newsDAO.SearchNews(
newsList.newsTitle // newsTitle
, newsList.newsTypeCode // newsTypeCode
, newsList.newsContent // newsContent
, newsList.isInactive // status
, newsList.isAuthenticate // type
, newsList.pageIndex
);
newsList.recordCount = newsDAO.SearchCountNews(
newsList.newsTitle // newsTitle
, newsList.newsTypeCode // newsTypeCode
, newsList.newsContent // newsContent
, newsList.isInactive // status
, newsList.isAuthenticate // type
);
return View("Index", newsList);
}
public NewsListModels SearchNewsList(
string newsTitle
, string newsTypeCode
, string newsContent
, bool isAuthenticate
, bool isInactive
, int pageIndex
, string language
)
{
NewsListModels result = new NewsListModels();
Dictionary<string, object> param = new Dictionary<string, object>();
if (!StringUtils.IsEmpty(newsTitle))
{
param.Add("newsTitle", newsTitle.ToUpper());
}
if (!StringUtils.IsEmpty(newsContent))
{
param.Add("newsContent", newsContent.ToUpper());
}
if (!StringUtils.IsEmpty(newsTypeCode))
{
param.Add("newsTypeCode", newsTypeCode);
}
if (isAuthenticate)
{
param.Add("newsType", Constants.Type.Authority);
}
else
{
param.Add("newsType", Constants.Type.Public);
}
if (isInactive)
{
param.Add("newsStatus", Constants.Status.Inactive);
}
else
{
param.Add("newsStatus", Constants.Status.Active);
}
int maxItemPerPage = Constants.MaxNewsPerPage;
param.Add("max", pageIndex * maxItemPerPage);
param.Add("offset", (pageIndex - 1) * maxItemPerPage + 1);
param.Add("localeID", language);
result.newsList = mapper.QueryForList<NewsModels>("New.selectNews", param);
result.recordCount = this.SearchCountNews(newsTitle
, newsTypeCode
, newsContent
, isAuthenticate
, isInactive);
if (result.recordCount % Constants.Chart.NumberChartPerPage == 0)
{
result.totalPage = result.recordCount / maxItemPerPage;
}
else
{
result.totalPage = result.recordCount / maxItemPerPage + 1;
}
if (result.newsList != null)
{
foreach (NewsModels news in result.newsList)
{
if (news.newsImage != null)
{
news.newsImageContent = Convert.ToBase64String(news.newsImage);
}
}
}
result.pageIndex = pageIndex;
//if (result.newsList != null)
//{
// for (int i=0; i<result.newsList.Count; i++)
// {
// NewsModels obj = result.newsList[i];
// obj.newsContent = string.Empty;
// obj = TranslateUtils.TranslateNews(obj, language);
// }
//}
return result;
}
