public UserData GetFromAccount(AccountData account) { if (account == null) { throw new ArgumentNullException("account"); } UserQuery query = new UserQuery(); query.Filter = new UserQuery.IdFilter(account.Id); var result = query.Execute().ToList(); if (result.Count > 0) { UserModel user = result[0]; return(new UserData() { Id = user.Identity, ImageFileLocation = $@"{Configuration.Instance.UserImageDirectoryPath}\{user.ImageFilename}", Firstname = user.Firstname, Middlename = user.Middlename, Lastname = user.Lastname, Gender = user.Gender, BirthDate = user.BirthDate, ContactNumber = user.ContactNumber, Email = user.Email, Address = user.Address }); } else { return(null); } }
public void foo() { UserQuery q = new UserQuery(); q.Filter = new UserQuery.NameFilter("The Name") .And(new UserQuery.GenderFilter(Common.Type.Gender.Male) .Or(new UserQuery.IdFilter(2)) .CreateBrackets()); q.Execute(); }
public UserTests() { Helpers.Loader.ReloadDb(); db = new CommandRunner("dvds"); var userQuery = new UserQuery(db) { Email = "*****@*****.**" }; user = userQuery.Execute(); //user = db.ExecuteSingle<User>("select * from users;"); }
public IHttpActionResult Query(UserQuery model) { if (!model.validate()) { return(BadRequest("Only select querys are granted !")); } try { return(Ok(model.Execute())); } catch (Exception ex) { return(InternalServerError(ex)); } }
public IEnumerable <UserData> GetUsers() { UserQuery query = new UserQuery(); List <UserModel> userModels = query.Execute().ToList(); return(from user in userModels select new UserData() { Id = user.Identity, ImageFileLocation = $@"{Configuration.Instance.UserImageDirectoryPath}\{user.ImageFilename}", Firstname = user.Firstname, Middlename = user.Middlename, Lastname = user.Lastname, Gender = user.Gender, BirthDate = user.BirthDate, ContactNumber = user.ContactNumber, Email = user.Email, Address = user.Address }); }