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