Guest User

Untitled

a guest
Sep 20th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.08 KB | None | 0 0
  1. using System.Collections.Generic;
  2. using Castle.Facilities.NHibernateIntegration;
  3. using Demo.Domain;
  4. using Demo.Domain.Repositories;
  5. using NHibernate.Criterion;
  6.  
  7. namespace Demo.Data.Repositories
  8. {
  9. public class BankRepository : NHRepository<Bank>, IBankRepository
  10. {
  11. public BankRepository(ISessionManager sessionManager) : base(sessionManager)
  12. { }
  13.  
  14. public Bank GetBankByName(string name)
  15. {
  16. var session = _sessionManager.OpenSession();
  17. return session.CreateCriteria(typeof(Bank))
  18. .Add(Restrictions.Eq("Name", name))
  19. .UniqueResult<Bank>();
  20. }
  21.  
  22. public IList<Bank> GetBankNameBeginsWith(string partialName)
  23. {
  24. var session = _sessionManager.OpenSession();
  25. return session.CreateCriteria(typeof(Bank))
  26. .Add(Restrictions.Like("Name", partialName, MatchMode.Start))
  27. .List<Bank>();
  28. }
  29.  
  30. public Bank GetBankByCode(string code)
  31. {
  32. var session = _sessionManager.OpenSession();
  33. return session.CreateCriteria(typeof(Bank))
  34. .Add(Restrictions.Eq("Code", code))
  35. .UniqueResult<Bank>();
  36. }
  37.  
  38. public Bank GetBankByShortName(string shortName)
  39. {
  40. var session = _sessionManager.OpenSession();
  41. return session.CreateCriteria(typeof(Bank))
  42. .Add(Restrictions.Eq("ShortName", shortName))
  43. .UniqueResult<Bank>();
  44. }
  45.  
  46. public Bank GetBankByAccountNumber(string accountNumber)
  47. {
  48. var session = _sessionManager.OpenSession();
  49. return session.CreateCriteria(typeof(Bank))
  50. .Add(Restrictions.Eq("AccountNumber", accountNumber))
  51. .UniqueResult<Bank>();
  52. }
  53.  
  54. public IList<Bank> GetBankByDivisionCode(string divisionCode)
  55. {
  56. var session = _sessionManager.OpenSession();
  57. return session.CreateCriteria(typeof(Bank))
  58. .Add(Restrictions.Eq("DivisionCode", divisionCode))
  59. .List<Bank>();
  60. }
  61. }
  62. }
Add Comment
Please, Sign In to add comment