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