public Account GetAccount(int accountId)
{
var result = QueryStoreProcedure("GetAccount", new Dictionary<string, object>
{
{"param_id", accountId}
});
if (result.Tables[0].Rows.Count > 0)
{
var account = new Account().FromRow(result.Tables[0].Rows[0]);
return account;
}
return null;
}
public Account AddAccount(Account newAccount)
{
long newAccountId = idGen.NextId;
var result = QueryStoreProcedure("AddAccount", new Dictionary<string, object>
{
{"param_id", newAccountId},
{"param_name", newAccount.Name??string.Empty},
{"param_email", newAccount.Email??string.Empty},
{"param_statusId", (byte)AccountStatusType.Active},
{"param_clientInfo", newAccount.ClientInfo }
});
if (result.Tables[0].Rows.Count > 0)
{
var acct = new Account().FromRow(result.Tables[0].Rows[0]);
return acct;
}
return null;
}
public Account GetAccountByIdentity(IdentityType idType, string idValue)
{
var result = QueryStoreProcedure("GetAccountByIdentity", new Dictionary<string, object>
{
{"param_identityTypeId", (byte)idType},
{"param_identityValue", idValue.ToLower()},
});
if (result.Tables[0].Rows.Count > 0)
{
var acct = new Account().FromRow(result.Tables[0].Rows[0]);
return acct;
}
return null;
}
public Account UpdateAccount(Account newAccount)
{
var result = QueryStoreProcedure("UpdateAccount", new Dictionary<string, object>
{
{"param_id", newAccount.Id},
{"param_name", newAccount.Name},
{"param_email", newAccount.Email},
{"param_statusId", (byte)newAccount.Status},
});
if (result.Tables[0].Rows.Count > 0)
{
var acct = new Account().FromRow(result.Tables[0].Rows[0]);
return acct;
}
return null;
}
