public AccountEntity GetById(long id)
{
var ret = new AccountEntity();
var parameter = new[]
{
new SqlParameter("@Id", id)
};
using (var conn = new SqlConnection(SQLHelper.GetConnectionString()))
{
SqlDataReader rdr = SQLHelper.ExecuteReader(
conn,
CommandType.Text,
@" SELECT
Id,
LoginName,
AccountNumber,
Balance,
CreateDate,
Version
FROM
dbo.Account
WHERE
Id = @Id",
parameter);
ret = AccountEntityMapper.ToEntity(rdr);
}
return(ret);
}
public AccountEntity GetByLoginName(string loginName)
{
var ret = new AccountEntity();
var parameter = new[]
{
new SqlParameter("@LoginName", loginName)
};
using (var conn = new SqlConnection(SQLHelper.GetConnectionString()))
{
SqlDataReader rdr = SQLHelper.ExecuteReader(
conn,
CommandType.Text,
@" SELECT
Id,
LoginName,
AccountNumber,
Balance,
CreateDate,
Password
FROM
dbo.Account
WHERE
LoginName = @LoginName",
parameter);
ret = AccountEntityMapper.ToEntityWithPassword(rdr);
}
return(ret);
}
public long GetNextAccountId(string loginName)
{
var parameter = new[]
{
new SqlParameter("@LoginName", loginName),
};
using (var conn = new SqlConnection(SQLHelper.GetConnectionString()))
{
SqlDataReader rdr = SQLHelper.ExecuteReader(
conn,
CommandType.Text,
@"INSERT INTO
dbo.AccountNumber
(LoginName)
SELECT @LoginName;
SELECT @@IDENTITY AS 'AccountNumber'",
parameter);
return(AccountEntityMapper.ToAccountNumberEntity(rdr));
}
}
