ru.bgcrm.dao

Class NewsDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.NewsDAO

public class NewsDAO
extends CommonDAO

Field Summary

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, dateFormat_DDMMYYYY, dateFormat_DDMMYYYY_HHMM, log, SQL_AND, SQL_DELETE, SQL_DESC, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_LEFT_JOIN, SQL_LIMIT, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UPDATE, SQL_WHERE

Constructor Summary

Constructors

Constructor and Description
NewsDAO(java.sql.Connection con)

Method Summary

Methods

Modifier and Type	Method and Description
void	deleteNews(int newsId)
News	getNews(int newsId)
java.util.List<News>	getNewsByUser(int userId, boolean popupOnly)
void	searchNewsList(SearchResult<News> searchResult, int userId, java.lang.Boolean read, java.lang.String text)
void	setNewsAllRead(int userId)
void	setNewsRead(int newsId, int userId, boolean value)
int	updateNews(News news)
void	updateNewsGroups(News news, java.util.Set<java.lang.Integer> groupIds)
void	updateNewsUsers(News news, java.util.Set<java.lang.Integer> userIds)

Methods inherited from class ru.bgcrm.dao.CommonDAO

addLikeSql, convertDateToSqlDate, convertDateToTimestamp, deleteById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

NewsDAO

public NewsDAO(java.sql.Connection con)

Method Detail

searchNewsList

public void searchNewsList(SearchResult<News> searchResult,
                  int userId,
                  java.lang.Boolean read,
                  java.lang.String text)
                    throws BGException

Throws:

BGException

getNews

public News getNews(int newsId)
             throws BGException

Throws:

BGException

getNewsByUser

public java.util.List<News> getNewsByUser(int userId,
                                 boolean popupOnly)
                                   throws BGException

Throws:

BGException

updateNews

public int updateNews(News news)
               throws BGException

Throws:

BGException

updateNewsUsers

public void updateNewsUsers(News news,
                   java.util.Set<java.lang.Integer> userIds)
                     throws BGException

Throws:

BGException

updateNewsGroups

public void updateNewsGroups(News news,
                    java.util.Set<java.lang.Integer> groupIds)
                      throws BGException

Throws:

BGException

setNewsRead

public void setNewsRead(int newsId,
               int userId,
               boolean value)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

setNewsAllRead

public void setNewsAllRead(int userId)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

deleteNews

public void deleteNews(int newsId)
                throws BGException

Throws:

BGException