Advertisement
evilbloodydemon

Untitled

Dec 18th, 2012
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.12 KB | None | 0 0
  1.         public List<PhonePool> GetListForUser(int userId)
  2.         {
  3.             List<PhonePool> resultList;
  4.  
  5.             using (var conn = GetConnection())
  6.             {
  7.                 conn.Open();
  8.  
  9.                 var conditions = Predicates.Field<PhonePool>(f => f.UserId, Operator.Eq, userId);
  10.                 var sort = new List<ISort> {Predicates.Sort<PhonePool>(f => f.Name)};
  11.  
  12.                 resultList = conn.GetList<PhonePool>(conditions, sort).ToList();
  13.  
  14.                 var poolIds = string.Join(", ", from r in resultList select r.Id);
  15.                 var sql = string.Format(@"SELECT * FROM Phone WHERE [PhonePoolId] IN ({0})", poolIds);
  16.                 var phones = conn.Query<Phone>(sql).ToList();
  17.  
  18.                 foreach (var pool in resultList)
  19.                 {
  20.                     var id = pool.Id;
  21.                     var poolPhones = from p in phones where p.PhonePoolId == id select p;
  22.  
  23.                     foreach (var p in poolPhones)
  24.                     {
  25.                         pool.AddPhone(p);
  26.                     }
  27.                 }
  28.             }
  29.  
  30.             return resultList;
  31.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement