public static DbDataReader Select(RoleEntity role, DbConnection connection, DbTransaction transaction)
{
var reader = KandaTableDataGateway._factory.CreateReader(connection, transaction);
reader.CommandText = @"usp_SelectRoles";
KandaDbDataMapper.MapToParameters(reader, role);
return reader.ExecuteReader();
}
public static int Update(RoleEntity entity, DbConnection connection, DbTransaction transaction)
{
var command = KandaTableDataGateway._factory.CreateCommand(connection, transaction);
command.CommandText = @"usp_UpdateRoles";
KandaDbDataMapper.MapToParameters(command, entity);
var result = KandaTableDataGateway._factory.CreateParameter(@"Result", DbType.Int32, sizeof(int), ParameterDirection.ReturnValue, DBNull.Value);
command.Parameters.Add(result);
command.ExecuteNonQuery();
return (int)result.Value;
}
/// <summary>
///
/// </summary>
/// <param name="entity"></param>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public bool Update(RoleEntity entity, DbConnection connection, DbTransaction transaction)
{
var updated = RolesGateway.Update(entity, connection, transaction);
return (updated == 1);
}
/// <summary>
///
/// </summary>
/// <param name="entity"></param>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public bool Create(RoleEntity entity, DbConnection connection, DbTransaction transaction)
{
var created = RolesGateway.Insert(entity, connection, transaction);
return (created == 1);
}