Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public List<PhonePool> GetListForUser(int userId)
- {
- List<PhonePool> resultList;
- using (var conn = GetConnection())
- {
- conn.Open();
- var conditions = Predicates.Field<PhonePool>(f => f.UserId, Operator.Eq, userId);
- var sort = new List<ISort> {Predicates.Sort<PhonePool>(f => f.Name)};
- resultList = conn.GetList<PhonePool>(conditions, sort).ToList();
- var poolIds = string.Join(", ", from r in resultList select r.Id);
- var sql = string.Format(@"SELECT * FROM Phone WHERE [PhonePoolId] IN ({0})", poolIds);
- var phones = conn.Query<Phone>(sql).ToList();
- foreach (var pool in resultList)
- {
- var id = pool.Id;
- var poolPhones = from p in phones where p.PhonePoolId == id select p;
- foreach (var p in poolPhones)
- {
- pool.AddPhone(p);
- }
- }
- }
- return resultList;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement