Samples/MindDump/Castle.Applications.MindDump/Dao/PostDao.cs

   1 // Copyright 2004-2008 Castle Project - http://www.castleproject.org/
   2 //
   3 // Licensed under the Apache License, Version 2.0 (the "License");
   4 // you may not use this file except in compliance with the License.
   5 // You may obtain a copy of the License at
   6 //
   7 //     http://www.apache.org/licenses/LICENSE-2.0
   8 //
   9 // Unless required by applicable law or agreed to in writing, software
  10 // distributed under the License is distributed on an "AS IS" BASIS,
  11 // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  12 // See the License for the specific language governing permissions and
  13 // limitations under the License.
  14
  15 namespace Castle.Applications.MindDump.Dao
  16 {
  17         using System.Collections;
  18
  19         using Castle.Applications.MindDump.Model;
  20         using Castle.Facilities.NHibernateIntegration;
  21
  22         using NHibernate;
  23
  24         public class PostDao
  25         {
  26                 private readonly ISessionManager sessionManager;
  27
  28                 public PostDao(ISessionManager sessionManager)
  29                 {
  30                         this.sessionManager = sessionManager;
  31                 }
  32
  33                 public Post Create(Post post)
  34                 {
  35                         using(ISession session = sessionManager.OpenSession())
  36                         {
  37                                 session.Save(post);
  38
  39                                 return post;
  40                         }
  41                 }
  42
  43                 public void Update(Post post)
  44                 {
  45                         using(ISession session = sessionManager.OpenSession())
  46                         {
  47                                 session.Update(post);
  48                         }
  49                 }
  50
  51                 /// <summary>
  52                 /// Usually will be invoked only be the
  53                 /// test cases
  54                 /// </summary>
  55                 public void DeleteAll()
  56                 {
  57                         using(ISession session = sessionManager.OpenSession())
  58                         {
  59                                 session.Delete("from Post");
  60                         }
  61                 }
  62
  63                 public IList Find()
  64                 {
  65                         using(ISession session = sessionManager.OpenSession())
  66                         {
  67                                 return session.Find("from Post order by id desc");
  68                         }
  69                 }
  70
  71                 public IList Find(Blog blog)
  72                 {
  73                         using(ISession session = sessionManager.OpenSession())
  74                         {
  75                                 IList list = session.Find(
  76                                         "from Post as a where a.Blog.Id=:name", blog.Id, NHibernateUtil.Int64);
  77
  78                                 return list;
  79                         }
  80                 }
  81
  82                 public Post Find(long id)
  83                 {
  84                         using(ISession session = sessionManager.OpenSession())
  85                         {
  86                                 IList list = session.Find(
  87                                         "from Post as a where a.id=:name order by id desc", id, NHibernateUtil.Int64);
  88
  89                                 if (list.Count == 1)
  90                                 {
  91                                         return list[0] as Post;
  92                                 }
  93                                 else
  94                                 {
  95                                         return null;
  96                                 }
  97                         }
  98                 }
  99
 100                 public IList FindLatest(int howMany)
 101                 {
 102                         using(ISession session = sessionManager.OpenSession())
 103                         {
 104                                 IList list = session.Find("from Post order by id desc");
 105
 106                                 if (list.Count > howMany)
 107                                 {
 108                                         list = ListUtil.Limit(howMany, list);
 109                                 }
 110
 111                                 return list;
 112                         }
 113                 }
 114         }
 115 }