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