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