public UserProfile GetByName(string firstname, string lastname) { UserProfile user = null; try { var query = "SELECT * FROM UserProfile u WHERE u.firstname='" + firstname + "' and u.lastname='" + lastname + "'"; var users = _dac.SelectByQuery <UserProfile>(query); if (users != null) { if (users.Count > 0) { user = users[0]; } } else { throw new Exception(Errors.ERR_PROFILEM_PROFILE_NOT_FOUND); } } catch (Exception err) { throw new Exception(Errors.ERR_PROFILEM_BADREQUEST, err); } return(user); }
public List <Entity> GetAllByDomain(string domain) { List <Entity> entityList = null; try { var query = "SELECT * FROM Entity e WHERE e.domain='" + domain + "'"; entityList = _dac.SelectByQuery <Entity>(query); } catch (Exception err) { throw new Exception(Errors.ERR_REFM_BADREQUEST, err); } return(entityList); }