/// <summary>
/// Returns accounts the users is not a member of
/// </summary>
/// <param name="userUUID"></param>
/// <returns></returns>
public List <Account> GetNonMemberAccounts(string userUUID)
{
string sql = @"SELECT
Accounts.Id,
Accounts.ParentId,
Accounts.UUID,
Accounts.UUIDType,
Accounts.UUParentID,
Accounts.UUParentIDType,
Accounts.Name,
Accounts.Status,
UsersInAccount.MemberUUID
FROM
Accounts ,
UsersInAccount
WHERE
UsersInAccount.MemberUUID <> @MEMBERID OR
Accounts.UUID <> '' and Accounts.Deleted = 0";
DynamicParameters p = new DynamicParameters();
p.Add("@MEMBERID", userUUID);
List <Account> userAccounts;
using (var context = new TreeMonDbContext(this._connectionKey))
{
userAccounts = context.Select <Account>(sql, p).ToList();
}
//if (!this.DataAccessAuthorized(u, "GET", false)) return ServiceResponse.Error("You are not authorized this action.");
return(userAccounts);
}
public void TreeMonDbContext_Context_Select_MSSQL()
{
TreeMonDbContext context = new TreeMonDbContext("MSSQL_TEST");
_user = context.GetAll <User>().FirstOrDefault();
DynamicParameters parameters = new DynamicParameters();//dapper
parameters.Add("@NAME", _user.Name);
// List<SqlParameter> parameters = new List<SqlParameter>();
// parameters.Add(new SqlParameter("@NAME", _user.Name));
List <User> users = context.Select <User>("SELECT * FROM USERS WHERE Name=@NAME", parameters).ToList();
Assert.AreEqual(users.Count(), 1);
Assert.AreEqual(users[0].Name, _user.Name);
}
