Example #1
0
        public static CustomList <LatestNews> GetAllLatestNewsForDisplay()
        {
            ConnectionManager       conManager           = new ConnectionManager(ConnectionName.HR);
            CustomList <LatestNews> LatestNewsCollection = new CustomList <LatestNews>();
            IDataReader             reader = null;
            String sql = "Exec GetLatestNews";

            try
            {
                conManager.OpenDataReader(sql, out reader);
                while (reader.Read())
                {
                    LatestNews newLatestNews = new LatestNews();
                    newLatestNews.NewsDetails = reader.GetString("NewsDetails");
                    LatestNewsCollection.Add(newLatestNews);
                }
                return(LatestNewsCollection);
            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally
            {
                if (reader != null && !reader.IsClosed)
                {
                    reader.Close();
                }
            }
        }
Example #2
0
        public static CustomList <LatestNews> GetAllLatestNews()
        {
            ConnectionManager       conManager           = new ConnectionManager(ConnectionName.HR);
            CustomList <LatestNews> LatestNewsCollection = new CustomList <LatestNews>();
            IDataReader             reader = null;
            const String            sql    = "select *from LatestNews";

            try
            {
                conManager.OpenDataReader(sql, out reader);
                while (reader.Read())
                {
                    LatestNews newLatestNews = new LatestNews();
                    newLatestNews.SetData(reader);
                    LatestNewsCollection.Add(newLatestNews);
                }
                LatestNewsCollection.InsertSpName = "spInsertLatestNews";
                LatestNewsCollection.UpdateSpName = "spUpdateLatestNews";
                LatestNewsCollection.DeleteSpName = "spDeleteLatestNews";
                return(LatestNewsCollection);
            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally
            {
                if (reader != null && !reader.IsClosed)
                {
                    reader.Close();
                }
            }
        }