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);
}
