public async Task SelectAsyncFact()
{
var connection = this.Factory.CreateConnection();
var transaction = default(DbTransaction);
var token = CancellationToken.None;
try
{
connection.Open();
transaction = connection.BeginTransaction(IsolationLevel.Serializable);
// 登録
var entity = new MembershipEntity()
{
ID = 0,
Name = string.Format("MembershipsGatewayFacts.FindAsyncFact(new MembershipEntity {{ Name={0} }}) ", new Random().Next()),
Password = @"password",
Enabled = true,
Email = @"*****@*****.**",
CreatedOn = DateTime.Now,
// UpdatedOn = CreatedOn,
};
var inserted = await MembershipsGateway.InsertAsync(entity, connection, transaction, token);
Assert.True(0 < inserted);
// 取得
var criteria = new MembershipsCriteria()
{
ID = inserted,
};
var selected = await MembershipsGateway.SelectAsync(criteria, connection, transaction, token);
Assert.True(selected.Read());
selected.Close();
// 削除
var deleted = await MembershipsGateway.DeleteAsync(inserted, connection, transaction, token);
Assert.True(deleted == 1);
transaction.Commit();
}
catch
{
if (transaction != null)
{
transaction.Rollback();
}
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
/// <summary>
///
/// </summary>
/// <param name="criteria"></param>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public static KandaDbDataReader Select(MembershipsCriteria criteria, DbConnection connection, DbTransaction transaction)
{
var reader = KandaTableDataGateway._factory.CreateReader(connection, transaction);
reader.CommandText = @"usp_SelectMemberships";
KandaDbDataMapper.MapToParameters(reader, criteria);
reader.ExecuteReader();
return(reader);
}
public static async Task <DbDataReader> SelectAsync(MembershipsCriteria criteria, DbConnection connection, DbTransaction transaction, CancellationToken token)
{
var reader = _factory.CreateReader(connection, transaction);
reader.CommandText = @"usp_SelectMemberships";
KandaDbDataMapper.MapToParameters(reader, criteria);
var result = await reader.ExecuteReaderAsync(token);
return(reader);
}
/// <summary>
///
/// </summary>
/// <param name="criteria"></param>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public KandaDbDataReader Select(MembershipsCriteria criteria, DbConnection connection, DbTransaction transaction)
{
var reader = KandaTableDataGateway._factory.CreateReader(connection, transaction);
reader.CommandText = @"usp_SelectMembershipsView";
KandaDbDataMapper.MapToParameters(reader, criteria);
var result = KandaTableDataGateway._factory.CreateParameter(KandaTableDataGateway.RETURN_VALUE, DbType.Int32, sizeof(int), ParameterDirection.Output, DBNull.Value);
reader.Parameters.Add(result);
reader.ExecuteReader();
return(reader);
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <param name="password"></param>
/// <returns></returns>
public static bool Validate(string name, string password)
{
var connection = default(DbConnection);
var transaction = default(DbTransaction);
try
{
connection = KandaProviderFactory.Instance.CreateConnection();
connection.Open();
transaction = connection.BeginTransaction(IsolationLevel.ReadUncommitted);
var criteria = new MembershipsCriteria()
{
Name = name,
Password = password,
Enabled = true,
//ID = ,
//CreatedOn = ,
//UpdatedOn = ,
};
var count = KandaRepository.Memberships.Get(criteria, connection, transaction).Count();
return(count == 1);
}
catch
{
if (transaction != null)
{
transaction.Rollback();
}
throw;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public IEnumerable <MembershipEntity> Get(MembershipsCriteria criteria, DbConnection connection, DbTransaction transaction)
{
var reader = default(DbDataReader);
try
{
reader = MembershipsGateway.Select(criteria, connection, transaction);
var memberships = KandaDbDataMapper.MapToEnumerable <MembershipEntity>(reader);
return(memberships);
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
public async Task <MembershipEntity> FindAsync(MembershipsCriteria criteria, DbConnection connection, DbTransaction transaction, CancellationToken token)
{
var reader = default(DbDataReader);
try
{
reader = await MembershipsGateway.SelectAsync(criteria, connection, transaction, token);
var entity = await reader.ReadAsync()
? KandaDataMapper.MapToObject <MembershipEntity>(reader)
: MembershipEntity.Empty;
return(entity);
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
/// <summary>
///
/// </summary>
/// <param name="criteria"></param>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public MembershipEntity Find(MembershipsCriteria criteria, DbConnection connection, DbTransaction transaction)
{
var password = criteria.Password;
if (password == null)
{
this.DoNothing();
}
else
{
if (criteria.Password is SecureString)
{
password = ((SecureString)criteria.Password).GetString();
}
var hash = KandaHashAlgorithm.ComputeHash(typeof(SHA512Managed).FullName, (string)password, Encoding.Unicode);
password = hash;
}
criteria.Password = password;
var reader = default(KandaDbDataReader);
try
{
reader = MembershipsGateway.Select(criteria, connection, transaction);
var found = (reader.Read() ? KandaDbDataMapper.MapToObject <MembershipEntity>(reader) : MembershipEntity.Empty);
return(found);
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
public async void FindAsyncFact()
{
var connection = this.Factory.CreateConnection();
var transaction = default(DbTransaction);
var criteria = new MembershipsCriteria()
{
ID = 10003,
Enabled = true,
};
try
{
await connection.OpenAsync();
transaction = connection.BeginTransaction();
var entity = await KandaRepository.Memberships.FindAsync(criteria, connection, transaction, CancellationToken.None);
transaction.Commit();
Assert.NotEqual(criteria.ID, entity.ID);
}
catch
{
if (transaction != null)
{
transaction.Rollback();
}
throw;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
public KandaDbDataReader Count(MembershipsCriteria criteria, DbConnection connection, DbTransaction transaction)
{
throw new NotImplementedException(@"MembershipsViewGateway.Count()");
}
